~ubuntu-branches/ubuntu/vivid/gosa/vivid

$str = "SELECT c.name FROM glpi_computer_device as d, glpi_computers as c WHERE d.FK_computers=c.ID AND FK_device=".$item['ID']." AND device_type=".$deviceMappingTableNameID[$type]." ;";

638

}

639

640

$res = $this->query($str);

641

642

foreach($res as $val){

643

$ret[$val['name']] = $val['name'];

644

}

645

646

return($ret);//count($this->query($str)));

647

}else{

648

echo "not connected";

649

return(false);

650

}

651

652

}

653

654

655

/* This functions deletes a specified entry

656

* from our device tables

657

658

function deleteDevice($attr)

659

{

660

$deviceMappingGOsaGlpi = $this->deviceMappingGOsaGlpi;

661

if($this->is_connected){

662

$arr = array_flip($deviceMappingGOsaGlpi);

663

664

$device_type = $attr['device_type'];

665

unset($attr['device_type']);

666

667

$tbl_name = $arr[$device_type];

668

669

$this->query("DELETE FROM ".$tbl_name." WHERE ID=".$attr['ID'].";");

670

}else{

671

echo "not connected";

672

return(false);

673

}

674

}

675

676

/* This funtions updated an already existing device

677

678

function updateDevices($attr)

679

{

680

$deviceMappingGOsaGlpi = $this->deviceMappingGOsaGlpi;

681

if($this->is_connected){

682

$arr = array_flip($deviceMappingGOsaGlpi);

683

684

$device_type = $attr['device_type'];

685

unset($attr['device_type']);

686

687

$tbl_name = $arr[$device_type];

688

689

$str = "UPDATE ".$tbl_name." SET ";

690

foreach($attr as $name => $value){

691

$str.=$name."='".$value."', ";

692

}

693

$str = preg_replace("/, $/","",$str);

694

$str .= " WHERE ID=".$attr['ID'].";";

695

$this->query($str);

696

}else{

697

echo "not connected";

698

return(false);

699

}

700

}

701

702

/* Returns all possible RAM types

703

* like SDRAM , DIMM .....

704

705

function getRAMTypes()

706

{

707

if($this->is_connected){

708

$ret = array();

709

$tmp = ($this->query("SELECT * FROM glpi_dropdown_ram_type;"));

710

foreach($tmp as $t){

711

$ret[$t['ID']]=$t['name'];

712

}

713

return($ret);

714

}else{

715

echo "not connected";

716

return(false);

717

}

718

}

719

720

/* Returns all possible HDD connection types

721

* like IDE SCSI ...

722

723

function getGlpiDeviceControlTypes()

724

{

725

if($this->is_connected){

726

$ret = array();

727

$tmp = ($this->query("SELECT * FROM glpi_dropdown_hdd_type;"));

728

foreach($tmp as $t){

729

$ret[$t['ID']]=$t['name'];

730

}

731

return($ret);

732

}else{

733

echo "not connected";

734

return(false);

735

}

736

}

737

738

/* Returns all possible gfx card connection types

739

* like PCI-X PCI AGP ....

740

741

function getGlpiGfxControlTypes()

742

{

743

if($this->is_connected){

744

$ret = array();

745

$tmp = ($this->query("SELECT * FROM glpi_dropdown_hdd_type;"));

746

foreach($tmp as $t){

747

$ret[$t['ID']]=$t['name'];

748

}

749

return($ret);

750

}else{

751

echo "not connected";

752

return(false);

753

}

754

}

755

756

/* Devices

757

Adds a new single device to our db

758

759

function addDevice($attr)

760

{

761

$deviceMappingGOsaGlpi = $this->deviceMappingGOsaGlpi;

762

if($this->is_connected){

763

$arr = array_flip($deviceMappingGOsaGlpi);

764

765

$device_type = $attr['device_type'];

766

unset($attr['device_type']);

767

768

$tbl_name = $arr[$device_type];

769

$v = "";

770

$a = "";

771

foreach($attr as $name => $value){

772

$a .= $name.", ";

773

$v .= "'".$value."', ";

774

}

775

if(empty($v)){

776

echo "addDevice: no attributes given ";

777

return(false);

778

}else{

779

$a = preg_replace("/, $/","",$a);

780

$v = preg_replace("/, $/","",$v);

781

return($this->query("INSERT INTO ".$tbl_name." (".$a.") VALUES (".$v.");"));

782

}

783

784

}else{

785

echo "not connected";

786

return(false);

787

}

788

}

789

790

/* Return all available devices

791

792

function getDevices()

793

{

794

$deviceMappingGOsaGlpi = $this->deviceMappingGOsaGlpi;

795

if($this->is_connected){

796

$arr = $deviceMappingGOsaGlpi;

797

798

$res = array();

799

foreach($arr as $glpi => $gosa){

800

$qry = "SELECT * FROM ".$glpi.";";

801

$ret = $this->query($qry);

802

foreach($ret as $id => $entry){

803

$entry['device_type'] = $gosa;

804

805

if(isset($entry['designation'])){

806

$res[$entry['designation']."-".$gosa] = $entry;

807

}else{

808

$res[$entry['name']."-".$gosa] = $entry;

809

}

810

}

811

}

812

return($res);

813

}else{

814

echo "not connected";

815

return(false);

816

}

817

}

818

819

/* This function returns all used devices

820

821

function getUsedDevices($computerID)

822

{

823

$deviceMappingGOsaGlpi = array_flip($this->deviceMappingGOsaGlpi);

824

$deviceMappingTableNameID = $this->deviceMappingTableNameID;

825

826

if($this->is_connected){

827

$qry = "SELECT * FROM glpi_computer_device WHERE FK_computers=".$computerID.";";

828

$res = $this->query($qry);

829

830

$ret = array();

831

foreach($deviceMappingGOsaGlpi as $GOsa => $glpi){

832

$ret[$GOsa] = array();

833

}

834

835

$tbls = array_flip($deviceMappingTableNameID);

836

837

foreach($res as $device){

838

$devtype = $tbls[$device['device_type']];

839

$tbl_name = $deviceMappingGOsaGlpi[$devtype];

840

$qry = ("SELECT * FROM ".$tbl_name." WHERE ID=".$device['FK_device'].";");

841

$res2 = $this->query($qry);

842

if(count($res2)!=0){

843

$ret[$devtype][$res2[0]['designation']]=$res2[0];

844

}

845

846

$qry = "SELECT * FROM glpi_connect_wire WHERE type=4 AND end2=".$computerID.";";

847

$res2 = $this->query($qry);

848

foreach($res2 as $monitor){

849

$qry = "SELECT * FROM glpi_monitors WHERE ID=".$monitor['end1'].";";

850

$res3 = $this->query($qry);

851

foreach($res3 as $moni){

852

$ret['monitor'][$moni['name']]=$moni;

853

}

854

}

855

856

857

858

}

859

return($ret);

860

}else{

861

echo "not connected";

862

return(false);

863

}

864

}

865

866

/* This function removes all given devices from a computer, specified by $id

867

In the next step all devices specified by devices will be added.

868

869

function addDevicesToComputer($devices, $id)

870

{

871

$deviceMappingGOsaGlpi = array_flip($this->deviceMappingGOsaGlpi);

872

$deviceMappingTableNameID = $this->deviceMappingTableNameID;

873

874

if(($id == "" )||(!is_numeric($id))){

875

return (false);

876

}

877

if($this->is_connected){

878

$qry = "DELETE FROM glpi_computer_device WHERE FK_computers=".$id.";";

879

$this->query($qry);

880

881

foreach($devices as $type => $entries){

882

foreach($entries as $entry){

883

if($type=="monitor"){

884

$str = "INSERT INTO glpi_connect_wire (end1,end2,type)

885

VALUES (".$entry['ID'].",".$id.",4);";

886

}else{

887

$str = "INSERT INTO glpi_computer_device (device_type,FK_device,FK_computers)

888

VALUES (".$deviceMappingTableNameID[$type].",".$entry['ID'].",".$id.");";

889

}

890

$this->query($str);

891

}

892

}

893

894

895

}else{

896

echo "not connected";

897

return(false);

898

}

899

900

}

901

902

function removeComputerInformations($name)

903

{

904

if($this->is_connected){

905

$tmp = $this->query("SELECT * FROM glpi_computers WHERE name='".$name."';");

906

if(isset($tmp[0])){

907

$id = $tmp[0]['ID'];

908

$this->query("DELETE FROM glpi_connect_wire WHERE end2=".$id.";");

909

$this->query("DELETE FROM glpi_computer_device WHERE FK_computers=".$id.";");

910

return($this->query("DELETE FROM glpi_computers WHERE ID=".$id.";"));

911

}else{

912

echo "can't remove not existing entry";

913

return(false);

914

}

915

}else{

916

echo "not connected";

917

return(false);

918

}

919

}

920

921

function is_connected()

922

{

923

return($this->is_connected);

924

}

925

926

function addAttachmentsToComputer($attr,$id)

927

{

928

if(($id == "" )||(!is_numeric($id))){

929

return (false);

930

}

931

if($this->is_connected){

932

$qry = "DELETE FROM glpi_doc_device WHERE (FK_device=".$id.") AND (device_type=1);";

933

$this->query($qry);

934

935

foreach($attr as $aid => $entry){

936

$str = "INSERT INTO glpi_doc_device (FK_doc,FK_device,device_type,is_template)

937

VALUES

938

($aid,$id,1,'0');";

939

$this->query($str);

940

}

941

}else{

942

echo "not connected";

943

return(false);

944

}

945

}

946

947

function getAssignAttachments($id)

948

{

949

950

if($this->is_connected){

951

$qry= "SELECT * FROM glpi_doc_device WHERE (device_type=1) AND (FK_device=".$id.");";

952

$ret = $this->query($qry);

953

return($ret);

954

}else{

955

echo "not connected";

956

return(false);

957

}

958

}

959

960

function deleteAttachment($id)

961

{

962

if($this->is_connected){

963

$qry = "DELETE FROM glpi_docs WHERE ID=".$id."";

964

$this->query($qry);

965

}else{

966

echo "not connected";

967

return(false);

968

}

969

}

970

971

function getAttachments()

972

{

973

$ret = array();

974

if($this->is_connected){

975

$qry = "SELECT * FROM glpi_docs WHERE name!='';";

976

$re = $this->query($qry);

977

978

foreach($re as $entry){

979

$ret[$entry['ID']]=$entry;

980

}

981

982

return($ret);

983

}else{

984

echo "not connected";

985

return(false);

986

}

987

}

988

989

function saveAttachments($attrs,$id = -1)

990

{

991

if($this->is_connected){

992

$atr = array("name","filename","rubrique","mime","date_mod","comment","deleted","link");

993

$tmp = array();

994

foreach($atr as $at){

995

if(isset($attrs[$at])){

996

$tmp[$at] = $attrs[$at];

997

}

998

}

999

if(count($tmp)==0){

1000

return(false);

1001

}else{

1002

1003

// Add

1004

if($id == -1){

1005

$str = "INSERT INTO glpi_docs ";

1006

$namen = "";

1007

$values= "";

1008

foreach($tmp as $name => $value){

1009

$namen .= $name.", ";

1010

if(is_numeric($value)){

1011

$values .= $value.", ";

1012

}else{

1013

$values .= "'".$value."', ";

1014

}

1015

}

1016

$values = preg_replace("/, $/","",$values);

1017

$namen = preg_replace("/, $/","",$namen);

1018

$str .= "(".$namen.") VALUES (".$values.");";

1019

}else{

1020

$str = "UPDATE glpi_docs SET ";

1021

foreach($tmp as $name => $value){

1022

$str .= $name."= ";

1023

if(is_numeric($value)){

1024

$str .= $value.", ";

1025

}else{

1026

$str .= "'".$value."', ";

1027

}

1028

}

1029

$str = preg_replace("/, $/","",$str);

1030

$str .= " WHERE ID=".$id.";";

1031

}

1032

$this->query($str);

1033

}

1034

}else{

1035

echo "not connected";

1036

return(false);

1037

}

1038

}

1039

1040

1041

/* Check if given attachment id is used in any Device

1042

( - avoid removing of used attachments)

1043

1044

function is_attachmentUsed($id)

1045

{

1046

if($this->is_connected){

1047

$ret = array();

1048

$qry = "SELECT t.name FROM glpi_computers as t, glpi_doc_device WHERE t.ID = glpi_doc_device.FK_device AND FK_doc =".$id." LIMIT 3;";

1049

$res = $this->query($qry);

1050

foreach($res as $val){

1051

$ret[$val['name']] = $val['name'];

1052

}

1053

return($ret);

1054

}else{

1055

echo "not connected";

1056

return(false);

1057

}

1058

}

1059

1060

1061

/* Monitor handling

1062

1063

function getMonitors()

1064

{

1065

if($this->is_connected){

1066

$qry= "SELECT * FROM glpi_monitors;";

1067

return($this->query($qry));

1068

1069

}else{

1070

echo "not connected";

1071

return(false);

1072

}

1073

}

1074

1075

function updatedMonitor()

1076

{

1077

if($this->is_connected){

1078

// $qry= "SELECT * FROM glpi_monitors;";

1079

// return($this->query($qry));

1080

1081

}else{

1082

echo "not connected";

1083

return(false);

1084

}

1085

}

1086

1087

function addMonitor()

1088

{

1089

if($this->is_connected){

1090

// $qry= "SELECT * FROM glpi_monitors;";

1091

// return($this->query($qry));

1092

1093

}else{

1094

echo "not connected";

1095

return(false);

1096

}

1097

}

1098

1099

function removeMonitor($id)

1100

{

1101

if($this->is_connected){

1102

$qry= "DELETE FROM glpi_monitors WHERE ID=".$id.";";

1103

$this->query($qry);

1104

}else{

1105

echo "not connected";

1106

return(false);

1107

}

1108

}

1109

1110

function getMonitorTypes()

1111

{

1112

if($this->is_connected){

1113

$qry= "SELECT * FROM glpi_type_monitors;";

1114

return($this->query($qry));

1115

1116

}else{

1117

echo "not connected";

1118

return(false);

1119

}

1120

}

1121

1122

function getLocationTypes()

1123

{

1124

if($this->is_connected){

1125

$qry= "SELECT * FROM glpi_dropdown_locations;";

1126

return($this->query($qry));

1127

1128

}else{

1129

echo "not connected";

1130

return(false);

1131

}

1132

}

1133

1134

function getStateTypes()

1135

{

1136

if($this->is_connected){

1137

$qry= "SELECT * FROM glpi_dropdown_state;";

1138

return($this->query($qry));

1139

}else{

1140

echo "not connected";

1141

return(false);

1142

}

1143

}

1144

1145

1146

/* Printer functions

1147

1148

1149

/* is printer type used ?

1150

1151

function is_printerTypeUsed($id)

1152

{

1153

if($this->is_connected){

1154

$qry = "SELECT * FROM glpi_printers WHERE type=".$id.";";

1155

$res = $this->query( $qry);

1156

$ret =array();

1157

foreach($res as $entry){

1158

$ret[$entry['ID']] = $entry['name'];

1159

}

1160

return($ret);

1161

}else{

1162

echo "not connected";

1163

return(false);

1164

}

1165

}

1166

1167

/* This functions checks if the selected computer/network

1168

device is already available in the db

1169

1170

function is_printer_account($dn)

1171

{

1172

if(!$this->is_connected){

1173

$this->lasterror ="Can't query anything, if we aren't connected.";

1174

return(false);

1175

}else{

1176

$qry = "SELECT * FROM glpi_printers WHERE name='".$dn."';";

1177

$res = $this->query($qry);

1178

if(count($res)==0){

1179

return(false);

1180

}else{

1181

return(true);

1182

}

1183

}

1184

}

1185

1186

/* This function returns all available data

1187

from a specified dn

1188

1189

function getPrinterInformations($name)

1190

{

1191

if($this->is_connected){

1192

$ret = $this->query("SELECT * FROM glpi_printers WHERE name='".$name."';");

1193

return($ret);

1194

}else{

1195

echo "not connected";

1196

return(false);

1197

}

1198

}

1199

1200

/* Get Printer attachments

1201

1202

function getAssignPrinterAttachments($id)

1203

{

1204

1205

if($this->is_connected){

1206

$qry= "SELECT * FROM glpi_doc_device WHERE (device_type=3) AND (FK_device=".$id.");";

1207

$ret = $this->query($qry);

1208

return($ret);

1209

}else{

1210

echo "not connected";

1211

return(false);

1212

}

1213

}

1214

1215

/* Printer types

1216

Returns all defined printer types

1217

1218

function getPrinterTypes()

1219

{

1220

if($this->is_connected){

1221

$ret = array();

1222

$tmp = ($this->query("SELECT * FROM glpi_type_printers ORDER BY name; "));

1223

foreach($tmp as $t){

1224

$ret[$t['ID']]=$t['name'];

1225

}

1226

return($ret);

1227

}else{

1228

echo "not connected";

1229

return(false);

1230

}

1231

}

1232

1233

/* Add pritner types

1234

Add one entry to the printer types

1235

1236

function addPrinterType($name)

1237

{

1238

if($this->is_connected){

1239

$tmp = $this->query("SELECT * FROM glpi_type_printers WHERE name='".$name."';");

1240

if(isset($tmp[0])){

1241

//echo "such an entry already exists";

1242

return(false);

1243

}else{

1244

return($this->query("INSERT INTO glpi_type_printers (name) VALUES ('".$name."');"));

1245

}

1246

}else{

1247

echo "not connected";

1248

return(false);

1249

}

1250

}

1251

1252

/* remove printer types

1253

Remove one entry from the printer types (specified by ID=$id)

1254

1255

function removePrinterType($id)

1256

{

1257

if($this->is_connected){

1258

$tmp = $this->query("SELECT * FROM glpi_type_printers WHERE ID=".$id.";");

1259

if(isset($tmp[0])){

1260

return($this->query("DELETE FROM glpi_type_printers WHERE ID=".$id.";"));

1261

}else{

1262

echo "can't remove not existing entry";

1263

return(false);

1264

}

1265

}else{

1266

echo "not connected";

1267

return(false);

1268

}

1269

}

1270

1271

/* Update printer types

1272

Update a printer type

1273

1274

function updatePrinterType($name,$id)

1275

{

1276

1277

if($this->is_connected){

1278

$tmp = $this->query("SELECT * FROM glpi_type_printers WHERE ID=".$id.";");

1279

if(isset($tmp[0])){

1280

return($this->query("UPDATE glpi_type_printers SET name='".$name."' WHERE ID=".$id.";"));

1281

}else{

1282

echo "can't update not existing entry";

1283

return(false);

1284

}

1285

}else{

1286

echo "not connected";

1287

return(false);

1288

}

1289

}

1290

1291

1292

/* This fucntions updates an already existing entry

1293

1294

function updatePrinterInformations($array,$name)

1295

{

1296

if(!is_array($array)){

1297

echo "updatePrinterInformations: first paraeter must be an array";

1298

}elseif($this->is_connected){

1299

$tmp = $this->query("SELECT * FROM glpi_printers WHERE name='".$name."';");

1300

if(isset($tmp[0])){

1301

1302

$atr = array( "ID","name","serial","otherserial","contact","contact_num",

1303

"tech_num","comments","date_mod","location","domain","network","ramSize","flags_serial","flags_par","flags_usb",

1304

"model","type","is_template","tplname","FK_glpi_enterprise","deleted");

1305

$v = "";

1306

foreach($atr as $at){

1307

if(isset($array[$at])){

1308

$v .= " ".$at."='".$array[$at]."', ";

1309

}

1310

}

1311

if(empty($v)){

1312

echo "updateSystemInformations: no attributes given ";

1313

return(false);

1314

}else{

1315

$v = preg_replace("/, $/","",$v);

1316

return($this->query("UPDATE glpi_printers SET ".$v." WHERE name='".$name."';"));

1317

}

1318

}else{

1319

echo "can't update not existing entry";

1320

return(false);

1321

}

1322

}else{

1323

echo "not connected";

1324

return(false);

1325

}

1326

1327

}

1328

1329

/* This function adds a new inventory settings for printers

1330

1331

function addPrinterInformations($array)

1332

{

1333

if(!is_array($array)){

1334

echo "updateComputerInformations: first paraeter must be an array";

1335

}elseif($this->is_connected){

1336

$atr = array( "ID","name","serial","otherserial","contact","contact_num",

1337

"tech_num","comments","date_mod","os","location","domain","network","ramSize","flags_serial","flags_par","flags_usb",

1338

"model","type","is_template","tplname","FK_glpi_enterprise","deleted");

1339

$v = "";

1340

$a = "";

1341

foreach($atr as $at){

1342

if(isset($array[$at])){

1343

$a .= $at.", ";

1344

$v .= "'".$array[$at]."', ";

1345

}

1346

}

1347

if(empty($v)){

1348

echo "updateComputerInformations: no attributes given ";

1349

return(false);

1350

}else{

1351

$a = preg_replace("/, $/","",$a);

1352

$v = preg_replace("/, $/","",$v);

1353

return($this->query("INSERT INTO glpi_printers (".$a.") VALUES (".$v.");"));

1354

}

1355

1356

}else{

1357

echo "not connected";

1358

return(false);

1359

}

1360

}

1361

1362

/* add atachment to given printer */

