public function indexAction()
{
$VTs = new clsSystem();
//先初始化
$VTs->initialization();
try {
//-----------BI開始------------
//執行查詢
$strSQL = "select * from account";
$data = $VTs->QueryData($strSQL);
//debug，印出資料用
$VTs->debug($data);
//日期轉換
$date = date("Y-m-d");
$changeDate = $VTs->DateTime("ADyyyyMMdd_RCyyyMMdd", $date);
$this->viewContnet['pageContent'] = $changeDate;
//-----------BI結束------------
} catch (Exception $error) {
//依據Controller, Action補上對應位置, $error->getMessage()為固定部份
$VTs->WriteLog("IndexController", "indexAction", $error->getMessage());
}
//關閉資料庫連線
$VTs->DBClose();
//釋放
$VTs = null;
return new ViewModel($this->viewContnet);
}
public function indexAction()
{
$VTs = new clsSystem();
//先初始化
$VTs->initialization();
//-----------BI開始------------
//執行查詢
$strSQL = "select * from account";
$data = $VTs->QueryData($strSQL);
//資料轉換
$data = $VTs->Data2Array($data);
//debug，印出資料用
$VTs->debug($data);
//日期轉換
$date = date("Y-m-d");
$changeDate = $VTs->DateTime("ADyyyyMMdd_RCyyyMMdd", $date);
$this->viewContnet['pageContent'] = $changeDate;
//-----------BI結束------------
//關閉資料庫連線
$VTs->DBClose();
//釋放
$VTs = null;
return new ViewModel($this->viewContnet);
}
public function exitotherapplyAction()
{
$VTs = new clsSystem();
//先初始化
$VTs->initialization();
//-----------BI開始------------
try {
$action = [];
$action["status"] = false;
//一定需要有type id才可以
if ($_POST["typeID"] and $_POST["uuid"] and $_POST["prj_mid"] and $_POST["quantity"]) {
$quantity = $_POST["quantity"];
$strSQL = "insert into el_exit_petition_other(prj_mid, petitionid, type, datep, date, count) ";
$strSQL .= "values('" . $_POST["prj_mid"] . "','" . $_POST["uuid"] . "','" . $_POST["typeID"] . "','" . $VTs->DateTime("CTime") . "','" . $_POST["exit_date"] . "', " . $quantity . ");";
$data = $VTs->ExecuteNonQuery($strSQL);
//$action["sql"] = $strSQL;
if ($data) {
$action["status"] = true;
} else {
$action["msg"] = "目前無資料";
}
} else {
$action["msg"] = "data is error";
}
} catch (Exception $error) {
//依據Controller, Action補上對應位置, $error->getMessage()為固定部份
$VTs->WriteLog("IndexController", "indexAction", $error->getMessage());
}
$pageContent = $VTs->Data2Json($action);
//-----------BI結束------------
//關閉資料庫連線
$VTs->DBClose();
//釋放
$VTs = null;
$this->viewContnet['pageContent'] = $pageContent;
return new ViewModel($this->viewContnet);
}
public function dbmodifyAction()
{
$VTs = new clsSystem();
//先初始化
$VTs->initialization('');
//-----------BI開始------------
$type = $_POST['type'];
switch ($type) {
case "chkorder":
$strSQL = '';
$ls_uid = $_POST['id'];
$arr_uid = explode(",", $ls_uid);
foreach ($arr_uid as $uid) {
$strSQL .= "UPDATE `el_petition` SET `check`=1,`datel`='" . $VTs->DateTime("CTime_Now") . "' WHERE uid=" . $uid . ";";
}
$VTs->ExecuteNonQuery($strSQL);
break;
case "chkin":
$uid = $_POST['id'];
$count = $_POST['count'];
$strSQL = "UPDATE `el_petition` SET `datein`='" . $VTs->DateTime("CTime_Now") . "' WHERE uid=" . $uid . ";";
$VTs->ExecuteNonQuery($strSQL);
$quid = $_POST['quid'];
$count = $_POST['count'];
$strSQL = "SELECT count_order,count_in FROM `el_quantity` WHERE uid=" . $quid . ";";
$d = $VTs->QueryData($strSQL);
$data = $d[0];
$count_order = $data['count_order'] - $count;
$count_in = $data['count_in'] + $count;
$strSQL = "UPDATE el_quantity SET count_order=" . $count_order . ", count_in =" . $count_in . " WHERE uid=" . $quid . ";";
$VTs->ExecuteNonQuery($strSQL);
break;
}
//-----------BI結束------------
//關閉資料庫連線
$VTs->DBClose();
//釋放
$VTs = null;
return new ViewModel($this->viewContnet);
}
public function modifytmpuserdataAction()
{
$VTs = new clsSystem();
$VTs->initialization("tmpCardDB");
try {
//-----BI開始-----
$action = array();
$action["status"] = false;
if ($_POST["uid"]) {
$strSQL = "update tc_user_info set user_id = '" . $_POST["user_id"] . "', name = '" . $_POST["name"] . "', company='" . $_POST["company"] . "', phone='" . $_POST["phone"] . "',admin_edit_date='" . $VTs->DateTime("CTime_Now") . "' where uid =" . $_POST["uid"];
$VTs->ExecuteNonQuery($strSQL);
$action["status"] = true;
} else {
$action["msg"] = "id or value is empty";
}
$pageContent = $VTs->Data2Json($action);
//----BI結束----
} catch (Exception $error) {
//依據Controller, Action補上對應位置, $error->getMessage()為固定部份
$VTs->WriteLog("IndexController", "indexAction", $error->getMessage());
}
$VTs = null;
$this->viewContnet['pageContent'] = $pageContent;
return new ViewModel($this->viewContnet);
}
public function reportAction()
{
$VTs = new clsSystem();
//先初始化
$VTs->initialization('');
try {
//-----------BI開始------------
$arr = array();
$arr["status"] = false;
// $nowDate = $VTs->DateTime("CTime");
$nowDate = isset($_POST["date"]) ? $_POST["date"] : $VTs->DateTime("CTime");
// $nowDate = "2015-12-02";
$strSQL = "SELECT COUNT(DISTINCT a.suworkid) w_count, b.suid, b.worksid, c.name supply_name, d.name work_type \n\t\t\t\t\t\t\tFROM su_checktime AS a \n\t\t\t\t\t\t\t\tJOIN su_worker AS b ON a.suworkid=b.uid\n\t\t\t\t\t\t\t\tJOIN su_supply AS c ON b.suid=c.uid\n\t\t\t\t\t\t\t\tJOIN su_type_works AS d ON b.worksid=d.uid\n\t\t\t\t\t\t\tWHERE iotime LIKE '" . $nowDate . "%' \n\t\t\t\t\t\t\tGROUP BY b.suid, b.worksid\n\t\t\t\t\t\t\tORDER BY b.worksid";
// echo $strSQL;
// exit;
$data = $VTs->QueryData($strSQL);
if (!empty($data)) {
$arr["status"] = true;
$arr["data"] = $data;
}
$pageContent = $VTs->Data2Json($arr);
// $pageContent = '[{"w_count":"10","suid":"1","worksid":"2","supply_name":"\u4e1e\u90b5\u71df\u5efa\u5de5\u7a0b\u516c\u53f8","work_type":"\u92fc\u7b4b"},
// {"w_count":"8","suid":"2","worksid":"2","supply_name":"\u6b63\u4e2d\u71df\u5efa\u5de5\u7a0b\u516c\u53f8","work_type":"\u92fc\u7b4b"},
// {"w_count":"5","suid":"2","worksid":"3","supply_name":"\u6b63\u4e2d\u71df\u5efa\u5de5\u7a0b\u516c\u53f8","work_type":"\u6df7\u6ce5\u571f"},
// {"w_count":"20","suid":"1","worksid":"3","supply_name":"\u4e1e\u90b5\u71df\u5efa\u5de5\u7a0b\u516c\u53f8","work_type":"\u6df7\u6ce5\u571f"}]';
//-----------BI結束------------
} catch (Exception $error) {
//依據Controller, Action補上對應位置, $error->getMessage()為固定部份
$VTs->WriteLog("SARController", "reportAction", $error->getMessage());
}
//關閉資料庫連線
$VTs->DBClose();
//釋放
$VTs = null;
$this->viewContnet['pageContent'] = $pageContent;
return new ViewModel($this->viewContnet);
}
public function getdailycontentAction()
{
$VTs = new clsSystem();
$VTs->initialization();
//-----BI開始-----
$action = array();
$action["status"] = false;
$type = $_POST["type"];
if ($type) {
switch ($type) {
case "floor":
$strSQL = "select t1.uid,concat(t1.name,'(',t1.code,')') Name ";
$strSQL .= "from eng_str_b t1 ";
$strSQL .= "left join eng_set_floor t2 on t2.strid_b=t1.uid ";
$strSQL .= "where t2.prjid=" . $_POST["puid"];
break;
case "workitem":
$strSQL = "select t2.uid,concat(t2.name,'(',t2.code,')') Name ";
$strSQL .= "from eng_worklist_workitem t1 ";
$strSQL .= "left join eng_type_c t2 on t2.uid=t1.typeid_c ";
$strSQL .= "where t1.strid_b=" . $_POST["floorid"] . " group by t2.code";
break;
case "pacemodel":
$strSQL = "select uid,concat(NAME,'(',CODE,')') Name ";
$strSQL .= "from eng_pace_model ";
$strSQL .= "where typeid_c=" . $_POST["workitemid"];
break;
case "area":
$strSQL = "select t2.uid,CONCAT(t2.name,'(',t2.code,')') Name ";
$strSQL .= "from eng_worklist_areaitem t1 ";
$strSQL .= "left join eng_set_area t2 on t2.uid=t1.areaid ";
$strSQL .= "left join eng_worklist_workitem t3 on t3.uid=t1.wl_wiid ";
$strSQL .= "where t3.strid_b=" . $_POST["floorid"] . " and t3.p_modelid=" . $_POST["pacemodelid"] . " and t1.datee IS NULL group by t1.areaid";
break;
case "alllist":
$strSQL = "select t1.uid,concat(t3.name,' ',t4.name) Name ";
$strSQL .= "from eng_worklist_areaitem t1 ";
$strSQL .= "left join eng_worklist_workitem t2 ON t2.uid=t1.wl_wiid ";
$strSQL .= "left join eng_str_e t3 ON t3.uid=t1.strid_e ";
$strSQL .= "left join eng_pace_model t5 ON t5.uid=t2.p_modelid ";
$strSQL .= "left join eng_pace_modelitems t6 on t6.uid=t1.p_miid ";
$strSQL .= "left join eng_type_d t4 on t4.uid=t6.type_d ";
$strSQL .= "where t2.strid_b=" . $_POST["floorid"] . " and t2.typeid_c=" . $_POST["workitemid"] . " and t1.areaid=" . $_POST["areaid"] . " and t6.typeid=0 and t1.datee IS NULL";
break;
case "checkData":
if (!empty($_POST["alllistid"])) {
$uidStr = "";
$strSQL = "";
foreach ($_POST["alllistid"] as $content) {
$uidStr .= $content . ",";
$strSQL .= "insert into qc_checklist (typeid, dataid)VALUES(2, " . $content . ");";
}
$uidStr = substr($uidStr, 0, strlen($uidStr) - 1);
$strSQL .= "update eng_worklist_areaitem SET datee='" . $VTs->DateTime("CTime_Now") . "' WHERE uid in (" . $uidStr . ")";
$VTs->ExecuteNonQuery($strSQL);
$action["status"] = true;
} else {
$action["msg"] = 'checkData is Empty';
$action["status"] = false;
}
break;
case "checkAllListData":
if (!empty($_POST["alllistid"])) {
$uidStr = "";
$strSQL = "";
$tmpAllListIDArr = explode(",", $_POST["alllistid"]);
foreach ($tmpAllListIDArr as $content) {
$strSQL .= "insert into qc_checklist (typeid, dataid)VALUES(2, " . $content . ");";
}
$uidStr = $_POST["alllistid"];
$strSQL .= "update eng_worklist_areaitem SET datee='" . $VTs->DateTime("CTime_Now") . "' WHERE uid in (" . $uidStr . ")";
$VTs->ExecuteNonQuery($strSQL);
$action["status"] = true;
} else {
$action["msg"] = 'checkData is Empty';
$action["status"] = false;
}
break;
}
if ($type != "checkData") {
$data = $VTs->QueryData($strSQL);
$action["daily"] = $data;
$action["status"] = true;
}
} else {
$action["msg"] = 'type is Empty';
}
$pageContent = $VTs->Data2Json($action);
//-----BI結束-----
$VTs = null;
$this->viewContnet['pageContent'] = $pageContent;
return new ViewModel($this->viewContnet);
}
public function dbmodifyAction()
{
$VTs = new clsSystem();
//先初始化
$VTs->initialization('');
//-----------BI開始------------
$strSQL = '';
$data = $_POST;
$type = $data['type'];
switch ($type) {
case 'laborsafety':
$strSQL = "UPDATE `eng_diary_contents` SET `contents` = '" . $data["fifth"] . "' WHERE type=2 AND date = '" . date('Y-m-d') . "';";
$VTs->ExecuteNonQuery($strSQL);
$strSQL = "UPDATE `eng_diary_contents` SET `contents` = '" . $data["seventh"] . "' WHERE type=4 AND date = '" . date('Y-m-d') . "';";
$VTs->ExecuteNonQuery($strSQL);
break;
case 'diary_info':
$strSQL = "UPDATE `eng_diary_info` SET `am_wthid` = '" . $data["amwather"] . "', `pm_wthid` = '" . $data["pmwather"] . " WHERE `date` = '" . date('Y-m-d') . ";";
$VTs->ExecuteNonQuery($strSQL);
break;
case 'infocheck':
$strSQL = "UPDATE `eng_diary_info` SET `dates` = '" . $VTs->DateTime("CTime_Now") . "' WHERE `date` = '" . date('Y/m/d') . "';";
$VTs->ExecuteNonQuery($strSQL);
break;
}
// $data=$_POST;
// $strSQL="UPDATE `eng_diary_info` SET `am_wthid` = '".$data["amwather"]."', `pm_wthid` = '".$data["pmwather"]." WHERE `date` = '".date('Y-m-d').";";
// $VTs->ExecuteNonQuery($strSQL);
// $strSQL="SELECT uid FROM eng_diary_info WHERE date='".date("Y")."-".date("m")."-".date("d")."';";
// $d = $VTs->QueryData($strSQL);
// $iuid=$d[0]['uid'];
// $strSQL="UPDATE `eng_diary_contents` SET `fourth` = '".$data["fourth"]."', `fifth` = '".$data["fifth"]."', `sixth` = '".$data["sixth"]."', `seventh` = '".$data["seventh"]."', `eighth` = '".$data["eighth"]."' WHERE iuid = ".$iuid.";";
// $VTs->ExecuteNonQuery($strSQL);
//-----------BI結束------------
//關閉資料庫連線
$VTs->DBClose();
//釋放
$VTs = null;
return new ViewModel($this->viewContnet);
}
