array('name'=>'Officer', 'fld'=>array('officerId','officerNameEng','officerSurnameEng','officerEmail','ofPicturePath')), 'new' =>array('name'=>'PersonT', 'fld'=>array('personId','fName2','lName2','emailAddr','pic')), 'ref' =>array('fld'=>array('-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','picpath/ofPicturePath/ ')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'?', 'qry' =>" SELECT officerId,officerNameEng,officerSurnameEng,officerEmail,TRIM(REPLACE(ofPicturePath,'../pictureT/','')) FROM $dbreg.`Officer` WHERE ofSitId = 1 AND officerCode NOT IN (SELECT personCode FROM $dbppc.`Person` ) ORDER BY officerId"), array('old' =>array('name'=>'Officer', 'fld'=>array('officerId','officerCode','prefixId','officerName','officerSurname','officerStatus')), 'new' =>array('name'=>'Person', 'fld'=>array('personId','personCode','prefixId','fName','lName','fStatus')), 'ref' =>array('fld'=>array('-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'?', 'qry' =>" SELECT officerId,officerCode,prefixId,officerName,officerSurname,officerStatus FROM $dbreg.`Officer` WHERE ofSitId = 1 AND officerCode NOT IN (SELECT personCode FROM $dbppc.`Person` ) ORDER BY officerId"), array('old' =>array('name'=>'Officer', 'fld'=>array('-','contactAddress','contactPhone','prefixId','contactPhone','officerName','officerSurname')), 'new' =>array('name'=>'Personout', 'fld'=>array('outtypeId','address','phone','prefixId','workPhone','fName','lName')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array('0'), 'sql' =>'?', 'qry' => " SELECT '3', contactAddress, contactPhone, prefixId, contactPhone, officerName, officerSurname FROM $dbreg.`Officer` WHERE ofSitId = 2 "), array('old' =>array('name'=>'Building', 'fld'=>array('-','-','-','-','-','-','-','-','buildingName')), 'new' =>array('name'=>'spc_Place', 'fld'=>array('plRmNo','plFloor','plBuilding','plRtId','plIsRoom','plIsDom','plNumFloor','plCapacity','hwName')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('default/ /','default/0/','default/NULL/','default/NULL/','default/N/','default/1/','default/0/','-')), 'minus' =>array(), 'plus' =>array('0','1','2','3','4','5','6','7'), 'sql' => '?', 'qry' => " SELECT '','0',NULL,NULL,'N','N','1','0',buildingName FROM $dbreg.`Building` WHERE 1 "), /* OLD CODE: 'qry' => " SELECT '','0',NULL,NULL,'N','N','1','0',buildingName FROM $dbreg.`Building` WHERE buildingName NOT IN (SELECT hwName FROM $dbppc.`spc_Place`) " */ array('old' =>array('name'=>'Room', 'fld'=>array('roomNo','-','buildingId','-','-','-','-','capacity','roomNo')), 'new' =>array('name'=>'spc_Place', 'fld'=>array('plRmNo','plFloor','plBuilding','plRtId','plIsRoom','plIsDom','plNumFloor','plCapacity','hwName')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','default/1/','-','default/1/','default/Y/','default/0/','-','-')), 'minus' =>array(), 'plus' =>array('1','3','4','5'), 'sql' => '?', 'qry' => " SELECT roomNo,'1',buildingId,'1','Y','N','1',capacity,roomNo FROM $dbreg.`Room` WHERE 1 "), /* OLD CODE: 'qry' => " SELECT roomNo,'1',buildingId,'1','Y','N','1',capacity,roomNo FROM $dbreg.`Room` WHERE roomNo NOT IN (SELECT hwName FROM $dbppc.`spc_Place`) " */ array('old' =>array('name'=>'Dom', 'fld'=>array('-','-','-','-','-','-','-','-','domName')), 'new' =>array('name'=>'spc_Place', 'fld'=>array('plRmNo','plFloor','plBuilding','plRtId','plIsRoom','plIsDom','plNumFloor','plCapacity','hwName')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('default/ /','default/1/','default/NULL/','default/NULL/','default/N/','default/1/','default/0/','-')), 'minus' =>array(), 'plus' =>array('0','1','2','3','4','5','6','7'), 'sql' => '?', 'qry' => " SELECT '','1',NULL,NULL,'N','Y','1','0',domName FROM $dbreg.`Dom` WHERE 1 ") ); /* OLD CODE: 'qry' => " SELECT '','1','NULL','28','N','Y','1','0',domName FROM $dbreg.`Dom` WHERE domName NOT IN (SELECT hwName FROM $dbppc.`spc_Place`) "*/ /* */ ?>