1363

function addAttachmentsToPrinter($attr,$id)

1364

{

1365

if(($id == "" )||(!is_numeric($id))){

1366

return (false);

1367

}

1368

if($this->is_connected){

1369

$qry = "DELETE FROM glpi_doc_device WHERE (FK_device=".$id.") AND (device_type=3);";

1370

$this->query($qry);

1371

1372

foreach($attr as $aid => $entry){

1373

$str = "INSERT INTO glpi_doc_device (FK_doc,FK_device,device_type,is_template)

1374

VALUES

1375

($aid,$id,3,'0');";

1376

$this->query($str);

1377

}

1378

}else{

1379

echo "not connected";

1380

return(false);

1381

}

1382

}

1383

1384

function removePrinterInformations($name)

1385

{

1386

if($this->is_connected){

1387

$tmp = $this->query("SELECT * FROM glpi_printers WHERE name='".$name."';");

1388

if(isset($tmp[0])){

1389

$id = $tmp[0]['ID'];

1390

// $this->query("DELETE FROM glpi_connect_wire WHERE end2=".$id.";");

1391

$this->query("DELETE FROM glpi_doc_device WHERE FK_device=".$id." AND device_type=3;");

1392

return($this->query("DELETE FROM glpi_printers WHERE ID=".$id.";"));

1393

}else{

1394

echo "can't remove not existing entry";

1395

return(false);

1396

}

1397

}else{

1398

echo "not connected";

1399

return(false);

1400

}

1401

}

