public function getDBdataAction()
{
$VTs = new clsSystem();
//先初始化
$VTs->initialization('');
//-----------BI開始------------
$type = $_GET['type'];
$action = [];
$action["status"] = false;
switch ($type) {
case 'getDateList':
$pageType = $_GET['ptype'];
$strSQL = "SELECT DISTINCT date(datec) as datef FROM `qc_checklist` WHERE typeid=" . $pageType . " AND imgid is not null order by datec desc";
$data = $VTs->QueryData($strSQL);
if (!empty($data)) {
$action["status"] = true;
}
break;
case 'qc_checklist':
// $strSQL="SELECT * FROM `qc_checklist` where imgid is not null AND typeid=1 order by uid desc";
$datel = $_GET['datel'];
$sLimit = @$_GET["sLimit"];
$eLimit = @$_GET["eLimit"];
if ($datel == 0) {
$datel = date("Y-m-d");
}
$data['date'] = $datel;
$limit = "";
if (isset($_GET["sLimit"]) and isset($_GET["eLimit"])) {
if ($sLimit >= 0 and $eLimit >= 1) {
$limit = " limit " . $sLimit . "," . $eLimit;
}
}
$strSQL = "SELECT t1.uid AS uid, t1.datec AS datec ,t1.remark AS remark,t5.name AS ma_name ,t2.count AS count,t2.place AS place,t6.imgfile AS imgfile\n\t\t\t\t\t\tFROM qc_checklist AS t1\n\t\t\t\t\t\tLEFT JOIN el_petition AS t2 ON t2.uid=t1.dataid\n\t\t\t\t\t\tLEFT JOIN prj_materiel AS t3 ON t2.prj_mid=t3.uid \n\t\t\t\t\t\tLEFT JOIN prj_materiel_items AS t4 ON t3.uid=t4.prj_mid\n\t\t\t\t\t\tLEFT JOIN el_materiel AS t5 ON t4.materielid=t5.uid\n\t\t\t\t\t\tLEFT JOIN img_picture AS t6 ON t1.imgid = t6.uid\n\t\t\t\t\t\twhere t1.imgid is not null AND t1.typeid=1\n\t\t\t\t\t\tAND to_days(t1.datec)=to_days('" . $datel . "')\n\t\t\t\t\t\torder by t1.uid desc " . $limit . ";";
$arr_d = $VTs->QueryData($strSQL);
$filePath = dirname(__DIR__) . "\\..\\..\\..\\..\\public\\qc_img\\";
if (!file_exists($filePath)) {
$tmpFilePath = str_replace("\\", "/", $filePath);
if (!file_exists($tmpFilePath)) {
$VTs->CreateDirectory($tmpFilePath);
}
}
if (!empty($arr_d)) {
//CreateDirectory
foreach ($arr_d as $i => $d) {
$filePath = dirname(__DIR__) . "\\..\\..\\..\\..\\public\\qc_img\\";
$filePath .= $d["imgfile"];
if (file_exists($filePath)) {
$imgArr = $VTs->GetINIInfo($filePath, "", "", "", true);
$arr_d[$i]["imgs"] = $imgArr;
} else {
$filePath = str_replace("\\", "/", $filePath);
if (file_exists($filePath)) {
$imgArr = $VTs->GetINIInfo($filePath, "", "", "", true);
$arr_d[$i]["imgs"] = $imgArr;
} else {
$arr_d[$i]["imgs"] = null;
}
}
}
$data["checklist"] = $arr_d;
$action["status"] = true;
}
break;
case 'qc_checklist_c':
// $strSQL="SELECT * FROM `qc_checklist` where imgid is not null AND typeid=2 order by uid desc";
$datel = $_GET['datel'];
if ($datel == 0) {
$datel = date("Y-m-d");
}
$data['date'] = $datel;
$strSQL = "SELECT t1.datec AS datec ,t1.remark AS remark,t1.uid,t7.name as fl,t8.name as typec,t9.name as model,t4.name as area,t6.name as typed,t10.imgfile as imgfile\n\t\t\t\t\t\tFROM qc_checklist t1\n\t\t\t\t\t\tLEFT JOIN eng_worklist_areaitem t2 ON t2.uid = t1.dataid\n\t\t\t\t\t\tLEFT JOIN eng_worklist_workitem t3 ON t3.uid = t2.wl_wiid\n\t\t\t\t\t\tLEFT JOIN eng_set_area t4 ON t4.uid = t2.areaid\n\t\t\t\t\t\tLEFT JOIN eng_pace_modelitems t5 ON t5.uid = t2.p_miid\n\t\t\t\t\t\tLEFT JOIN eng_type_d t6 ON t6.uid = t5.type_d\n\t\t\t\t\t\tLEFT JOIN eng_str_b t7 ON t7.uid = t3.strid_b\n\t\t\t\t\t\tLEFT JOIN eng_type_c t8 ON t8.uid = t3.typeid_c\n\t\t\t\t\t\tLEFT JOIN eng_pace_model t9 ON t9.uid = t3.p_modelid\n\t\t\t\t\t\tLEFT JOIN img_picture t10 ON t1.imgid = t10.uid\n\t\t\t\t\t\twhere t1.imgid is not null AND t1.typeid=2 \n\t\t\t\t\t\tAND to_days(t1.datec)=to_days('" . $datel . "')\n\t\t\t\t\t\torder by uid desc;";
$arr_d = $VTs->QueryData($strSQL);
$filePath = dirname(__DIR__) . "\\..\\..\\..\\..\\public\\qc_img\\";
if (!file_exists($filePath)) {
$VTs->CreateDirectory($filePath);
}
if (!empty($arr_d)) {
//CreateDirectory
foreach ($arr_d as $i => $d) {
$filePath = dirname(__DIR__) . "\\..\\..\\..\\..\\public\\qc_img\\";
$filePath .= $d["imgfile"];
if (file_exists($filePath)) {
$imgArr = $VTs->GetINIInfo($filePath, "", "", "", true);
$arr_d[$i]["imgs"] = $imgArr;
} else {
$arr_d[$i]["imgs"] = null;
}
}
$data["checklist"] = $arr_d;
$action["status"] = true;
}
break;
case 'title':
$strSQL = "SELECT name FROM `prj_project` WHERE uid=1";
$d = $VTs->QueryData($strSQL);
$data = $d[0];
break;
}
// $data = $VTs->QueryData($strSQL);
$data["status"] = $action["status"];
$pageContent = $VTs->Data2Json($data);
//-----------BI結束------------
//關閉資料庫連線
$VTs->DBClose();
//釋放
$VTs = null;
$this->viewContnet['pageContent'] = $pageContent;
return new ViewModel($this->viewContnet);
}
public function getpurchaseimgAction()
{
$VTs = new clsSystem();
$VTs->initialization();
try {
//-----BI開始-----
$action = [];
$action["status"] = false;
if ($_GET["uid"]) {
//先取出照片檔名
$strSQL = "select b.imgfile from el_petition as a ";
$strSQL .= "left join el_purchase_img as b on a.purchase = b.uid ";
$strSQL .= "where a.uid = '" . $_GET["uid"] . "'";
$imgFileData = $VTs->QueryData($strSQL);
$imgFileData = $imgFileData[0]["imgfile"];
//CreateDirectory
$filePath = dirname(__DIR__) . "\\..\\..\\..\\..\\public\\purchase_img\\";
if (file_exists($filePath)) {
$filePath .= $imgFileData;
$imgArr = $VTs->GetINIInfo($filePath, "", "", "", true);
$action["imgs"] = $imgArr;
} else {
$filePath = str_replace("\\", "/", $filePath);
if (file_exists($filePath)) {
$filePath .= $imgFileData;
$imgArr = $VTs->GetINIInfo($filePath, "", "", "", true);
$action["imgs"] = $imgArr;
} else {
$action["msg"] = 'Can not find img files';
//$action["test"] = $filePath;
}
}
//再取出對應說明
$strSQL = "select uid,img_number,purchase_number,purchase_count from el_purchase where petition_id = '" . $_GET["uid"] . "'";
$imgMemo = $VTs->QueryData($strSQL);
$tmpImgMemo = [];
foreach ($imgMemo as $content) {
$tmpImgMemo[$content["img_number"]] = ["uid" => $content["uid"], "purchase_number" => $content["purchase_number"], "purchase_count" => $content["purchase_count"]];
}
$action["imgMemo"] = (object) $tmpImgMemo;
//$action["test"] = $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 usercarddetailAction()
{
$VTs = new clsSystem();
$VTs->initialization("tmpCardDB");
try {
//-----BI開始-----
$action = array();
$action["status"] = false;
if ($_POST["uid"]) {
//先尋找已新增卡片資料
$strSQL = "select ui.uid, ci.number, ui.user_id, ui.name, ui.purpose, ui.use_date, ui.company, ui.phone, img.imgfile from tc_user_info as ui ";
$strSQL .= "left join tc_card_info as ci on ui.card_id = ci.uid ";
$strSQL .= "left join tc_img as img on ui.img_id = img.uid ";
$strSQL .= "where ui.uid = " . $_POST["uid"];
$data = $VTs->QueryData($strSQL);
if (!empty($data)) {
$filePath = dirname(__DIR__) . "\\..\\..\\..\\..\\public\\tmpcard_img\\";
if (file_exists($filePath)) {
$filePath .= $data[0]["imgfile"];
$imgArr = $VTs->GetINIInfo($filePath, "", "", "", true);
} else {
$imgArr = 'Can not find img files';
}
$data[0]["imgfile"] = $imgArr;
$action["ui_data"] = $data;
$action["status"] = true;
} else {
$action["msg"] = "暫無資料";
}
} else {
$action["msg"] = "id 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()
{
//echo "targetid:".$_GET["targetid"];
$VTs = new clsSystem();
$VTs->initialization('oldhouseDB');
//-----BI開始-----
try {
$page = $_GET["page"];
#序號
$no = 1;
switch ($page) {
case "main_page":
$html_path = dirname(__DIR__) . "\\..\\..\\..\\..\\public\\include\\pageSetting\\oldhouse\\table-2.html";
#主頁面
$html = $VTs->GetHtmlContent($html_path);
#檢驗基本資料
$strSQL = "select t2.`hname`, t2.`htel`, t2.`hmobil`,\n t2.`ZipCode`, t2.`City`, t2.`Area`, t2.`Vil`, t2.`Verge`, t2.`Road`, t2.`addr`,\n t3.desc 'strType', t1.`htmid1`, t1.`htmid2`, t5.desc 'type', t1.date, t8.name 'ename', t7.`licenseid` 'license'\n from qc_info as t1\n left join qc_house as t2 on t2.uid = t1.`huid`\n left join house_type as t3 on t3.`uid` = t1.htid\n left join house_type_structure as t5 on t5.uid = t1.htsid\n left join `eng_engineer_city` as t6 on t6.uid = t2.`ecid`\n left join `eng_engineer` as t7 on t7.uid = t6.`eid`\n left join `ass_common` as t8 on t8.uid = t7.`cmid`\n where huid = " . $_GET["targetid"] . "\n limit 1";
$data = $VTs->QueryData($strSQL);
//$VTs->Debug($data);
$scale1 = !empty($data[0]["htmid1"]) ? " " . $data[0]["htmid1"] . " " : " _ ";
$scale2 = !empty($data[0]["htmid2"]) ? " " . $data[0]["htmid2"] . " " : " _ ";
#主頁面基本資料置換
$dataArr = ["owner" => $data[0]["hname"], "tel" => $data[0]["htel"], "mobile" => $data[0]["hmobil"], "addr" => $data[0]["ZipCode"] . " " . $data[0]["City"] . " " . $data[0]["Area"] . " " . $data[0]["Vil"] . " " . $data[0]["Verge"] . " " . $data[0]["Road"] . " " . $data[0]["addr"], "strType" => $data[0]["strType"], "scale" => "地上" . $scale1 . "層 地下" . $scale2 . "層", "type" => $data[0]["type"], "date" => $data[0]["date"], "ename" => $data[0]["ename"], "license" => $data[0]["license"]];
$html = $VTs->ContentReplace($dataArr, $html);
//print_r($html);
#主頁面量化資料欄位
$quantity_tr_path = dirname(__DIR__) . "\\..\\..\\..\\..\\public\\include\\pageSetting\\oldhouse\\tr1.html";
$quantity_tr = $VTs->GetHtmlContent($quantity_tr_path);
$strSQL = "SELECT t1.uid,\n t10.`desc` as eng_str, t11.`desc` as problem, t1.`length`, t1.`width`, t1.`depth`, t1.`area`,\n t1.`remark`, t13.`imgfile`, t12.unit1 level\n FROM qc_item AS t1\n LEFT JOIN qc_info AS t2 ON t2.uid = t1.ifid\n LEFT JOIN qc_house AS t3 ON t3.uid = t2.huid\n LEFT JOIN house_type AS t4 ON t4.uid = t2.htid\n LEFT JOIN house_type_model AS t5 ON t5.uid = t2.htmid1 OR t5.uid = t2.htmid2\n LEFT JOIN house_type_structure AS t6 ON t6.uid = t2.htsid\n LEFT JOIN eng_engineer_city AS t7 ON t7.uid = t3.ecid\n LEFT JOIN eng_engineer AS t8 ON t8.uid = t7.eid\n LEFT JOIN ass_common AS t9 ON t9.uid = t8.cmid\n LEFT JOIN eng_str AS t10 ON t10.`uid` = t1.`strid`\n LEFT JOIN qc_checkitem AS t11 ON t11.uid = t1.ciid\n LEFT JOIN eng_unit AS t12 ON t12.uid = t1.val\n LEFT JOIN img_picture AS t13 ON t13.`uid` = t1.`imgids`\n WHERE t2.huid = " . $_GET["targetid"] . " AND (t1.`length` > 0 OR t1.width > 0 OR t1.depth > 0 OR t1.`area` > 0)\n ORDER BY t1.val DESC, t1.uid ASC";
$data = $VTs->QueryData($strSQL);
//$VTs->Debug($data[0]);
//print_r(count($data));
$quantity_html = "";
for ($i = 0; $i < count($data); $i++) {
//$VTs->Debug($data[$i]);
$tr = $quantity_tr;
if ($data[$i]["area"] != 0) {
$value = "面積：" . $data[$i]["area"];
} else {
$value = "長：" . $data[$i]["length"] . " 寬：" . $data[$i]["width"] . " 高：" . $data[$i]["depth"];
}
#讀圖檔
$filePath = "C:\\xampp\\htdocs\\AP-Service\\public\\old_house_img\\";
//$filePath = "D:\\php_dev\\AP-Service\\public\\old_house_img\\";
$filePath .= $data[$i]["imgfile"];
//print_r($filePath);
if (file_exists($filePath)) {
$imgArr = $VTs->GetINIInfo($filePath, "", "", "", true);
//$VTs->debug($imgArr["img0"]);
// $img = "<img src='".$imgArr["img0"]."' width='60%' />
// <img src='".$imgArr["img1"]."' width='60%' />
// <img src='".$imgArr["img2"]."' width='60%' />";
$img = count($imgArr) . "張";
} else {
$img = "0張";
}
#替換@@
$dataArr = ["no" => $no++, "eng_str" => $data[$i]["eng_str"], "problem" => $data[$i]["problem"], "value" => $value, "remark" => $data[$i]["remark"], "photo" => $img, "level" => $data[$i]["level"]];
$tr = $VTs->ContentReplace($dataArr, $tr);
$quantity_html .= $tr;
}
#量化資料End
#質化資料
$quality_tr_path = dirname(__DIR__) . "\\..\\..\\..\\..\\public\\include\\pageSetting\\oldhouse\\tr2.html";
$quality_tr = $VTs->GetHtmlContent($quality_tr_path);
$strSQL = "SELECT t1.uid,\n t10.`desc` as eng_str, t11.`desc` as problem, t1.`length`, t1.`width`, t1.`depth`, t1.`area`,\n t1.`remark`, t13.`imgfile`, t12.unit1 level\n FROM qc_item AS t1\n LEFT JOIN qc_info AS t2 ON t2.uid = t1.ifid\n LEFT JOIN qc_house AS t3 ON t3.uid = t2.huid\n LEFT JOIN house_type AS t4 ON t4.uid = t2.htid\n LEFT JOIN house_type_model AS t5 ON t5.uid = t2.htmid1 OR t5.uid = t2.htmid2\n LEFT JOIN house_type_structure AS t6 ON t6.uid = t2.htsid\n LEFT JOIN eng_engineer_city AS t7 ON t7.uid = t3.ecid\n LEFT JOIN eng_engineer AS t8 ON t8.uid = t7.eid\n LEFT JOIN ass_common AS t9 ON t9.uid = t8.cmid\n LEFT JOIN eng_str AS t10 ON t10.`uid` = t1.`strid`\n LEFT JOIN qc_checkitem AS t11 ON t11.uid = t1.ciid\n LEFT JOIN eng_unit AS t12 ON t12.uid = t1.val\n LEFT JOIN img_picture AS t13 ON t13.`uid` = t1.`imgids`\n WHERE t2.huid = " . $_GET["targetid"] . " AND (t1.`length` = 0 and t1.width = 0 and t1.depth = 0 and t1.`area` = 0)\n ORDER BY t1.val DESC, t1.uid ASC";
$data = $VTs->QueryData($strSQL);
//$VTs->Debug($data);
$quality_html = "";
for ($i = 0; $i < count($data); $i++) {
//$VTs->Debug($data[$i]);
$tr = $quality_tr;
#讀圖檔
$filePath = "C:\\xampp\\htdocs\\AP-Service\\public\\old_house_img\\";
//$filePath = "D:\\php_dev\\AP-Service\\public\\old_house_img\\";
$filePath .= $data[$i]["imgfile"];
//print_r($filePath);
if (file_exists($filePath)) {
$imgArr = $VTs->GetINIInfo($filePath, "", "", "", true);
//$VTs->debug($imgArr["img0"]);
// $img = "<img src='".$imgArr["img0"]."' width='60%' />
// <img src='".$imgArr["img1"]."' width='60%' />
// <img src='".$imgArr["img2"]."' width='60%' />";
$img = count($imgArr) . "張";
} else {
$img = "0張";
}
$dataArr = ["no" => $no++, "eng_str" => $data[$i]["eng_str"], "problem" => $data[$i]["problem"], "value" => $value, "remark" => $data[$i]["remark"], "photo" => $img, "level" => $data[$i]["level"]];
$tr = $VTs->ContentReplace($dataArr, $tr);
$quality_html .= $tr;
}
#值化資料End
$dataArr = ["quantity" => $quantity_html, "quality" => $quality_html];
$html = $VTs->ContentReplace($dataArr, $html);
//print_r($html);
//$pageContent=$VTs->Data2Json($d);
$pageContent = $html;
break;
case "img_page":
#圖片頁面
$img_html_path = dirname(__DIR__) . "\\..\\..\\..\\..\\public\\include\\pageSetting\\oldhouse\\table-3.html";
$img_html = $VTs->GetHtmlContent($img_html_path);
$img_page_path = dirname(__DIR__) . "\\..\\..\\..\\..\\public\\include\\pageSetting\\oldhouse\\img_page.html";
$img_page = $VTs->GetHtmlContent($img_page_path);
#表頭資料
$strSQL = "select t2.`hname`, t2.`htel`, t2.`hmobil`,\n t2.`ZipCode`, t2.`City`, t2.`Area`, t2.`Vil`, t2.`Verge`, t2.`Road`, t2.`addr`,\n t3.desc 'strType', t1.`htmid1`, t1.`htmid2`, t5.desc 'type', t1.date, t8.name 'ename', t7.`licenseid` 'license'\n from qc_info as t1\n left join qc_house as t2 on t2.uid = t1.`huid`\n left join house_type as t3 on t3.`uid` = t1.htid\n left join house_type_structure as t5 on t5.uid = t1.htsid\n left join `eng_engineer_city` as t6 on t6.uid = t2.`ecid`\n left join `eng_engineer` as t7 on t7.uid = t6.`eid`\n left join `ass_common` as t8 on t8.uid = t7.`cmid`\n where huid = " . $_GET["targetid"] . "\n limit 1";
$data = $VTs->QueryData($strSQL);
#圖片頁面header置換
$img_header_path = dirname(__DIR__) . "\\..\\..\\..\\..\\public\\include\\pageSetting\\oldhouse\\img_header.html";
$img_header = $VTs->GetHtmlContent($img_header_path);
$dataArr = ["addr" => $data[0]["ZipCode"] . " " . $data[0]["City"] . " " . $data[0]["Area"] . " " . $data[0]["Vil"] . " " . $data[0]["Verge"] . " " . $data[0]["Road"] . " " . $data[0]["addr"], "date" => $data[0]["date"], "ename" => $data[0]["ename"], "license" => $data[0]["license"]];
$img_header = $VTs->ContentReplace($dataArr, $img_header);
//print_r($img_header);
#量化資料
#主頁面量化資料欄位
$img_content_path = dirname(__DIR__) . "\\..\\..\\..\\..\\public\\include\\pageSetting\\oldhouse\\img_content.html";
$img_content = $VTs->GetHtmlContent($img_content_path);
//print_r($img_content);
$strSQL = "SELECT t1.uid,\n t10.`desc` as eng_str, t11.`desc` as problem, t1.`length`, t1.`width`, t1.`depth`, t1.`area`,\n t1.`remark`, t13.`imgfile`, t12.unit1 level\n FROM qc_item AS t1\n LEFT JOIN qc_info AS t2 ON t2.uid = t1.ifid\n LEFT JOIN qc_house AS t3 ON t3.uid = t2.huid\n LEFT JOIN house_type AS t4 ON t4.uid = t2.htid\n LEFT JOIN house_type_model AS t5 ON t5.uid = t2.htmid1 OR t5.uid = t2.htmid2\n LEFT JOIN house_type_structure AS t6 ON t6.uid = t2.htsid\n LEFT JOIN eng_engineer_city AS t7 ON t7.uid = t3.ecid\n LEFT JOIN eng_engineer AS t8 ON t8.uid = t7.eid\n LEFT JOIN ass_common AS t9 ON t9.uid = t8.cmid\n LEFT JOIN eng_str AS t10 ON t10.`uid` = t1.`strid`\n LEFT JOIN qc_checkitem AS t11 ON t11.uid = t1.ciid\n LEFT JOIN eng_unit AS t12 ON t12.uid = t1.val\n LEFT JOIN img_picture AS t13 ON t13.`uid` = t1.`imgids`\n WHERE t2.huid = " . $_GET["targetid"] . " AND (t1.`length` > 0 OR t1.width > 0 OR t1.depth > 0 OR t1.`area` > 0)\n ORDER BY t1.val DESC, t1.uid ASC";
$data = $VTs->QueryData($strSQL);
//$VTs->Debug($data);
$quantity_page = "";
for ($i = 0; $i < count($data); $i++) {
//$VTs->Debug($data[$i]);
$content = $img_content;
//print_r($content);
if ($data[$i]["area"] != 0) {
$value = "面積：" . $data[$i]["area"];
} else {
$value = "長：" . $data[$i]["length"] . " 寬：" . $data[$i]["width"] . " 高：" . $data[$i]["depth"];
}
#讀圖檔
$filePath = "C:\\xampp\\htdocs\\AP-Service\\public\\old_house_img\\";
//$filePath = "D:\\php_dev\\AP-Service\\public\\old_house_img\\";
$filePath .= $data[$i]["imgfile"];
//print_r("量化圖檔：".$filePath);
if (file_exists($filePath)) {
$imgArr = $VTs->GetINIInfo($filePath, "", "", "", true);
//$VTs->debug($imgArr["img0"]);
$img0 = $imgArr["img0"];
$img1 = $imgArr["img1"];
$img2 = $imgArr["img2"];
} else {
$img0 = "";
$img1 = "";
$img2 = "";
}
#替換@@
$dataArr = ["no" => $no++, "eng_str" => $data[$i]["eng_str"], "problem" => $data[$i]["problem"], "value" => $value, "remark" => $data[$i]["remark"], "level" => $data[$i]["level"], "img0" => $img0, "img1" => $img1, "img2" => $img2];
$content = $VTs->ContentReplace($dataArr, $content);
//print_r($content);
$quantity_page .= $img_header . $content;
}
//print_r($quantity_page);
#量化資料End
#質化資料
$strSQL = "SELECT t1.uid,\n t10.`desc` as eng_str, t11.`desc` as problem, t1.`length`, t1.`width`, t1.`depth`, t1.`area`,\n t1.`remark`, t13.`imgfile`, t12.unit1 level\n FROM qc_item AS t1\n LEFT JOIN qc_info AS t2 ON t2.uid = t1.ifid\n LEFT JOIN qc_house AS t3 ON t3.uid = t2.huid\n LEFT JOIN house_type AS t4 ON t4.uid = t2.htid\n LEFT JOIN house_type_model AS t5 ON t5.uid = t2.htmid1 OR t5.uid = t2.htmid2\n LEFT JOIN house_type_structure AS t6 ON t6.uid = t2.htsid\n LEFT JOIN eng_engineer_city AS t7 ON t7.uid = t3.ecid\n LEFT JOIN eng_engineer AS t8 ON t8.uid = t7.eid\n LEFT JOIN ass_common AS t9 ON t9.uid = t8.cmid\n LEFT JOIN eng_str AS t10 ON t10.`uid` = t1.`strid`\n LEFT JOIN qc_checkitem AS t11 ON t11.uid = t1.ciid\n LEFT JOIN eng_unit AS t12 ON t12.uid = t1.val\n LEFT JOIN img_picture AS t13 ON t13.`uid` = t1.`imgids`\n WHERE t2.huid = " . $_GET["targetid"] . " AND (t1.`length` = 0 and t1.width = 0 and t1.depth = 0 and t1.`area` = 0)\n ORDER BY t1.val DESC, t1.uid ASC";
$data = $VTs->QueryData($strSQL);
//$VTs->Debug($data);
$quality_page = "";
for ($i = 0; $i < count($data); $i++) {
//$VTs->Debug($data[$i]);
$content = $img_content;
#讀圖檔
$filePath = "C:\\xampp\\htdocs\\AP-Service\\public\\old_house_img\\";
//$filePath = "D:\\php_dev\\AP-Service\\public\\old_house_img\\";
$filePath .= $data[$i]["imgfile"];
//print_r("質化圖檔：".$filePath);
if (file_exists($filePath)) {
$imgArr = $VTs->GetINIInfo($filePath, "", "", "", true);
//$VTs->debug($imgArr["img0"]);
$img0 = $imgArr["img0"];
$img1 = $imgArr["img1"];
$img2 = $imgArr["img2"];
} else {
$img0 = "";
$img1 = "";
$img2 = "";
}
$dataArr = ["no" => $no++, "eng_str" => $data[$i]["eng_str"], "problem" => $data[$i]["problem"], "value" => $value, "remark" => $data[$i]["remark"], "photo" => $img, "level" => $data[$i]["level"], "img0" => $img0, "img1" => $img1, "img2" => $img2];
$content = $VTs->ContentReplace($dataArr, $content);
$quality_page .= $img_header . $content;
}
#值化資料End
// $dataArr = [
// "img_header" => $img_header,
// "img_content" => $img_content
// ];
// $img_page = $VTs->ContentReplace($dataArr,$img_page);
$dataArr = ["img_page" => $quantity_page . $quality_page];
$img_html = $VTs->ContentReplace($dataArr, $img_html);
$pageContent = $img_html;
break;
}
//-----BI結束-----
} catch (Exception $error) {
//依據Controller, Action補上對應位置, $error->getMessage()為固定部份
$VTs->WriteLog("IndexController", "indexAction", $error->getMessage());
}
//關閉資料庫連線
$VTs->DBClose();
//釋放
$VTs = null;
$this->viewContnet['pageContent'] = $pageContent;
return new ViewModel($this->viewContnet);
}
public function getmobileitemlistAction()
{
$VTs = new clsSystem();
$VTs->initialization();
//-----BI開始-----
$action = array();
$action["status"] = false;
if (!empty($_POST["dataid"]) and !empty($_POST["dataDB"])) {
$sDB = $_POST["dataDB"];
$dataid = $_POST["dataid"];
$data = null;
switch ($sDB) {
case "qc_checklist":
//開始做資料庫設定檔
$filePath = dirname(__DIR__) . "\\..\\..\\..\\..\\public\\include\\qcListSet\\content.ini";
if (!file_exists($filePath)) {
$filePath = str_replace("\\", "/", $filePath);
}
$optionArr = $VTs->GetINIInfo($filePath, "", "", "", true, true);
//create Sample
$strSQL = "select @@selectOption@@ from qc_checklist t1 ";
$strSQL .= "@@content@@";
$strSQL .= "where t1.typeid=@@typeid@@ and t1.isok=0 and t1.imgid is null";
$tmpDataArr = null;
foreach ($optionArr as $key => $contents) {
$tmpStrSQL = $strSQL;
$tmpContentStr = '';
foreach ($contents as $contentkey => $dbContent) {
if ($contentkey != "selectOption") {
$tmpContentStr .= "left join " . $contentkey . " " . $dbContent . " ";
}
}
//將處理好的資料取代好
$tmpStrSQL = str_replace("@@selectOption@@", $contents["selectOption"], $tmpStrSQL);
$tmpStrSQL = str_replace("@@content@@", $tmpContentStr, $tmpStrSQL);
$tmpStrSQL = str_replace("@@typeid@@", str_replace("type", "", $key), $tmpStrSQL);
//開始取得資料
$data = $VTs->QueryData($tmpStrSQL);
if (!empty($data)) {
$tmpDataArr[$key] = $data;
}
}
$processArr = [];
//如果不為空則開始處理
if (!empty($tmpDataArr)) {
foreach ($tmpDataArr as $content) {
$processArr = array_merge($processArr, $content);
}
}
if (!empty($processArr)) {
$data = $processArr;
}
break;
}
if (!empty($data)) {
$action["itemlist"] = $data;
} else {
$action["msg"] = '無審查資料';
}
$action["status"] = true;
} else {
if (empty($_POST["dataid"])) {
$action["msg"] = 'dataid is Empty';
} else {
$action["msg"] = 'dataDB is Empty';
}
}
$pageContent = $VTs->Data2Json($action);
//-----BI結束-----
$VTs = null;
$this->viewContnet['pageContent'] = $pageContent;
return new ViewModel($this->viewContnet);
}
public function pageAction()
{
$VTs = new clsSystem();
$VTs->initialization();
//-----BI開始-----
$action = array();
$action["status"] = false;
if (!empty($_POST)) {
switch ($_POST["type"]) {
//取得語言
case "getLan":
//如果未設定語系，先設定
if (!isset($_SESSION["lang"])) {
//先取得語系列表
$langListArr = $this->langList();
//取得伺服器本身的語言
$lang = strtolower(strtok(strip_tags($_SERVER['HTTP_ACCEPT_LANGUAGE']), ','));
$lang = str_replace("zh-", "", $lang);
if (!empty($langListArr)) {
if (!in_array($lang, $langListArr["list"])) {
$lang = 'tw';
}
} else {
$lang = 'tw';
}
}
//取得語言設定檔
$langPath = dirname(__DIR__) . "\\..\\..\\..\\..\\public\\include\\language\\";
$langPath .= !empty($_POST["selectLang"]) ? $_POST["selectLang"] : $lang;
$langPath .= ".ini";
if (!file_exists($langPath)) {
$langPath = str_replace("\\", "/", $langPath);
}
if (file_exists($langPath)) {
$action["langContent"] = $VTs->GetINIInfo($langPath, "", "", "", true);
$action["status"] = true;
} else {
$action["msg"] = 'Lang File is not Find';
}
$action["lang"] = $lang;
break;
//取得語言設定檔
//取得語言設定檔
case "getLanContent":
if (!empty($_POST["selectLang"])) {
$langPath = dirname(__DIR__) . "\\..\\..\\..\\..\\public\\include\\language\\" . $_POST["selectLang"] . ".ini";
if (!file_exists($langPath)) {
$langPath = str_replace("\\", "/", $langPath);
}
if (file_exists($langPath)) {
$action["langContent"] = $VTs->GetINIInfo($langPath, "", "", "", true);
$action["status"] = true;
} else {
$action["msg"] = 'Lang File is not Find';
}
} else {
$action["msg"] = 'Lang Select is Empty';
}
break;
}
}
$pageContent = $VTs->Data2Json($action);
//----BI結束----
$VTs = null;
$this->viewContnet['pageContent'] = $pageContent;
return new ViewModel($this->viewContnet);
}
