本文整理汇总了PHP中Table::getLists方法的典型用法代码示例。如果您正苦于以下问题:PHP Table::getLists方法的具体用法?PHP Table::getLists怎么用?PHP Table::getLists使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Table
的用法示例。
在下文中一共展示了Table::getLists方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1:
<?
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET SERVICE TYPE
$servicetypemst = new Table;
$servicetypemst->setSQLType($fms_db->getSQLType());
$servicetypemst->setInstance($fms_db->getInstance());
$servicetypemst->setView("v_servicetypemaster");
$servicetypemst->setParam("ORDER BY serviceTypeID");
$servicetypemst->doQuery("query");
$row_servicetypemst = $servicetypemst->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
?>
示例2:
// -- START EDIT MAKE --
if(isset($_GET['edit']) && !empty($_GET['edit']) && $_GET['edit'] == 1 && !empty($_GET['id'])){
$id = $_GET['id'];
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET MAKE
$make = new Table;
$make->setSQLType($fms_db->getSQLType());
$make->setInstance($fms_db->getInstance());
$make->setView("v_makemaster");
$make->setParam("WHERE makeID = '$id'");
$make->doQuery("query");
$row_make = $make->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
$status = $row_make[0]['status'];
}
// -- END EDIT CATEGORY --
// -- START UPDATE MAKE --
if(isset($_POST['update']) && !empty($_POST['update']) && $_POST['update'] == 1){
$id = $_GET['id'];
$makeName = $_POST['txtMakeName'];
$status = $_POST['txtStatus'];
// SET FMS DB
示例3: MessageAlert
$status = $_POST['txtStatus'];
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET CONTROL NO
$ctrlno = new Table;
$ctrlno->setSQLType($fms_db->getSQLType());
$ctrlno->setInstance($fms_db->getInstance());
$ctrlno->setTable("controlnomaster");
$ctrlno->setValues("description = '$desc', type = '$type', code = '$code', noOfDigit = '$noofdigit'
, lastDigit = '$lastdigit', modifiedBy = '$sys_UserID', modifiedDate = '$today', status = '$status'");
$ctrlno->setParam("WHERE id = '$id'");
$ctrlno->doQuery("update");
$row_ctrlno = $ctrlno->getLists();
$res_ctrlno = $ctrlno->getError();
// CLOSING FMS DB
$fms_db->DBClose();
$msg = null;
if($res_ctrlno > 0){
$url = BASE_URL . V_CONTROLNOEDIT . "edit=1&id=" . $id;
$msg .= "Sorry! There has been an error in updating your control no. Please check the data and update it again.";
}else{
$url = BASE_URL . V_CONTROLNO;
$msg .= "Control No successfully updated.";
}
$alert = new MessageAlert();
示例4: MessageAlert
$chkwourl->setParam("WHERE url = '$sesid'");
$chkwourl->doQuery("query");
$num_chkurl = $chkwourl->getNumRows();
$row_chkurl = $chkwourl->getLists();
$wourl_status = $row_chkurl[0]['status'];
// CHECK WORK ORDER
$wo_dtl = new Table;
$wo_dtl->setSQLType($fms_db->getSQLType());
$wo_dtl->setInstance($fms_db->getInstance());
$wo_dtl->setView("v_workorderdetail");
$wo_dtl->setParam("WHERE woReferenceNo = '$worefno'");
$wo_dtl->doQuery("query");
$num_wo_dtl = $wo_dtl->getNumRows();
$row_wo_dtl = $wo_dtl->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
if($num_chkwo == 0 || $num_chkurl == 0 || $wo_status != 1 || $wourl_status != 1){
$url = BASE_URL;
$msg = "Invalid URL!";
$alert = new MessageAlert();
$alert->setURL($url);
$alert->setMessage($msg);
$alert->Alert();
}
}
// -- END WORK ORDER FOR APPROVAL
示例5:
// -- START EDIT SUPPLIER --
if(isset($_GET['edit']) && !empty($_GET['edit']) && $_GET['edit'] == 1 && !empty($_GET['id'])){
$id = $_GET['id'];
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET SUPPLIER
$supplier = new Table;
$supplier->setSQLType($fms_db->getSQLType());
$supplier->setInstance($fms_db->getInstance());
$supplier->setView("v_suppliermaster");
$supplier->setParam("WHERE supplierID = '$id'");
$supplier->doQuery("query");
$row_supplier = $supplier->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
$status = $row_supplier[0]['status'];
}
// -- END EDIT SUPPLIER --
// -- START UPDATE SUPPLIER --
if(isset($_POST['update']) && !empty($_POST['update']) && $_POST['update'] == 1){
$id = $_GET['id'];
$suppName = $_POST['txtSupplierName'];
$suppAddress = $_POST['txtSupplierAddress'];
$suppEmailAddress = $_POST['txtSupplierEmailAddress'];
$suppContactNo = $_POST['txtSupplierContactNo'];
示例6:
$assigneemst->doQuery("query");
$row_assigneemst = $assigneemst->getLists();
break;
case "a":
$where = "assigneeID = '$id'";
// SET EQUIPMENT
$equipmentmst = new Table;
$equipmentmst->setSQLType($fms_db->getSQLType());
$equipmentmst->setInstance($fms_db->getInstance());
$equipmentmst->setView("v_equipmentmaster");
$equipmentmst->setParam("ORDER BY equipmentID");
$equipmentmst->doQuery("query");
$row_equipmentmst = $equipmentmst->getLists();
break;
default: break;
}
}
// SET ASSIGNEE
$assigneeequipment = new Table;
$assigneeequipment->setSQLType($fms_db->getSQLType());
$assigneeequipment->setInstance($fms_db->getInstance());
$assigneeequipment->setView("v_assigneeequipment");
$assigneeequipment->setParam("WHERE $where ORDER BY isCurrent DESC,assignedStart DESC");
$assigneeequipment->doQuery("query");
$row_assigneeequipment = $assigneeequipment->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
?>
示例7: IN
<?
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET PURCHASE ORDER
$poreceivingmst = new Table;
$poreceivingmst->setSQLType($fms_db->getSQLType());
$poreceivingmst->setInstance($fms_db->getInstance());
$poreceivingmst->setView("v_poreceiving");
$poreceivingmst->setParam("WHERE status = '0' ORDER BY status ASC, poReferenceNo DESC, poTransactionDate DESC");
$poreceivingmst->doQuery("query");
$row_poreceivingmst = $poreceivingmst->getLists();
// SET WORK ORDER
$workordermst = new Table;
$workordermst->setSQLType($fms_db->getSQLType());
$workordermst->setInstance($fms_db->getInstance());
$workordermst->setView("v_workordermaster");
$workordermst->setParam("WHERE status NOT IN('5','6','7','8') ORDER BY status ASC, woReferenceNo DESC, woTransactionDate DESC");
$workordermst->doQuery("query");
$row_workordermst = $workordermst->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
?>
示例8: generatePassword
$fms_db->setFleetDB();
// SET USER
$usermst = new Table;
$usermst->setSQLType($fms_db->getSQLType());
$usermst->setInstance($fms_db->getInstance());
$usermst->setView("v_usermaster");
$usermst->setParam("ORDER BY userID");
$usermst->doQuery("query");
$row_usermst = $usermst->getLists();
// GET USER
$getuser = new Table;
$getuser->setSQLType($fms_db->getSQLType());
$getuser->setInstance($fms_db->getInstance());
$getuser->setView("v_usermaster");
$getuser->setParam("WHERE userID = '$sys_UserID'");
$getuser->doQuery("query");
$row_getuser = $getuser->getLists();
$userPass = $row_getuser[0]['userPass'];
// CLOSING FMS DB
$fms_db->DBClose();
function generatePassword($password){
$salt = 'FleetManagementSystem';
$newpass = md5(sha1($salt.$password));
return $newpass;
}
?>
示例9:
// -- START EDIT MODEL --
if(isset($_GET['edit']) && !empty($_GET['edit']) && $_GET['edit'] == 1 && !empty($_GET['id'])){
$id = $_GET['id'];
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET MODEL
$model = new Table;
$model->setSQLType($fms_db->getSQLType());
$model->setInstance($fms_db->getInstance());
$model->setView("v_modelmaster");
$model->setParam("WHERE modelID = '$id'");
$model->doQuery("query");
$row_model = $model->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
$status = $row_model[0]['status'];
}
// -- END EDIT MODEL --
// -- START UPDATE MODEL --
if(isset($_POST['update']) && !empty($_POST['update']) && $_POST['update'] == 1){
$id = $_GET['id'];
$desc = $_POST['txtDescription'];
$variant = $_POST['txtVariant'];
$variantDesc = $_POST['txtVariantDesc'];
$status = $_POST['txtStatus'];
示例10: IN
$purchaseorder->setInstance($fms_db->getInstance());
$purchaseorder->setView("v_poreceiving");
$purchaseorder->setParam("WHERE poReferenceNo = '$id'");
$purchaseorder->doQuery("query");
$row_purchaseorder = $purchaseorder->getLists();
$wo = $row_purchaseorder[0]['woReferenceNo'];
// SET WORK ORDER
$workorder = new Table;
$workorder->setSQLType($fms_db->getSQLType());
$workorder->setInstance($fms_db->getInstance());
$workorder->setView("v_workordermaster");
$workorder->setParam("WHERE woReferenceNo = '$wo' AND status NOT IN('6','7','8')");
$workorder->doQuery("query");
$row_workorder = $workorder->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
if(count($row_purchaseorder) == 0){
$alert = new MessageAlert();
$alert->setURL(BASE_URL . V_PORECEIVING);
$alert->setMessage("Invalid URL!");
$alert->Alert();
}
$status = $row_purchaseorder[0]['status'];
if($status > 0){
$disabled = 'disabled';
示例11:
// -- START EDIT ASSIGNEE --
if(isset($_GET['edit']) && !empty($_GET['edit']) && $_GET['edit'] == 1 && !empty($_GET['id'])){
$id = $_GET['id'];
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET ASSIGNEE
$assignee = new Table;
$assignee->setSQLType($fms_db->getSQLType());
$assignee->setInstance($fms_db->getInstance());
$assignee->setView("v_assigneemaster");
$assignee->setParam("WHERE assigneeID = '$id'");
$assignee->doQuery("query");
$row_assignee = $assignee->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
$status = $row_assignee[0]['status'];
}
// -- END EDIT ASSIGNEE --
// -- START UPDATE ASSIGNEE --
if(isset($_POST['update']) && !empty($_POST['update']) && $_POST['update'] == 1){
$id = $_GET['id'];
$company = $_POST['txtCompany'];
$location = $_POST['txtLocation'];
$fName = $_POST['txtFName'];
$lName = $_POST['txtLName'];
示例12:
<?
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET MAKE
$makemst = new Table;
$makemst->setSQLType($fms_db->getSQLType());
$makemst->setInstance($fms_db->getInstance());
$makemst->setView("v_makemaster");
$makemst->setParam("ORDER BY makeID");
$makemst->doQuery("query");
$row_makemst = $makemst->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
?>
示例13:
<?
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET LOCATION
$locationmst = new Table;
$locationmst->setSQLType($fms_db->getSQLType());
$locationmst->setInstance($fms_db->getInstance());
$locationmst->setView("v_locationmaster");
$locationmst->setParam("ORDER BY locationID");
$locationmst->doQuery("query");
$row_locationmst = $locationmst->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
?>
示例14:
// -- START EDIT PARTS --
if(isset($_GET['edit']) && !empty($_GET['edit']) && $_GET['edit'] == 1 && !empty($_GET['id'])){
$id = $_GET['id'];
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET PARTS
$parts = new Table;
$parts->setSQLType($fms_db->getSQLType());
$parts->setInstance($fms_db->getInstance());
$parts->setView("v_partsmaster");
$parts->setParam("WHERE partsID = '$id'");
$parts->doQuery("query");
$row_parts = $parts->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
$status = $row_parts[0]['status'];
}
// -- END EDIT PARTS --
// -- START UPDATE PARTS --
if(isset($_POST['update']) && !empty($_POST['update']) && $_POST['update'] == 1){
$id = $_GET['id'];
$stockCode = $_POST['txtStockCode'];
$brand = $_POST['txtBrand'];
$model = $_POST['txtModel'];
$desc = $_POST['txtDescription'];
示例15: IN
<?
$id = $_GET['id'];
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET USER ACCESS
$userassignee = new Table;
$userassignee->setSQLType($fms_db->getSQLType());
$userassignee->setInstance($fms_db->getInstance());
$userassignee->setView("v_userassigneemapper");
$userassignee->setParam("WHERE userID = '$id'");
$userassignee->doQuery("query");
$row_userassignee = $userassignee->getLists();
$num_userassignee = $userassignee->getNumRows();
// SET USER ACCESS
$assigneemst = new Table;
$assigneemst->setSQLType($fms_db->getSQLType());
$assigneemst->setInstance($fms_db->getInstance());
$assigneemst->setView("v_assigneemaster");
$assigneemst->setParam("WHERE assigneeID NOT IN(SELECT assigneeID FROM v_userassigneemapper)");
$assigneemst->doQuery("query");
$row_assigneemst = $assigneemst->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
?>