1402

1403

1404

/* Cartridges

1405

1406

/* return all assigned cartridges */

1407

function getUsedCartridges($printerID)

1408

{

1409

if($this->is_connected){

1410

$ret = array();

1411

$qry = "SELECT

1412

c.date_use as date_use,

1413

c.ID as ID,

1414

t.ID as type_ID,

1415

t.name as name,

1416

c.FK_glpi_printers as FK_glpi_printers,

1417

d.name as type_name

1418

FROM

1419

glpi_dropdown_cartridge_type as d,

1420

glpi_cartridges as c,

1421

glpi_cartridges_type as t

1422

WHERE c.FK_glpi_cartridges_type = t.ID

1423

AND t.type = d.ID

1424

AND c.FK_glpi_printers = ".$printerID.";";

1425

$res = $this->query($qry);

1426

foreach($res as $entry){

1427

$ret[$entry['ID']] = $entry;

1428

}

1429

return($ret);

1430

}else{

1431

echo "not connected";

1432

return(false);

1433

}

1434

}

1435

1436

/* return all assigned cartridges */

1437

function getAvailableCartridgeTypes($printerTypeID)

1438

{

1439

if($this->is_connected){

1440

$ret = array();

1441

$qry= "

1442

SELECT

1443

ct.ID as cartridgeID,

1444

ct.name as cartridgeName,

1445

pt.ID as printerTypeID,

1446

pt.name as printerTypeName,

1447

ct.type as cartridgeTypeID,

1448

dt.name as cartridgeTypeName

1449

FROM

1450

glpi_type_printers as pt,

1451

glpi_cartridges_type as ct,

1452

glpi_dropdown_cartridge_type as dt,

1453

glpi_cartridges_assoc as ac

1454

WHERE

1455

ac.FK_glpi_type_printer = pt.ID

1456

AND ac.FK_glpi_cartridges_type = ct.ID

1457

AND ct.type=dt.ID

1458

AND pt.ID=".$printerTypeID.";";

1459

$res = $this->query($qry);

1460

foreach($res as $entry){

1461

$ret[$entry['cartridgeID']] = $entry;

1462

}

1463

return($ret);

1464

}else{

1465

echo "not connected";

1466

return(false);

1467

}

1468

}

