当前位置: 首页>>代码示例>>PHP>>正文


PHP Table::setView方法代码示例

本文整理汇总了PHP中Table::setView方法的典型用法代码示例。如果您正苦于以下问题:PHP Table::setView方法的具体用法?PHP Table::setView怎么用?PHP Table::setView使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在Table的用法示例。


在下文中一共展示了Table::setView方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: MessageAlert

		$chkwourl = new Table;
		$chkwourl->setSQLType($fms_db->getSQLType());
		$chkwourl->setInstance($fms_db->getInstance());
		$chkwourl->setView("v_workordermaster");
		$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);
开发者ID:rogerapras,项目名称:fms,代码行数:31,代码来源:workorderController.php

示例2:

	}
	// -- END SAVE NEW EQUIPMENT --

	// -- START DELETE EQUIPMENT --
	if(isset($_GET['delete']) && !empty($_GET['delete']) && $_GET['delete'] == 1 && !empty($_GET['id'])){
		$id = $_GET['id'];

		// SET FMS DB
		$fms_db = new DBConfig;
		$fms_db->setFleetDB();

		// SET EQUIPMENT
		$equipmentmst = new Table;
		$equipmentmst->setSQLType($fms_db->getSQLType());
		$equipmentmst->setInstance($fms_db->getInstance());
		$equipmentmst->setView("v_equipmentmaster");
		$equipmentmst->setParam("WHERE equipmentID = '$id'");
		$equipmentmst->doQuery("query");
		$row_equipmentmst = $equipmentmst->getLists();

		// DELETE EQUIPMENT
		$del_equipment = new Table;
		$del_equipment->setSQLType($fms_db->getSQLType());
		$del_equipment->setInstance($fms_db->getInstance());
		$del_equipment->setTable("equipmentmaster");
		$del_equipment->setParam("WHERE equipmentID = '$id'");
		$del_equipment->doQuery("delete");
		$res_equipment = $del_equipment->getError();

		// CLOSING FMS DB
		$fms_db->DBClose();
开发者ID:rogerapras,项目名称:fms,代码行数:31,代码来源:equipmentController.php

示例3: 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();
?>
开发者ID:rogerapras,项目名称:fms,代码行数:26,代码来源:poreceivingModel.php

示例4:

	}
	// -- END DELETE REMINDER --

	// -- START EDIT REMINDER --
	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 REMINDER
		$reminders = new Table;
		$reminders->setSQLType($fms_db->getSQLType());
		$reminders->setInstance($fms_db->getInstance());
		$reminders->setView("v_remindermaster");
		$reminders->setParam("WHERE reminderID = '$id'");
		$reminders->doQuery("query");
		$row_reminders = $reminders->getLists();

		// CLOSING FMS DB
		$fms_db->DBClose();

		$status = $row_reminders[0]['status'];
	}
	// -- END EDIT REMINDER --

	// -- START UPDATE REMINDER --
	if(isset($_POST['update']) && !empty($_POST['update']) && $_POST['update'] == 1){
		$id = $_GET['id'];
		$title = $_POST['txtTitle'];
开发者ID:rogerapras,项目名称:fms,代码行数:31,代码来源:remindersController.php

示例5:

	}
	// -- END DELETE CONTROL NO --

	// -- START EDIT CONTROL NO --
	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 CONTROL NO
		$ctrlno = new Table;
		$ctrlno->setSQLType($fms_db->getSQLType());
		$ctrlno->setInstance($fms_db->getInstance());
		$ctrlno->setView("controlnomaster");
		$ctrlno->setParam("WHERE id = '$id'");
		$ctrlno->doQuery("query");
		$row_ctrlno = $ctrlno->getLists();

		// CLOSING FMS DB
		$fms_db->DBClose();

		$status = $row_ctrlno[0]['status'];
	}
	// -- END EDIT CONTROL NO --

	// -- START UPDATE CONTROL NO --
	if(isset($_POST['update']) && !empty($_POST['update']) && $_POST['update'] == 1){
		$id = $_GET['id'];
		$desc = $_POST['txtDescription'];
开发者ID:rogerapras,项目名称:fms,代码行数:31,代码来源:controlNoController.php

示例6: 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;
	}
?>
开发者ID:rogerapras,项目名称:fms,代码行数:31,代码来源:userModel.php

