public function examinerecordAction() { $VTs = new clsSystem(); $VTs->initialization("oldhouseDB"); //-----BI開始----- $action = array(); $action["status"] = false; //$VTs->debug($_POST["record"]); if (!empty($_POST)) { $TargetID = !empty($_POST["record"]["TargetID"]) ? $_POST["record"]["TargetID"] : 0; $TypeID = !empty($_POST["record"]["TypeID"]) ? $_POST["record"]["TypeID"] : 0; $ScaleID1 = !empty($_POST["record"]["ScaleID1"]) ? $_POST["record"]["ScaleID1"] : null; $ScaleID2 = !empty($_POST["record"]["ScaleID2"]) ? $_POST["record"]["ScaleID2"] : null; $StructID = !empty($_POST["record"]["StructID"]) ? $_POST["record"]["StructID"] : 0; //新增qc_info $date = date("Y-m-d"); //echo $date; if ($ScaleID2 != null) { $strSQL = "insert into qc_info (huid, htid, htmid1, htmid2, htsid, `date`)\n values(" . $TargetID . ", " . $TypeID . ", " . $ScaleID1 . ", " . $ScaleID2 . ", " . $StructID . ", '" . $date . "')"; //"insert into qc_info (huid, htid, htmid1, htmid2, htsid, `date`) // values(".$_POST["record"]["TargetID"].", ".$_POST["record"]["TypeID"].", ".$_POST["record"]["ScaleID1"].", ".$_POST["record"]["ScaleID2"].", ".$_POST["record"]["StructID"].", '".$date."')"; } else { $strSQL = "insert into qc_info (huid, htid, htmid1, htsid, `date`)\n values(" . $TargetID . ", " . $TypeID . ", " . $ScaleID1 . ", " . $StructID . ", '" . $date . "')"; } //print_r("qc_info: " . $strSQL . "<br><br>"); $VTs->ExecuteNonQuery($strSQL); $strSQL = "select uid from qc_info order by uid desc Limit 1"; //print_r("qc_info_uid: " . $strSQL . "<br><br>"); $data = $VTs->QueryData($strSQL); $ifid = $data[0]["uid"]; //新增照片 $datas = $_POST["record"]["RecordDatas"]; //print_r("Datas:"); //$VTs->debug($datas); foreach ($datas as $i => $content) { //print_r("Imgs:"); //$VTs->debug($content["imgs"]); //圖片存檔 $Imgs = $content["imgs"]; $imgId = ImgSet($Imgs); //print_r("照片ID:".$imgId); //echo "imgID: ". $imgId; //計算危險等級 //$VTs->Debug($content); //量化資料才需計算等級,質化資料之Val即為危險等級。 if ($content["Length"] > 0 || $content["Width"] > 0 || $content["Depth"] > 0 || $content["Area"] > 0) { $content = Quality2Amount($content); } //$VTs->Debug($content); //新增qc_item $Length = !empty($content["Length"]) ? $content["Length"] : 0; $Width = !empty($content["Width"]) ? $content["Width"] : 0; $Depth = !empty($content["Depth"]) ? $content["Depth"] : 0; $Area = !empty($content["Area"]) ? $content["Area"] : 0; $ValID = !empty($content["ValID"]) ? $content["ValID"] : 0; $strSQL = "insert into qc_item (ifid, strid, ciid, `length`, width, depth, `area`, val, imgids, remark) "; $strSQL .= "values (" . $ifid . ", " . $content["PlaceID"] . ", " . $content["ProblemID"] . ", " . $Length . ", " . $Width . ", " . $Depth . ", " . $Area . ", " . $ValID . ", " . $imgId . ", '" . $content["Remark"] . "')"; //print_r("qc_item: " . $strSQL . "<br><br>"); $VTs->ExecuteNonQuery($strSQL); } $action["status"] = true; } else { $action["msg"] = '新增失敗'; } #產PDF $strSQL = "select hname, htel from qc_house where uid = " . $TargetID; //print_r($strSQL); $data = $VTs->QueryData($strSQL); if (!empty($data)) { //print_r("產生PDF"); //print_r("http://211.21.170.18/Oldhouse/report?targetid=".$TargetID."&page=main_page"); //$VTs->Page2PDF("http://127.0.0.1:200/Oldhouse/report?targetid=".$TargetID, "D:\\php_dev\\AP-Service\\public\\old_house_pdf\\".md5($data[0]["hname"])."-".$data[0]["htel"]); //$VTs->Page2PDF("http://192.168.0.188/Oldhouse/report?targetid=".$TargetID, "C:\\xampp\\htdocs\\Construct-Management\\public\\old_house_pdf\\".iconv("utf-8", "big5", $data[0]["hname"])."-".$data[0]["htel"]); echo $VTs->Page2PDF("http://211.21.170.18/Oldhouse/report?targetid=" . $TargetID . "&page=main_page", "C:\\xampp\\htdocs\\Construct-Management\\public\\old_house_pdf\\" . iconv("utf-8", "big5", $data[0]["hname"]) . "-" . $data[0]["htel"]); echo "<br/>"; echo $VTs->Page2PDF("http://211.21.170.18/Oldhouse/report?targetid=" . $TargetID . "&page=img_page", "C:\\xampp\\htdocs\\Construct-Management\\public\\old_house_pdf\\" . iconv("utf-8", "big5", $data[0]["hname"]) . "-" . $data[0]["htel"] . "-imgs"); echo "<br/>"; // $VTs->Page2PDF("http://127.0.0.1:200/Oldhouse/report?targetid=".$TargetID."&page=main_page", "D:\\php_dev\\Construct-Management\\public\\old_house_pdf\\".iconv("utf-8", "big5", $data[0]["hname"])."-".$data[0]["htel"]); // $VTs->Page2PDF("http://127.0.0.1:200/Oldhouse/report?targetid=".$TargetID."&page=img_page", "D:\\php_dev\\Construct-Management\\public\\old_house_pdf\\".iconv("utf-8", "big5", $data[0]["hname"])."-".$data[0]["htel"]."-imgs"); } $pageContent = $VTs->Data2Json($action); //-----BI結束----- $VTs = null; $this->viewContnet['pageContent'] = $pageContent; return new ViewModel($this->viewContnet); }