1469

1470

function removeCartridgeFromPrinter($cartridgeID)

1471

{

1472

if($this->is_connected){

1473

$qry = "DELETE FROM glpi_cartridges WHERE ID=".$cartridgeID.";";

1474

return($this->query($qry));

1475

}else{

1476

echo "not connected";

1477

return(false);

1478

}

1479

}

1480

1481

function addCartridgeFromPrinter($printerID,$cartridgeID)

1482

{

1483

if($this->is_connected){

1484

$qry ="INSERT INTO

1485

glpi_cartridges (FK_glpi_cartridges_type,FK_glpi_printers,date_in,date_use)

1486

VALUES

1487

(".$cartridgeID.",".$printerID.",'".date("Y-m-d")."','".date("Y-m-d")."');";

1488

return($this->query($qry));

1489

}else{

1490

echo "not connected";

1491

return(false);

1492

}

1493

}

1494

1495

function is_cartridgeTypeUsed($id){

1496

if($this->is_connected){

1497

$qry = "SELECT p.ID,p.name as name FROM glpi_cartridges as c,glpi_printers as p WHERE p.ID=c.FK_glpi_printers AND c.FK_glpi_cartridges_type=".$id.";";

1498

$res = $this->query($qry);

1499

$ret =array();

1500

foreach($res as $entry){

1501

$ret[$entry['ID']] = $entry['name'];

1502

}

1503

return($ret);

1504

}else{

1505

echo "not connected";

1506

return(false);

1507

}

1508

}