示例7:

	}
	// -- END DELETE SERVICE TYPE --

	// -- START EDIT SERVICE TYPE --
	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 SERVICE TYPE
		$servicetype = new Table;
		$servicetype->setSQLType($fms_db->getSQLType());
		$servicetype->setInstance($fms_db->getInstance());
		$servicetype->setView("v_servicetypemaster");
		$servicetype->setParam("WHERE serviceTypeID = '$id'");
		$servicetype->doQuery("query");
		$row_servicetype = $servicetype->getLists();

		// CLOSING FMS DB
		$fms_db->DBClose();

		$status = $row_servicetype[0]['status'];
	}
	// -- END EDIT SERVICE TYPE --

	// -- START UPDATE SERVICE TYPE --
	if(isset($_POST['update']) && !empty($_POST['update']) && $_POST['update'] == 1){
		$id = $_GET['id'];
		$desc = $_POST['txtDescription'];
开发者ID:rogerapras,项目名称:fms,代码行数:31,代码来源:servicetypeController.php

示例8:

	}
	// -- END DELETE MAKE --

	// -- 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'];
开发者ID:rogerapras,项目名称:fms,代码行数:31,代码来源:makeController.php

示例9:

<?
	// SET FMS DB
	$fms_db = new DBConfig;
	$fms_db->setFleetDB();

	// SET MAKE
	$invoicing = new Table;
	$invoicing->setSQLType($fms_db->getSQLType());
	$invoicing->setInstance($fms_db->getInstance());
	$invoicing->setView("v_equipmentrepairedmaster");
	$invoicing->setParam("WHERE noOfTransactions > 0 ORDER BY companyName ");
	$invoicing->doQuery("query");
	$row_invoicing = $invoicing->getLists();

	// CLOSING FMS DB 
	$fms_db->DBClose();
?>
开发者ID:rogerapras,项目名称:fms,代码行数:17,代码来源:invoicingModel.php

示例10:

<?
	// SET FMS DB
	$fms_db = new DBConfig;
	$fms_db->setFleetDB();

	// SET PARTS
	$partsmst = new Table;
	$partsmst->setSQLType($fms_db->getSQLType());
	$partsmst->setInstance($fms_db->getInstance());
	$partsmst->setView("v_partsmaster");
	$partsmst->setParam("ORDER BY partsID");
	$partsmst->doQuery("query");
	$row_partsmst = $partsmst->getLists();

	// CLOSING FMS DB 
	$fms_db->DBClose();
?>
开发者ID:rogerapras,项目名称:fms,代码行数:17,代码来源:partsModel.php

示例11:

	}
	// -- END DELETE LOCATION --

	// -- START EDIT LOCATION --
	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 LOCATION
		$location = new Table;
		$location->setSQLType($fms_db->getSQLType());
		$location->setInstance($fms_db->getInstance());
		$location->setView("v_locationmaster");
		$location->setParam("WHERE locationID = '$id'");
		$location->doQuery("query");
		$row_location = $location->getLists();

		// CLOSING FMS DB
		$fms_db->DBClose();

		$status = $row_location[0]['status'];
	}
	// -- END EDIT LOCATION --

	// -- START UPDATE LOCATION --
	if(isset($_POST['update']) && !empty($_POST['update']) && $_POST['update'] == 1){
		$id = $_GET['id'];
		$locName = $_POST['txtLocationName'];
开发者ID:rogerapras,项目名称:fms,代码行数:31,代码来源:locationController.php

示例12:

<?
	// SET FMS DB
	$fms_db = new DBConfig;
	$fms_db->setFleetDB();

	// SET COMPANY
	$companymst = new Table;
	$companymst->setSQLType($fms_db->getSQLType());
	$companymst->setInstance($fms_db->getInstance());
	$companymst->setView("v_companymaster");
	$companymst->setParam("ORDER BY companyID");
	$companymst->doQuery("query");
	$row_companymst = $companymst->getLists();

	// CLOSING FMS DB
	$fms_db->DBClose();
?>
开发者ID:rogerapras,项目名称:fms,代码行数:17,代码来源:companyModel.php

示例13:

<?
	// SET FMS DB
	$fms_db = new DBConfig;
	$fms_db->setFleetDB();

	// SET MODEL
	$modelmst = new Table;
	$modelmst->setSQLType($fms_db->getSQLType());
	$modelmst->setInstance($fms_db->getInstance());
	$modelmst->setView("v_modelmaster");
	$modelmst->setParam("ORDER BY modelID");
	$modelmst->doQuery("query");
	$row_modelmst = $modelmst->getLists();

	// CLOSING FMS DB 
	$fms_db->DBClose();
?>
开发者ID:rogerapras,项目名称:fms,代码行数:17,代码来源:modelModel.php

示例14:

	}
	// -- END DELETE SUPPLIER --

	// -- 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'];
开发者ID:rogerapras,项目名称:fms,代码行数:31,代码来源:supplierController.php

示例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();
?>
开发者ID:rogerapras,项目名称:fms,代码行数:29,代码来源:userassigneeModel.php


注:本文中的Table::setView方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。