1509

1510

function getCartridgeTypeInformations($id = "all"){

1511

if($this->is_connected){

1512

$ret = array();

1513

if($id != "all"){

1514

$qry = "SELECT * FROM glpi_cartridges_type WHERE ID = ".$id.";";

1515

}else{

1516

$qry = "SELECT * FROM glpi_cartridges_type;";

1517

}

1518

1519

$res = ($this->query($qry));

1520

foreach($res as $entry){

1521

$ret[$entry['ID']] = $entry;

1522

}

1523

return($ret);

1524

1525

}else{

1526

echo "not connected";

1527

return(false);

1528

}

1529

}

1530

1531

function getCartridgeTypes(){

1532

if($this->is_connected){

1533

$ret = array();

1534

$qry = "SELECT * FROM glpi_dropdown_cartridge_type;";

1535

$res = ($this->query($qry));

1536

foreach($res as $entry){

1537

$ret[$entry['ID']] = $entry['name'];

1538

}

1539

return($ret);

1540

1541

}else{

1542

echo "not connected";

1543

return(false);

1544

}

1545

}

1546

1547

1548

1549

/* check if given manufacturer ID ist still in use.

1550

The problem is, that nearly every table uses manufacturers ....

1551

1552

function is_manufacturerUsed($id)

1553

{

1554

if($this->is_connected){

1555

$tables = array();

1556

foreach($this->deviceMappingGOsaGlpi as $entry => $table){

1557

$tables[] = $entry;

1558

}

1559

$tables[] ="glpi_computers";

1560

$tables[] ="glpi_cartridges_type";

1561

$ret = array();

1562

$i = 3;

1563

foreach($tables as $tbl){

1564

if($i <= 0 ) continue;

1565

$qry = "SELECT * FROM ".$tbl." WHERE FK_glpi_enterprise = ".$id.";";

1566

$res = $this->query($qry);

1567

foreach($res as $entry){

1568

if($i <= 0 ) continue;

1569

if(isset($entry['designation'])){

1570

$entry['name'] = $entry['designation'];

1571

}

1572

$i --;

1573

$ret[] = $entry['name'];

1574

}

1575

}

1576

return($ret);

1577

}else{

1578

echo "not connected";

1579

return(false);

1580

}

1581

}

1582

1583

/* Manufacturer

1584

Updates already existing manufacturer

1585

1586

function Add_UpdateCatrigdeType($array,$array_printer_types)

1587

{

1588

if(!is_array($array)){

1589

echo "Add_UpdateCatrigdeType: first paraeter must be an array";

1590

}elseif($this->is_connected){

1591

1592

1593

$atr = array("name","ref","location","type","FK_glpi_enterprise","tech_num","deleted","comments","alarm");

1594

1595

/* Entry was edited */

1596

if($array['ID']>0){

1597

$qry = "DELETE FROM glpi_cartridges_assoc WHERE FK_glpi_cartridges_type=".$array['ID'].";";

1598

1599

$v = "";

1600

foreach($atr as $at){

1601

if(isset($array[$at])){

1602

$v .= " ".$at."='".$array[$at]."', ";

1603

}

1604

}

1605

if(empty($v)){

1606

echo "Add_UpdateCatrigdeType: no attributes given ";

1607

return(false);

1608

}else{

1609

$v = preg_replace("/, $/","",$v);

1610

$qry = "UPDATE glpi_cartridges_type SET ".$v." WHERE ID='".$array['ID']."';";

1611

$this->query($qry);

1612

}

1613

}else{

1614

1615

/* skip if name is in use*/

1616

$qry = "SELECT * FROM glpi_cartridges_type WHERE name='".$array['name']."';";

1617

if(count($this->query($qry))){

1618

return;

1619

}

1620

1621

$str = "INSERT INTO glpi_cartridges_type ";

1622

$namen = "";

1623

$values= "";

1624

foreach($array as $name => $value){

1625

$namen .= $name.", ";

1626

if(is_numeric($value)){

1627

$values .= $value.", ";

1628

}else{

1629

$values .= "'".$value."', ";

1630

}

1631

}

1632

$values = preg_replace("/, $/","",$values);

1633

$namen = preg_replace("/, $/","",$namen);

1634

$str .= "(".$namen.") VALUES (".$values.");";

1635

$this->query($str);

1636

$IDs = $this->query("SELECT ID FROM glpi_cartridges_type WHERE name='".$array['name']."';");

1637

if(count($IDs) > 1){

1638

echo "internal db error";

1639

return;

1640

}

1641

$array['ID'] = $IDs[0]['ID'];

1642

}

1643

1644

foreach($array_printer_types as $id){

1645

$qry = "INSERT INTO glpi_cartridges_assoc

1646

(FK_glpi_cartridges_type,FK_glpi_type_printer)

1647

VALUES

1648

(".$array['ID'].",".$id.")";

1649

1650

$this->query($qry);

1651

}

1652

}else{

1653

echo "not connected";

1654

return(false);

1655

}

1656

}

1657

1658

function getSupportedPrinterTypeIDsForCartridge($cid)

1659

{

1660

if($this->is_connected){

1661

$ret = array();

1662

$qry = "SELECT FK_glpi_type_printer FROM glpi_cartridges_assoc WHERE FK_glpi_cartridges_type = ".$cid.";";

1663

$res = $this->query($qry);

1664

1665

foreach($res as $entry => $value){

1666

$ret[$value['FK_glpi_type_printer']] = $value['FK_glpi_type_printer'];

1667

}

1668

return($ret);

1669

}else{

1670

echo "not connected";

1671

return(false);

1672

}

1673

}

1674

1675

function removeCartridgeType($id){

1676

if($this->is_connected){

1677

$qry = "DELETE FROM glpi_cartridges_assoc WHERE FK_glpi_cartridges_type=".$id.";";

1678

$this->query($qry);

1679

$qry = "DELETE FROM glpi_cartridges_type WHERE ID=".$id.";";

1680

return($this->query($qry));

1681

}else{

1682

echo "not connected";

1683

return(false);

1684

}

1685

}

1686

1687

function getCartridgesWhichUseThisType($id)

1688

{

1689

if($this->is_connected){

1690

$qry = "SELECT * FROM glpi_cartridges WHERE FK_glpi_cartridges_type=".$id.";";

1691

$ret = $this->query($qry);

1692

return($ret);

1693

}else{

1694

echo "not connected";

1695

return(false);

1696

}

1697

}

1698

1699

1700

/* Add pritner types

1701

Add one entry to the cartridgeType types

1702

1703

function addCartridgeDropdownType($name)

1704

{

1705

if($this->is_connected){

1706

$tmp = $this->query("SELECT * FROM glpi_dropdown_cartridge_type WHERE name='".$name."';");

1707

if(isset($tmp[0])){

1708

//echo "such an entry already exists";

1709

return(false);

1710

}else{

1711

return($this->query("INSERT INTO glpi_dropdown_cartridge_type (name) VALUES ('".$name."');"));

1712

}

1713

}else{

1714

echo "not connected";

1715

return(false);

1716

}

1717

}

1718

1719

/* remove cartridgeType types

1720

Remove one entry from the cartridgeType types (specified by ID=$id)

1721

1722

function removeCartridgeDropdownType($id)

1723

{

1724

if($this->is_connected){

1725

$tmp = $this->query("SELECT * FROM glpi_dropdown_cartridge_type WHERE ID=".$id.";");

1726

if(isset($tmp[0])){

1727

return($this->query("DELETE FROM glpi_dropdown_cartridge_type WHERE ID=".$id.";"));

1728

}else{

1729

echo "can't remove not existing entry";

1730

return(false);

1731

}

1732

}else{

1733

echo "not connected";

1734

return(false);

1735

}

1736

}

1737

1738

/* Update cartridgeType

1739

Update a cartridgeType

1740

1741

function updateCartridgeDropdownType($name,$id)

1742

{

1743

1744

if($this->is_connected){

1745

$tmp = $this->query("SELECT * FROM glpi_dropdown_cartridge_type WHERE ID=".$id.";");

1746

if(isset($tmp[0])){

1747

return($this->query("UPDATE glpi_dropdown_cartridge_type SET name='".$name."' WHERE ID=".$id.";"));

1748

}else{

1749

echo "can't update not existing entry";

1750

return(false);

1751

}

1752

}else{

1753

echo "not connected";

1754

return(false);

1755

}

1756

}

1757

1758

function getUsedDropdownTypes($id=false)

1759

{

1760

if($this->is_connected){

1761

if($id){

1762

$qry = "SELECT distinct(type) FROM glpi_cartridges_type WHERE type = ".$id.";";

1763

}else{

1764

$qry = "SELECT distinct(type) FROM glpi_cartridges_type;";

1765

}

1766

return($this->query($qry));

1767

}else{

1768

echo "not connected";

1769

return(false);

1770

}

1771

}

1772

1773

}

1774

//$s = new glpiDB("vserver-01","glpi","tester","glpi");

1775

//print_r($s->query("SELECT * FROM glpi_computers"));

1776

//$s->getComputerInformations("1 OR (c.ID<10000)");

1777

Older »