\n"; print "\n"; #注文詳細 #商品Np: 1:3G 2:5G 3:SVR 固定 #販売区分:HanbaiKubun 1:販売 2:レンタル 3:定期 4:無料(お試し) 5:無料(クレーム) 6:無料(サービス) 7:無料(紹介) 8:無料(メンテ) 9:メンテナンス 10:オアシス 11:社員 $tsql = "SELECT * from Order_Details WHERE JyutyuNo = '".$jNo."'"; $result = sqlsrv_query($db_ms, $tsql); while($row = sqlsrv_fetch_array($result)) { $sNo = $row['SyouhinNo']; if($row['HanbaiKubun'] >= 4 && $row['HanbaiKubun'] <= 8){ $sNo = $sNo."-0"; //無料の場合 $MuryoNo = $row['HanbaiKubun']; }else{ $hanbai_kbn = $row['HanbaiKubun']; } $Ord_info[$sNo]["HanbaiKubun"] = $row['HanbaiKubun']; $Ord_info[$sNo]["Suryo"] = $row['Suryo']; $Ord_info[$sNo]["Tanka"] = $row['Tanka']; $Ord_info[$sNo]["Kingaku"] = $row['Kingaku']; } sqlsrv_free_stmt($result); ##付属品の取得 $fuzoku_i = 0; $fsql = "SELECT Order_Details.SyouhinNo,Order_Details.Suryo,M_Syohin.SyouhinTanka FROM Order_Details INNER JOIN M_Syohin ON Order_Details.SyouhinNo = M_Syohin.SyouhinNo WHERE Order_Details.SyouhinNo >= '4' AND Order_Details.KokyakuNo = '".$kNo."' AND Order_Details.EdaNo = '".$eNo."' AND Order_Details.JyutyuNo = '".$jNo."' AND Order_Details.DelDate = ''"; $fres = sqlsrv_query($db_ms,$fsql); while($frow = sqlsrv_fetch_array($fres)){ $fuzoku_SyouhinNo[$fuzoku_i] = $frow["SyouhinNo"]; $fuzoku_Suryo[$fuzoku_i] = $frow["Suryo"]; $fuzoku_tanka[$fuzoku_i] = $frow["SyouhinTanka"]; $fuzoku_i ++; } if($fuzoku_SyouhinNo[0] != ""){ $item1_no = $fuzoku_SyouhinNo[0]; $item1_kosu = $fuzoku_Suryo[0]; $item1_tanka = $fuzoku_tanka[0]; } if($fuzoku_SyouhinNo[1] != ""){ $item2_no = $fuzoku_SyouhinNo[1]; $item2_kosu = $fuzoku_Suryo[1]; $item2_tanka = $fuzoku_tanka[1]; } if($fuzoku_SyouhinNo[2] != ""){ $item3_no = $fuzoku_SyouhinNo[2]; $item3_kosu = $fuzoku_Suryo[2]; $item3_tanka = $fuzoku_tanka[2]; } }elseif($gNo){ #業務指示 $tsql = "SELECT * from Work_Instructions WHERE GyomuNo = '".$gNo."'"; $result = sqlsrv_query($db_ms, $tsql); $row = sqlsrv_fetch_array($result); $Renraku = $row['Naiyo']; $Houmondate = $row['Houmondate']; $Ittekoi_flg = 1; sqlsrv_free_stmt($result); } ####不在登録 $fuzai_flg = 0; if($_POST{"touroku"}==" 配達完了! "){ $hou_time = $_POST{"hou_time"}; $hou_time = date("H:i"); //2012/12/3 登録時 $HoumonNo = set_zero($_POST{"HoumonNo"}); $Bikou = $_POST{"Bikou"}; $StarMark = $_POST{"StarMark"}; #必須項目チェック $err_flg = 0; $err_cmt = ""; if(($HoumonNo == "1") && !$hou_time){ $err_flg++; $err_cmt .= '

訪問時間が入力されていません!

'; } if(($HoumonNo == "1") && !$err_flg){ #不在だったら、受注情報の配達状況を2にしておわり。 $Haitatudate = $Haitatsubi." ".$hou_time; $tsql = "UPDATE Order_Info SET HaitasuJyokyo = '2', Haitatudate = '".$Haitatudate."' WHERE JyutyuNo = '".$jNo."' "; #print "\n"; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } #不在の実績を残す $tsql = "INSERT INTO Work_Results ( Haitatsubi,JyutyuNo,GyomuNo,HaitatsusyaNo,Jikan,KokyakuNo,EdaNo,Tanka_3G,Suryo_3G,Tanka_5G,Suryo_5G, Other_Kingaku,Kara_3G,Kara_5G,MuryoNo,Free_3G,Free_5G,HoumonNo,UriagekinKaisyuKB, MenteKingaku,MisyuKingaku,TourokuMotoFlg,Bikou,StarMark,DelDate,HenkinKingaku) VALUES ('".$Haitatsubi."','".set_zero($jNo)."','".set_zero($gNo)."','".$HaitatsusyaNo."','".$hou_time."','".$kNo."','".$eNo."','0','0','0','0' ,'','','','','0','0','".$HoumonNo."','0' ,'','','1','".$Bikou."','".$StarMark."','','0'); "; #print "\n"; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } $cmp_cmt = '

不在情報登録が完了しました。

'; $fuzai_flg = 1; } } ###代行登録 /* if($_POST{"touroku"}==" 代行依頼済み "){ ## 代行 $tsql = "UPDATE Order_Info SET HaitasuJyokyo = '3' WHERE JyutyuNo = '".$jNo."' "; #print "\n"; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } $cmp_cmt = '

代行登録が完了しました。

'; $fuzai_flg = 1; }else */ if($_POST{"touroku"}=="注文キャンセル"){ ###注文キャンセル $tsql = "UPDATE Order_Info SET HaitasuJyokyo = '4' WHERE JyutyuNo = '".$jNo."' "; #print "\n"; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } $cmp_cmt = '

キャンセル登録が完了しました。

'; $fuzai_flg = 1; } ###メンテがある場合 if($MenteDspNo){ //メンテがキャンセルされてないか調べる $mcsql = "SELECT * FROM Order_Details WHERE JyutyuNo = '".$jNo."' AND SyouhinNo = '3' AND DelDate = ''"; $mcres = sqlsrv_query($db_ms,$mcsql); $mcrow = sqlsrv_fetch_array($mcres); if($mcrow[MeisaiNo]){ $pay_mente = 0; $MenteDsp = explode("|", $MenteDspNo); $cnt_dsp = count($MenteDsp); for($i=0; $i < $cnt_dsp ;$i++){ $DspNo = $MenteDsp[$i]; $tsql = "SELECT * from DSP_Setting_Info WHERE DspNo = '".$DspNo."' AND DelDate = '' ORDER BY InfoNo DESC"; $result = sqlsrv_query($db_ms, $tsql); $row = sqlsrv_fetch_array($result); $SvrKubun = $row['SvrKubun']; $MenteRate = $row['MenteRate']; ## 無料メンテの場合あり if($Ord_info[3]["Tanka"] === 0){ $pay_mente = 0; }else{ $pay_mente += $Arr_MenteRate[$MenteRate]; } print "\n"; } $SrvMenteFlg = "true"; }else{ $SrvMenteFlg = "false"; } } #print ""; ########################################################## # 配達済みの場合:表示用の実績を取得 # ########################################################## if(($HaitasuJyokyo == 1) || $Houmondate){ $houmonsumi = 1; if($jNo){ $where = "WHERE JyutyuNo = '".$jNo."'"; } if($gNo){ $where = "WHERE GyomuNo = '".$gNo."'"; } #付属品情報の初期化 $item1_no = ""; $item1_kosu = ""; $item1_tanka = ""; $item2_no = ""; $item2_kosu = ""; $item2_tanka = ""; $item3_no = ""; $item3_kosu = ""; $item3_tanka = ""; /* 2015/11/16 SQL文修正:"ORDER BY JisekiNo DESC" 追加 */ $tsql = "SELECT * from Work_Results ".$where." ORDER BY JisekiNo DESC"; #print "\r\n"; $result = sqlsrv_query($db_ms, $tsql); $row = sqlsrv_fetch_array($result); $hou_time = $row['Jikan']; $ord_g3_tanka = set_zero($row['Tanka_3G']); $ord_g3 = set_zero($row['Suryo_3G']); $ord_g5_tanka = set_zero($row['Tanka_5G']); $ord_g5 = set_zero($row['Suryo_5G']); $free_g3 = set_zero($row['Free_3G']); $free_g5 = set_zero($row['Free_5G']); $MuryoNo = $row['MuryoNo']; $muryo_tojiru = "true"; if($free_g3!=0 || $free_g5!=0)$muryo_tojiru = "false"; $itemdai = set_zero($row['Other_Kingaku']); $MisyuKingaku = set_zero($row['MisyuKingaku']); $UriagekinKaisyuKB = set_zero($row['UriagekinKaisyuKB']); $Kara_3G = $row['Kara_3G']; $Kara_5G = $row['Kara_5G']; $HoumonNo = $row['HoumonNo']; $Bikou = $row['Bikou']; $StarMark = $row['StarMark']; $UriageNo = $row['UriageNo']; $JisekiNo = $row['JisekiNo']; sqlsrv_free_stmt($result); if($itemdai && $UriageNo){ #売上情報からアイテム情報取出 $tsql = "SELECT * from Sales_Details WHERE SyouhinNo BETWEEN 4 AND 16 AND UriageNo='".$UriageNo."'"; #print "\r\n"; $result = sqlsrv_query($db_ms,$tsql); $i = 0; while($trow = sqlsrv_fetch_array($result)) { if($i == 0){ $item1_no = $trow['SyouhinNo']; $item1_kosu = $trow['Suryo']; $item1_tanka = $trow['Tanka']; #print "\r\n"; } if($i == 1){ $item2_no = $trow['SyouhinNo']; $item2_kosu = $trow['Suryo']; $item2_tanka = $trow['Tanka']; } if($i == 2){ $item3_no = $trow['SyouhinNo']; $item3_kosu = $trow['Suryo']; $item3_tanka = $trow['Tanka']; } $i++; } sqlsrv_free_stmt($result); } #スキャンボトルの登録があるか $bsql = "SELECT * FROM BottleKanri WHERE Syukkabi='".$Haitatsubi."' AND KokyakuNo='".$kNo."' AND EdaNo='".$eNo."'"; $result = sqlsrv_query($db_ms,$bsql); $scan_bottle = array(); $i = 0; while($brow = sqlsrv_fetch_array($result)) { $scan_bottle[$i] = $brow['BottleCD']; $i++; } } ########################################################## # ↑ 表示用の実績取得ここまで ↑ # ########################################################## ########################################################## # 情報取得その1 # ########################################################## #顧客情報取得 if($eNo != ""){ $eda = " AND EdaNo= '".$eNo."'"; } $tsql = "SELECT * from Customer WHERE KokyakuNo = '".$kNo."' ".$eda." "; $result = sqlsrv_query($db_ms, $tsql); $CstmTbl = sqlsrv_fetch_array($result); sqlsrv_free_stmt($result); $PaymentDsp = $CstmTbl[PaymentDsp]; //支払方法(SVR) $PaymentWater = $CstmTbl[PaymentWater]; //支払方法(水) $HikiotosiFukaCnt = $CstmTbl[HikiotosiFukaCnt]; //Qネット引落不可回数 $TyuiJikou = $CstmTbl["TyuiJikou"]; //注意事項 $SvrOptionInfo = $CstmTbl["SvrOptionInfo"]; //付属品情報 $RackDaisu = $CstmTbl["RackDaisu"]; //ボトルラックレンタル台数 $Information = $CstmTbl["Information"]; //情報 //201906追記 MEMO情報取得 $Memo = $CstmTbl["SyukyakuMokuhyo"]; //201911 3本目以降単価取得 $WaterTanka3_3rd = $CstmTbl["WaterTanka3_3rd"]; $WaterTanka5_3rd = $CstmTbl["WaterTanka5_3rd"]; //201910顧客TODO取得 $hsql4 = "SELECT * FROM CustomerToDo WHERE KokyakuNo = '".$CstmTbl[KokyakuNo]."' AND EdaNo = '".$CstmTbl[EdaNo]."' AND JyutyuNo = '".$jNo."'"; $hres4 = sqlsrv_query($db_ms,$hsql4); $hrow4 = sqlsrv_fetch_array($hres4); $ToDo = $hrow4["Naiyou"]; //201910追加 ToDo //201911 3本目単価の為に今月の本数を取得 //$kongetu_total = 0; //$kongetu_3G = 0; //$kongetu_5G = 0; //$thsql = "SELECT sum(Suryo_3G),sum(Suryo_5G),sum(Free_3G),sum(Free_5G),sum(Kara_3G),sum(Kara_5G) // from Work_Results // WHERE KokyakuNo = '".$kNo."' // AND EdaNo = '".$CstmTbl[EdaNo]."' // AND Haitatsubi >= '".$ippi."' // AND DelDate = '' "; //$resultth = sqlsrv_query($db_ms, $thsql); //$rowth = sqlsrv_fetch_array($resultth); //$SlsTbl[$i]["Suryo_3G"] = set_zero($row2[0]); //$SlsTbl[$i]["Suryo_5G"] = set_zero($row2[1]); //sqlsrv_free_stmt($resultth); //$kongetu_total += $SlsTbl[$i]["Suryo_3G"]; //$kongetu_total += $SlsTbl[$i]["Suryo_5G"]; //print "[今月個数:".$kongetu_total."]"; #今月 $kongetu = date('Y/m/'); $kongetu_honsu = 0; $hsql1 = "SELECT SUM(Sales_Details.Suryo) FROM Sales_Details,Sales_Info WHERE Sales_Details.UriageNo = Sales_Info.UriageNo AND Sales_Details.SyouhinNo <= '2' AND Sales_Details.KokyakuNo = '".$kNo."' AND Sales_Details.EdaNo = '".$CstmTbl[EdaNo]."' AND Sales_Info.Uriagebi LIKE '".$kongetu."%' AND Sales_Info.Deldate = '' AND Sales_Details.Deldate = ''"; $hres1 = sqlsrv_query($db_ms,$hsql1); $hrow1 = sqlsrv_fetch_array($hres1); $kongetu_honsu = set_zero($hrow1[0]); //print "[顧客番号:".$kNo."]"; //print "[顧客番号:".$CstmTbl[EdaNo]."]"; print "[今月本数:".$kongetu_honsu."]"; print "[3本目以降5ガロン:".$WaterTanka5_3rd."]"; #無料理由取得 $tsql = "SELECT * from M_Free ORDER BY MuryoNo "; $result = sqlsrv_query($db_ms, $tsql); $i = 0; while($row = sqlsrv_fetch_array($result)) { if($row['MuryoNo']){ $Free_info[$i]["MuryoNo"] = $row['MuryoNo']; $Free_info[$i]["MuryoCD"] = $row['MuryoCD']; $Free_info[$i]["MuryoNaiyo"] = $row['MuryoNaiyo']; $i++; } } $cnt_free = $i; sqlsrv_free_stmt($result); #商品一覧取得 $tsql = "SELECT * from M_Syohin ORDER BY SyouhinNo "; $result = sqlsrv_query($db_ms, $tsql); $i = 0; while($row = sqlsrv_fetch_array($result)) { $Item_info[$i]["SyouhinNo"] = $row['SyouhinNo']; $Item_info[$i]["SyouhinName"] = $row['SyouhinName']; $Item_info[$i]["SyohinTani"] = $row['SyohinTani']; $Item_tanka[$row['SyouhinNo']] = $row['SyouhinTanka']; $i++; } $cnt_item = $i; sqlsrv_free_stmt($result); #訪問コード取得 $tsql = "SELECT * from M_Houmon ORDER BY HoumonNo "; $result = sqlsrv_query($db_ms, $tsql); $i = 1; while($row = sqlsrv_fetch_array($result)) { $Houmon_info[$i]["HoumonNo"] = $row['HoumonNo']; $Houmon_info[$i]["HoumonCD"] = $row['HoumonCD']; $Houmon_info[$i]["HoumonNaiyo"] = $row['HoumonNaiyo']; $i++; } $cnt_Houmon = $i; sqlsrv_free_stmt($result); #水単価 $tsql = "SELECT * from M_WaterPrice ORDER BY TankaNo "; $result = sqlsrv_query($db_ms, $tsql); $i = 0; while($row = sqlsrv_fetch_array($result)) { $TankaNo = $row['TankaNo']; $Mizu_info[$TankaNo]["MizuKubun"] = $row['MizuKubun']; $Mizu_info[$TankaNo]["Tanka"] = $row['Tanka']; $i++; } $cnt_wtanka = $i; sqlsrv_free_stmt($result); ###未収売上チェック if($eNo != ""){ $eda = " AND (Sales_Info.EdaNo= '".$eNo."')"; } $tsql = "SELECT Sales_Info.UriageNo, Sales_Info.KokyakuNo,Sales_Info.EdaNo, Sales_Info.Uriagebi, SUM(ISNULL(Sales_Details.Kingaku, 0)) AS Kingaku, SUM(ISNULL(Money_Management.Nyukingaku, 0)) AS Nyukingaku FROM Sales_Info LEFT OUTER JOIN Sales_Details ON Sales_Info.UriageNo = Sales_Details.UriageNo LEFT OUTER JOIN Money_Management ON Sales_Info.UriageNo = Money_Management.UriageNo WHERE (Sales_Info.KokyakuNo = '".$kNo."') ".$eda." AND (Sales_Info.DelDate = '') AND (Sales_Details.DelDate = '') GROUP BY Sales_Info.UriageNo, Sales_Info.KokyakuNo,Sales_Info.EdaNo, Sales_Info.Uriagebi HAVING (SUM(Sales_Details.Kingaku) > SUM(ISNULL(Money_Management.Nyukingaku, 0))) ORDER BY Sales_Info.Uriagebi"; $result = sqlsrv_query($db_ms, $tsql); $i = 0; $cnt_Sls = 0; $cnt_Misyu = 0; $TotalKingaku = 0; while($row = sqlsrv_fetch_array($result)) { print "\n"; $SlsTbl[$i]["UriageNo"] = $row['UriageNo']; $SlsTbl[$i]["JyutyuNo"] = $row['JyutyuNo']; $SlsTbl[$i]["Uriagebi"] = $row['Uriagebi']; #トータル金額 $SlsTbl[$i]["Totalkingaku"] = $row[Kingaku]; #print "\n"; #入金済み金額 $SlsTbl[$i]["Nyukingaku"] = $row[Nyukingaku]; #print "\n"; if($SlsTbl[$i]["Nyukingaku"] != $SlsTbl[$i]["Totalkingaku"]){ #未収回収チェック $cnt_Misyu++; #レンタルかどうか $dsql = "SELECT * from Sales_Details WHERE UriageNo = '".$row['UriageNo']."' AND HanbaiKubun = '2'"; $result3 = sqlsrv_query($db_ms, $dsql); $row3 = sqlsrv_fetch_array($result3); $re_flg = sqlsrv_has_rows($result3); if($re_flg){ $SlsTbl[$i]["re_flg"] = '(レンタル代)'; } sqlsrv_free_stmt($result3); } $i++; } print ""; $cnt_Sls = $i; //未収売上件数 sqlsrv_free_stmt($result); if(($HaitasuJyokyo != 1) && !$Houmondate && !$fuzai_flg){ #### 料金計算 $ord_g3 = $Ord_info[1]["Suryo"]; $ord_g5 = $Ord_info[2]["Suryo"]; if($Ord_info[1]["HanbaiKubun"] == 10){ #オアシス販売 $ord_g3_tanka = $oasisu_Tanka; }elseif($Ord_info[1]["Tanka"]){ $ord_g3_tanka = $Ord_info[1]["Tanka"]; }elseif(($CstmTbl["WaterTanka3_3rd"]) && ($kongetu_honsu >= 2)){ //201911 3本目以降単価があり、今月本数が既に2本以上の場合 //$ord_g3_3_tanka = $Mizu_info[$CstmTbl["WaterTanka3_3rd"]]["Tanka"]; if(($kNo == '3366') || ($kNo == '990') || ($kNo == '2154') || ($kNo == '2155')){ $ord_g3_3_tanka = 950; }elseif(($kNo == '2162') || ($kNo == '2159') || ($kNo == '2160') || ($kNo == '4285') || ($kNo == '4982') || ($kNo == '5108') || ($kNo == '5618') || ($kNo == '5619') || ($kNo == '5939') || ($kNo == '6023') || ($kNo == '6024') || ($kNo == '6025') || ($kNo == '6033')){ $ord_g3_3_tanka = 850; }else{ $ord_g3_3_tanka = 1350; } }elseif(($CstmTbl["WaterTanka3_3rd"]) && ($kongetu_honsu == 0)){ //201911 3本目以降単価があり、今月本数0の場合 //$ord_g3_3_tanka = $Mizu_info[$CstmTbl["WaterTanka3_3rd"]]["Tanka"]; if(($kNo == '3366') || ($kNo == '990') || ($kNo == '2154') || ($kNo == '2155')){ $ord_g3_3_tanka = 950; }elseif(($kNo == '2162') || ($kNo == '2159') || ($kNo == '2160') || ($kNo == '4285') || ($kNo == '4982') || ($kNo == '5108') || ($kNo == '5618') || ($kNo == '5619') || ($kNo == '5939') || ($kNo == '6023') || ($kNo == '6024') || ($kNo == '6025') || ($kNo == '6033')){ $ord_g3_3_tanka = 850; }else{ $ord_g3_3_tanka = 1350; } $ord_g3_tanka = $Mizu_info[$CstmTbl["WaterTanka3"]]["Tanka"]; }else{ $ord_g3_tanka = $Mizu_info[$CstmTbl["WaterTanka3"]]["Tanka"]; } if($Ord_info[2]["HanbaiKubun"] == 10){ #オアシス販売 $ord_g5_tanka = $oasisu_Tanka; }elseif($Ord_info[2]["Tanka"]){ $ord_g5_tanka = $Ord_info[2]["Tanka"]; }elseif(($WaterTanka5_3rd > 0) && ($kongetu_honsu >= 2)){ //3本目以降単価があり、今月本数が既に2本以上の場合 //$ord_g5_3_tanka = $Mizu_info[$CstmTbl["WaterTanka5_3rd"]]["Tanka"]; $ord_g5_3_tanka = 1350; }elseif(($WaterTanka5_3rd > 0) && ($kongetu_honsu == 0)){ //3本目以降単価があり、今月本数が0本の場合 //$ord_g5_3_tanka = $Mizu_info[$CstmTbl["WaterTanka5_3rd"]]["Tanka"]; $ord_g5_3_tanka = 1350; $ord_g5_tanka = $Mizu_info[$CstmTbl["WaterTanka5"]]["Tanka"]; }else{ $ord_g5_tanka = $Mizu_info[$CstmTbl["WaterTanka5"]]["Tanka"]; } print "[単価:".$ord_g5_tanka."]"; print "[3本目以降単価:".$ord_g5_3_tanka."]"; } if($_POST{"mode"} == "JISSEKI"){ $ord_g3 = set_zero($_POST{"ord_g3"}); $ord_g5 = set_zero($_POST{"ord_g5"}); $ord_g3_tanka = set_zero($_POST{"ord_g3_tanka"}); $ord_g5_tanka = set_zero($_POST{"ord_g5_tanka"}); //2019113本目以降単価 //$ord_g3_3_tanka = set_zero($_POST{"ord_g3_3_tanka"}); //$ord_g5_3_tanka = set_zero($_POST{"ord_g5_3_tanka"}); $ord_g3_3_tanka = 1350; $ord_g5_3_tanka = 1350; $hanbai_kbn = $_POST{"hanbai_kbn"}; $item1_kosu = set_zero($_POST{"item1_kosu"}); $item2_kosu = set_zero($_POST{"item2_kosu"}); $item3_kosu = set_zero($_POST{"item3_kosu"}); $item1_no = $_POST{"item1_no"}; $item2_no = $_POST{"item2_no"}; $item3_no = $_POST{"item3_no"}; #$pay_rentaru = set_zero($_POST{"pay_rentaru"}); $hou_time = $_POST{"hou_time"}; $hou_time = date("H:i"); //2012/12/3 登録時 $MisyuKingaku = set_zero($_POST{"MisyuKingaku"}); $misyu = $_POST{"misyu"}; #print_r ($misyu); $ord_g3_HanbaiKubun = $_POST{"ord_g3_HanbaiKubun"}; $ord_g5_HanbaiKubun = $_POST{"ord_g5_HanbaiKubun"}; #販売区分で単価変更 #print "\n"; if(($hanbai_kbn != $ord_g3_HanbaiKubun) || ($hanbai_kbn != $ord_g5_HanbaiKubun)){ if($hanbai_kbn == 1 || $hanbai_kbn == 11){ $ord_g3_tanka = $Mizu_info[$CstmTbl["WaterTanka3"]]["Tanka"]; //一般販売単価 $ord_g5_tanka = $Mizu_info[$CstmTbl["WaterTanka5"]]["Tanka"]; //一般販売単価 //$ord_g3_3_tanka = $Mizu_info[$CstmTbl["WaterTanka3_3rd"]]["Tanka"]; //一般販売単価(3本目以降単価) //$ord_g5_3_tanka = $Mizu_info[$CstmTbl["WaterTanka5_3rd"]]["Tanka"]; //一般販売単価(3本目以降単価) if(($kNo == '3366') || ($kNo == '990') || ($kNo == '2154') || ($kNo == '2155')){ $ord_g3_3_tanka = 950; }elseif(($kNo == '2162') || ($kNo == '2159') || ($kNo == '2160') || ($kNo == '4285') || ($kNo == '4982') || ($kNo == '5108') || ($kNo == '5618') || ($kNo == '5619') || ($kNo == '5939') || ($kNo == '6023') || ($kNo == '6024') || ($kNo == '6025') || ($kNo == '6033')){ $ord_g3_3_tanka = 850; }else{ $ord_g3_3_tanka = 1350; //一般販売単価(3本目以降単価) } //5ガロン $ord_g5_3_tanka = 1350; //一般販売単価(3本目以降単価) }elseif($hanbai_kbn == 10){ $ord_g3_tanka = $oasisu3g_Tanka; $ord_g5_tanka = $oasisu_Tanka; }elseif($hanbai_kbn == 12 || $hanbai_kbn == 13){ // メンテ用,花・事務は0円 $ord_g3_tanka = 0; $ord_g5_tanka = 0; } } print "[単価:".$ord_g5_tanka."]"; print "[3本目以降単価:".$ord_g5_3_tanka."]"; } //201911 3本目以降の単価で水代を計算 if((($WaterTanka5_3rd > 0) || ($WaterTanka3_3rd > 0)) && ($kongetu_honsu >= 2)){ //if($ord_g3) $mizudai_3g = $ord_g3 * $ord_g3_3_tanka; //if($ord_g5) $mizudai_5g = $ord_g5 * $ord_g3_5_tanka; if($ord_g3) $mizudai_3g = $ord_g3 * $ord_g3_3_tanka; if($ord_g5) $mizudai_5g = $ord_g5 * 1350; }elseif((($WaterTanka5_3rd > 0) || ($WaterTanka3_3rd > 0)) && ($kongetu_honsu == 0)){ //201911 当月最初の受注の場合 //if($ord_g3) $mizudai_3g = ((2 * $ord_g3_tanka)+(($ord_g3 - 2) * $ord_g3_3_tanka)); //if($ord_g5) $mizudai_5g = ((2 * $ord_g5_tanka)+(($ord_g5 - 2) * $ord_g5_3_tanka)); if($ord_g3) $mizudai_3g = ((2 * $ord_g3_tanka)+(($ord_g3 - 2) * $ord_g3_3_tanka)); if($ord_g5) $mizudai_5g = ((2 * $ord_g5_tanka)+(($ord_g5 - 2) * $ord_g3_3_tanka)); }else{ if($ord_g3) $mizudai_3g = $ord_g3 * $ord_g3_tanka; if($ord_g5) $mizudai_5g = $ord_g5 * $ord_g5_tanka; } $mizudai = $mizudai_3g + $mizudai_5g; $f_mizudai = number_format($mizudai); if($item1_no) $itemdai_1 = $Item_tanka[$item1_no] * $item1_kosu; if($item2_no) $itemdai_2 = $Item_tanka[$item2_no] * $item2_kosu; if($item3_no) $itemdai_3 = $Item_tanka[$item3_no] * $item3_kosu; $itemdai = $itemdai_1 + $itemdai_2 + $itemdai_3; $f_itemdai = number_format($itemdai); ##レンタル代 #$f_pay_rentaru = number_format($pay_rentaru); #メンテ代 $f_pay_mente = number_format($pay_mente); #未収代 if($misyu){ $misyu_tojiru = "false"; $cnt_misyu = count($misyu); for($i = 0 ; $i < $cnt_misyu ; $i++){ #print ""; $j = $misyu[$i]; # UriageNo|Uriagebi|Nyukingaku|Totalkingaku $misyu_data = $_POST{"misyu_data".$j}; $misyuExp = explode("|", $misyu_data); $misyuTbl[$i]["UriageNo"] = $misyuExp[0]; $misyuTbl[$i]["Uriagebi"] = $misyuExp[1]; $misyuTbl[$i]["Nyukingaku"] = $misyuExp[2]; #今回の入金金額 $misyuTbl[$i]["Totalkingaku"] = $misyuExp[3]; #売上の総額 $MisyuKingaku += $misyuTbl[$i]["Nyukingaku"]; #未収回収合計 $misyuSlt[$j] = " checked"; $misyu_tojiru = "false"; } } $f_MisyuKingaku = number_format($MisyuKingaku); $goukei = $mizudai + $itemdai + $pay_mente ; $f_goukei = number_format($goukei); #未収含まない 今回の売上合計 $genkin_goukei = $goukei + $MisyuKingaku; #未収回収を含む現金回収合計 $f_genkin_goukei = number_format($genkin_goukei); ########################################################## # ↑ 情報取得その1ここまで ↑ # ########################################################## ################################################# # データ登録 # ################################################# if(($_POST{"touroku"}==" 配達完了! ") && !$fuzai_flg){ $touroku = $_POST{"touroku"}; $keisan = $_POST{"keisan"}; #データ登録 #実績 $free_g3 = set_zero($_POST{"free_g3"}); $free_g5 = set_zero($_POST{"free_g5"}); $Kara_3G = set_zero($_POST{"Kara_3G"}); $Kara_5G = set_zero($_POST{"Kara_5G"}); $MuryoNo = set_zero($_POST{"MuryoNo"}); $HoumonNo = set_zero($_POST{"HoumonNo"}); $pay_mente = set_zero($_POST{"pay_mente"}); $Bikou = $_POST{"Bikou"}; $JisekiNo = $_POST{"JisekiNo"}; $UriageNo = $_POST{"UriageNo"}; $UriagekinKaisyuKB = $_POST{"UriagekinKaisyuKB"}; $StarMark = $_POST{"StarMark"}; $Mondai = set_zero($_POST["Mondai"]); $Rouhou = set_zero($_POST["Rouhou"]); $HenkinKingaku = 0; //返金金額初期値 $RackDaisuA =set_zero( $_POST["RackDaisuA"]); //ボトルラック設置台数 $RackKaisyuA = set_zero( $_POST["RackKaisyuA"]); //ボトルラック回収台数 #必須項目チェック $err_flg = 0; $err_cmt = ""; #返金があったら $ch = $_POST["cnt_h"]; //データ総数を取得 for($i = 0;$i < $ch;$i++){ if(!preg_match("/^(|[1-9]\d*)$/",$_POST["henkin".$i])){ //入力された返金金額がおかしい場合(未入力はOK、0はNG) $err_flg++; $err_cmt .= '

返金金額が正しく入力されていません!

'; }else if(($_POST["Henkingaku".$i] + $_POST["henkin".$i]) > $_POST["Shiharaigaku".$i]){ //返金済み金額+今回の返金金額が入金金額よりも大きい場合 $err_flg++; $err_cmt .= '

入金金額よりも大きな返金金額が入力されています!

'; }else{ $HenkinKingaku += $_POST["henkin".$i]; //返金金額の合計 } } if(!$hou_time){ $err_flg++; $err_cmt .= '

訪問時間が入力されていません!

'; } if($UriagekinKaisyuKB == ""){ //未入力の場合は「未回収」として登録 //$err_flg++; //$err_cmt .= '

現金回収or未回収をセットしてください!

'; $UriagekinKaisyuKB ="0"; } #メンテナンスがあったら $dcnt = $_POST{"dcnt"}; #設置SVR数 $svr_new = $_POST{"svr_new"}; #新規設置SVR if($MenteDspNo || $dcnt || $svr_new){ $cnt_dsp = set_zero($_POST{"cnt_dsp"}); #メンテSVR数 for($i=0; $i <= $dcnt ;$i++){ $mente_dsp[$i] = $_POST{"mente_dsp_".$i}; //回収 $setti_dsp[$i] = conv_svr($_POST{"setti_dsp_".$i}); //設置 $NippouSvrBikou[$i] = $_POST{"NippouSvrBikou_".$i}; if($mente_dsp[$i] || $setti_dsp[$i]){ if(!$NippouSvrBikou[$i]){ $err_flg++; $err_cmt .= '

メンテ理由を選択してください!

'; } if($mente_dsp[$i] == $setti_dsp[$i]){ $err_flg++; $err_cmt .= '

回収SVRと設置SVRのNoが同じです

'; } } } #重複チェック if(array_isunique($mente_dsp)){ $err_flg++; $err_cmt .= '

同じ回収SVRが指定されています

'; } if(array_isunique($setti_dsp)){ $err_flg++; $err_cmt .= '

同じ設置SVRが指定されています

'; } } #無料配達があったら if($free_g5!=0 || $free_g3!=0){ if($MuryoNo == 0){ $err_flg++; $err_cmt .= '

無料理由を選択してください!

'; } $muryo_tojiru = "false"; }else{ $muryo_tojiru = "true"; } #花立花通信の配布情報があれば #花立花通信非表示化に伴いプログラム無効化 // if(($_POST["HanaYear1"] != "")&&($_POST["HanaSeason1"] != "")){ // if($_POST["HaihuCount1"] == ""){ $HaihuCount1 = 1; } // else{ $HaihuCount1 = $_POST["HaihuCount1"]; } // //花立花通信配布履歴テーブルに追加 // $hsql = "INSERT INTO Hana_Report (TantosyaNo,HanaYear,HanaSeason,HaihuDate,HaihuCount,KokyakuNo,EdaNo) // VALUES('".$HaitatsusyaNo."','".$_POST[HanaYear1]."','".$_POST[HanaSeason1]."','".$Haitatsubi."','".$HaihuCount1."','".$kNo."','".$eNo."'); "; // $hres = sqlsrv_query($db_ms, $hsql); // // //対応履歴にも追加 // $hsql = "SELECT * FROM HanaSeasonMaster WHERE HanaSeasonNo='".$_POST[HanaSeason1]."'"; // $hres = sqlsrv_query($db_ms, $hsql); // $hrow = sqlsrv_fetch_array($hres); // $hs1 = $hrow[HanaSeasonName]; // $Naiyo1 = "花立花通信".$hs1." ".$HaihuCount1."枚配布"; // $tsql = "INSERT INTO Taiou_History (KokyakuNo,EdaNo,Hiduke,Kubun,TaiouSyubetu,Naiyo,TantosyaNo) // VALUES('".$kNo."','".$eNo."','".$Haitatsubi."','5','花立花通信配布','".$Naiyo1."','".$HaitatsusyaNo."'); "; // $tres = sqlsrv_query($db_ms, $tsql); // // } // if(($_POST["HanaYear2"] != "")&&($_POST["HanaSeason2"] != "")){ // if($_POST["HaihuCount2"] == ""){ $HaihuCount2 = 1; } // else{ $HaihuCount2 = $_POST["HaihuCount2"]; } // //花立花通信配布履歴テーブルに追加 // $hsql = "INSERT INTO Hana_Report (TantosyaNo,HanaYear,HanaSeason,HaihuDate,HaihuCount,KokyakuNo,EdaNo) // VALUES('".$HaitatsusyaNo."','".$_POST[HanaYear2]."','".$_POST[HanaSeason2]."','".$Haitatsubi."','".$HaihuCount2."','".$kNo."','".$eNo."'); "; // $hres = sqlsrv_query($db_ms, $hsql); // // //対応履歴にも追加 // $hsql = "SELECT * FROM HanaSeasonMaster WHERE HanaSeasonNo='".$_POST[HanaSeason2]."'"; // $hres = sqlsrv_query($db_ms, $hsql); // $hrow = sqlsrv_fetch_array($hres); // $hs2 = $hrow[HanaSeasonName]; // $Naiyo2 = "花立花通信".$hs2." ".$HaihuCount2."枚配布"; // $tsql = "INSERT INTO Taiou_History (KokyakuNo,EdaNo,Hiduke,Kubun,TaiouSyubetu,Naiyo,TantosyaNo) // VALUES('".$kNo."','".$eNo."','".$Haitatsubi."','5','花立花通信配布','".$Naiyo2."','".$HaitatsusyaNo."'); "; // $tres = sqlsrv_query($db_ms, $tsql); // // } // if(($_POST["HaihuCount1"] != "")&&($_POST["HanaSeason1"] == "")){ // $err_flg++; // $err_cmt .= '

花立花通信配布情報(1種類目)が正しくセットされていません

'; // } // if(($_POST["HaihuCount2"] != "")&&($_POST["HanaSeason2"] == "")){ // $err_flg++; // $err_cmt .= '

花立花通信配布情報(2種類目)が正しくセットされていません

'; // } #ボトルのスキャンがあったら if($_POST["Bottlescan"] != ""){ $Bottlescan = array(); $b_cnt = 0; $Bottlescan = explode(',',wordwrap($_POST["Bottlescan"],12,',',true)); //12桁ごとにカンマで区切ったあと、配列に格納 $b_cnt = count($Bottlescan); //本数 for($i=0;$i<$b_cnt;$i++){ //当日、出荷登録されており、顧客に納品していないボトルか? $ssql = "SELECT TOP 1 * FROM BottleKanri WHERE BottleCD='".$Bottlescan[$i]."' AND Syukkabi='".$Haitatsubi."'"; $sres = sqlsrv_query($db_ms,$ssql); while($srow = sqlsrv_fetch_array($sres)){ if($srow[KokyakuNo]!=0){ $err_flg++; $err_cmt .= '

別の顧客に本日付で納品登録を行ったボトルがスキャンされました

'; }else{ $sql = "UPDATE BottleKanri SET KokyakuNo='".$kNo."',EdaNo='".$eNo."' WHERE KanriNo='".$srow[KanriNo]."'"; $res = sqlsrv_query($db_ms,$sql); } } } } if(!$houmonsumi && !$err_flg){ if(!$JisekiNo){ #実績を登録 202001現金売上金額に水代金額をセットするよう追記(UriagekinKaisyuKB = 1の場合現金回収) $tsql = "INSERT INTO Work_Results ( Haitatsubi,JyutyuNo,GyomuNo,HaitatsusyaNo,Jikan,KokyakuNo,EdaNo,Tanka_3G,Suryo_3G,Tanka_5G,Suryo_5G, Other_Kingaku,Kara_3G,Kara_5G,MuryoNo,Free_3G,Free_5G,HoumonNo,UriagekinKaisyuKB, MenteKingaku,HenkinKingaku,MisyuKingaku,TourokuMotoFlg,Bikou,StarMark,DelDate,GenkinUriageKingaku) VALUES ('".$Haitatsubi."','".set_zero($jNo)."','".set_zero($gNo)."','".$HaitatsusyaNo."','".$hou_time."','".$kNo."','".$eNo."','".$ord_g3_tanka."','".$ord_g3."','".$ord_g5_tanka."','".$ord_g5."' ,'".set_zero($itemdai)."','".$Kara_3G."','".$Kara_5G."','".$MuryoNo."','".$free_g3."','".$free_g5."','".$HoumonNo."','".$UriagekinKaisyuKB."' ,'".$pay_mente."','".-$HenkinKingaku."','".$MisyuKingaku."','1','".$Bikou."','".$StarMark."','','".$mizudai."' ); "; #print "\n"; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } $tsql = "select SCOPE_IDENTITY( )"; $result = sqlsrv_query($db_ms, $tsql); $row = sqlsrv_fetch_array($result); $JisekiNo = $row[0]; sqlsrv_free_stmt($result); $cmp_cmt = '

登録が完了しました。次回の訪問予定を登録してください。

'; } #未収回収 if($MisyuKingaku){ for($i = 0 ; $i < $cnt_misyu ; $i++){ # 入金済フラグをたてる $tsql = "UPDATE Sales_Info SET NyukinZumiFlg = '1' WHERE UriageNo = '".$misyuTbl[$i]["UriageNo"]."' "; #print "\n"; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } # 入金管理テーブルに追加 $tsql = "INSERT INTO Money_Management ( KokyakuNo,EdaNo,UriageNo,Nyukinbi,NyukinKB,Nyukingaku,Biko) VALUES ('".$kNo."','".$eNo."','".$misyuTbl[$i]["UriageNo"]."','".$Haitatsubi."','4','".$misyuTbl[$i]["Nyukingaku"]."','' ); "; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } #print "\n"; } } #返金があった場合 if($HenkinKingaku && !$err_flg){ for($i = 0;$i < $ch;$i++){ if($_POST["henkin".$i] != ''){ //未入力でないものだけを登録 $tsql = "INSERT INTO Money_Management( KokyakuNo,EdaNo,UriageNo,Nyukinbi,NyukinKB,Nyukingaku,Biko) VALUES('".$kNo."','".$eNo."','".$_POST["UriageNo_h".$i]."','".$Haitatsubi."','5','".-$_POST["henkin".$i]."',''); "; $tresult = sqlsrv_query($db_ms,$tsql); } } } #売上登録 売り上げがあったら if(!$UriageNo && !$err_flg && $f_goukei){ $Nyukingaku = 0; $NyukinZumiFlg = 0; $Nyukinbi = ""; $NyukinSyubetsu = 0; if($UriagekinKaisyuKB){ $Nyukinbi = $Haitatsubi; $Nyukingaku = $goukei; $NyukinSyubetsu = 4; //現金 $NyukinZumiFlg = 1; //入金済み } $tsql = "INSERT INTO Sales_Info ( JyutyuNo,KokyakuNo,EdaNo,Uriagebi,MenteDspNo,QNetKey,SeikyusyoNo,NyukinZumiFlg,DelDate) VALUES ('".set_zero($jNo)."','".$kNo."','".$eNo."','".$Haitatsubi."','','','','".$NyukinZumiFlg."','' ); "; $result = sqlsrv_query($db_ms, $tsql); print "\r\n"; if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } $tsql = "select SCOPE_IDENTITY( )"; $result = sqlsrv_query($db_ms, $tsql); $row = sqlsrv_fetch_array($result); $UriageNo = $row[0]; sqlsrv_free_stmt($result); $MeisaiNo = 0; #売上明細 3G ,5G,備品、レンタル、メンテ if($ord_g3){ #3G //201911 3本目以降の場合計算 if((($WaterTanka3_3rd > 0)) && ($kongetu_honsu >= 2)){ $MeisaiNo++; $tsql = "INSERT INTO Sales_Details ( UriageNo,MeisaiNo,KokyakuNo,EdaNo,SyouhinNo,HanbaiKubun,Suryo,Tanka,Kingaku,DelDate) VALUES ('".$UriageNo."','".$MeisaiNo."','".$kNo."','".$eNo."','1','".$hanbai_kbn."','".set_zero($ord_g3)."','".$ord_g3_3_tanka."','".set_zero($mizudai_3g)."' ,''); "; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } #print "\r\n"; //201911 3本目以降の場合(今月最初の受注) }elseif((($WaterTanka3_3rd > 0)) && ($kongetu_honsu == 0)){ $ord2t = $ord_g3_tanka * 2;//2本目までの金額合計 $ord_g32 = $ord_g3-2;//3本目以降単価の本数 $t_g32 = $ord_g32 * $ord_g3_3_tanka;//3本目以降単価の本数×単価 $MeisaiNo++; $tsql = "INSERT INTO Sales_Details ( UriageNo,MeisaiNo,KokyakuNo,EdaNo,SyouhinNo,HanbaiKubun,Suryo,Tanka,Kingaku,DelDate) VALUES ('".$UriageNo."','".$MeisaiNo."','".$kNo."','".$eNo."','1','".$hanbai_kbn."','2','".$ord_g3_tanka."','".set_zero($ord2t)."' ,''); "; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } if($ord_g32 != 0){ $MeisaiNo++; $t2sql = "INSERT INTO Sales_Details ( UriageNo,MeisaiNo,KokyakuNo,EdaNo,SyouhinNo,HanbaiKubun,Suryo,Tanka,Kingaku,DelDate) VALUES ('".$UriageNo."','".$MeisaiNo."','".$kNo."','".$eNo."','1','".$hanbai_kbn."','".set_zero($ord_g32)."','".$ord_g3_3_tanka."','".set_zero($t_g32)."' ,''); "; $result2 = sqlsrv_query($db_ms, $t2sql); if(!$result2){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } } #print "\r\n"; }else{ $MeisaiNo++; $tsql = "INSERT INTO Sales_Details ( UriageNo,MeisaiNo,KokyakuNo,EdaNo,SyouhinNo,HanbaiKubun,Suryo,Tanka,Kingaku,DelDate) VALUES ('".$UriageNo."','".$MeisaiNo."','".$kNo."','".$eNo."','1','".$hanbai_kbn."','".set_zero($ord_g3)."','".set_zero($ord_g3_tanka)."','".set_zero($mizudai_3g)."' ,''); "; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } #print "\r\n"; } } if($ord_g5){ #5G //201911 3本目以降の場合計算 if((($WaterTanka5_3rd > 0)) && ($kongetu_honsu >= 2)){ $MeisaiNo++; $tsql = "INSERT INTO Sales_Details ( UriageNo,MeisaiNo,KokyakuNo,EdaNo,SyouhinNo,HanbaiKubun,Suryo,Tanka,Kingaku,DelDate) VALUES ('".$UriageNo."','".$MeisaiNo."','".$kNo."','".$eNo."','2','".$hanbai_kbn."','".set_zero($ord_g5)."','1350','".set_zero($mizudai_5g)."','' ); "; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } #print "\r\n"; //201911 3本目以降の場合(今月最初の受注) }elseif((($WaterTanka5_3rd > 0)) && ($kongetu_honsu == 0)){ $ord2f = $ord_g5_tanka * 2; $ord_g52 = $ord_g5-2;//3本目以降単価の本数 $t_g52 = $ord_g52 * 1350;//2本引いた数×3本目以降単価 $MeisaiNo++; $tsql = "INSERT INTO Sales_Details ( UriageNo,MeisaiNo,KokyakuNo,EdaNo,SyouhinNo,HanbaiKubun,Suryo,Tanka,Kingaku,DelDate) VALUES ('".$UriageNo."','".$MeisaiNo."','".$kNo."','".$eNo."','2','".$hanbai_kbn."','2','".$ord_g5_tanka."','".set_zero($ord2f)."' ,''); "; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } if($ord_g52 != 0){ $MeisaiNo++; $t2sql = "INSERT INTO Sales_Details ( UriageNo,MeisaiNo,KokyakuNo,EdaNo,SyouhinNo,HanbaiKubun,Suryo,Tanka,Kingaku,DelDate) VALUES ('".$UriageNo."','".$MeisaiNo."','".$kNo."','".$eNo."','2','".$hanbai_kbn."','".set_zero($ord_g52)."','1350','".set_zero($t_g52)."' ,''); "; $result2 = sqlsrv_query($db_ms, $t2sql); if(!$result2){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } } #print "\r\n"; }else{ $MeisaiNo++; $tsql = "INSERT INTO Sales_Details ( UriageNo,MeisaiNo,KokyakuNo,EdaNo,SyouhinNo,HanbaiKubun,Suryo,Tanka,Kingaku,DelDate) VALUES ('".$UriageNo."','".$MeisaiNo."','".$kNo."','".$eNo."','2','".$hanbai_kbn."','".set_zero($ord_g5)."','".set_zero($ord_g5_tanka)."','".set_zero($mizudai_5g)."','' ); "; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } #print "\r\n"; } } if($item1_kosu && $item1_no){ #備品1 $MeisaiNo++; $tsql = "INSERT INTO Sales_Details ( UriageNo,MeisaiNo,KokyakuNo,EdaNo,SyouhinNo,HanbaiKubun,Suryo,Tanka,Kingaku,DelDate) VALUES ('".$UriageNo."','".$MeisaiNo."','".$kNo."','".$eNo."','".$item1_no."','1','".set_zero($item1_kosu)."','".set_zero($Item_tanka[$item1_no])."','".set_zero($itemdai_1)."','' ); "; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } #print "\r\n"; } if($item2_kosu && $item2_no){ #備品2 $MeisaiNo++; $tsql = "INSERT INTO Sales_Details ( UriageNo,MeisaiNo,KokyakuNo,EdaNo,SyouhinNo,HanbaiKubun,Suryo,Tanka,Kingaku,DelDate) VALUES ('".$UriageNo."','".$MeisaiNo."','".$kNo."','".$eNo."','".$item2_no."','1','".set_zero($item2_kosu)."','".set_zero($Item_tanka[$item2_no])."','".set_zero($itemdai_2)."','' ); "; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } #print "\r\n"; } if($item3_kosu && $item3_no){ #備品3 $MeisaiNo++; $tsql = "INSERT INTO Sales_Details ( UriageNo,MeisaiNo,KokyakuNo,EdaNo,SyouhinNo,HanbaiKubun,Suryo,Tanka,Kingaku,DelDate) VALUES ('".$UriageNo."','".$MeisaiNo."','".$kNo."','".$eNo."','".$item3_no."','1','".set_zero($item3_kosu)."','".set_zero($Item_tanka[$item3_no])."','".set_zero($itemdai_3)."','' ); "; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } #print "\r\n"; } ##メンテナンス代明細・・・・支払い方法が違ったら? if($pay_mente){ $MeisaiNo++; $tsql = "INSERT INTO Sales_Details ( UriageNo,MeisaiNo,KokyakuNo,EdaNo,SyouhinNo,HanbaiKubun,Suryo,Tanka,Kingaku,DelDate) VALUES ('".$UriageNo."','".$MeisaiNo."','".$kNo."','".$eNo."','3','9','".$cnt_dsp."','".set_zero($pay_mente)."','".set_zero($pay_mente)."','' ); "; $result = sqlsrv_query($db_ms, $tsql); print "\r\n"; if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } } #業務実績に、後から売上No登録 ※実績Noで指定 $tsql = "UPDATE Work_Results SET UriageNo = '".set_zero($UriageNo)."' WHERE JisekiNo = '".$JisekiNo."' "; #print ""; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } } $Haitatudate = $Haitatsubi." ".$hou_time; #「現金回収」したら、入金管理テーブルに登録 if($UriagekinKaisyuKB){ #合計金額 水代+備品代+メンテ代+レンタル代 $tsql = "INSERT INTO Money_Management ( KokyakuNo,EdaNo,UriageNo,Nyukinbi,NyukinKB,Nyukingaku,Biko) VALUES ('".$kNo."','".$eNo."','".set_zero($UriageNo)."','".$Haitatsubi."','4','".$goukei."','' ); "; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } #print ""; } $rack_update_flg = 0; #ボトルラック設置があれば if($RackDaisuA != 0){ $ssql = "INSERT INTO RackKanri (TantosyaNo,KokyakuNo,EdaNo,RackType,RackDaisu,Settibi) VALUES('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','A','".$RackDaisuA."','".$Haitatsubi."')"; $result = sqlsrv_query($db_ms, $ssql); $rack_update_flg = 1; } #ボトルラック回収があれば if($RackKaisyuA != 0){ $ksql = "INSERT INTO RackKanri (TantosyaNo,KokyakuNo,EdaNo,RackType,RackDaisu,Kaisyubi) VALUES('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','A','".$RackKaisyuA."','".$Haitatsubi."')"; $kresult = sqlsrv_query($db_ms, $ksql); $rack_update_flg = 1; } if($rack_update_flg == 1){ #ラック設置台数を取得して顧客テーブルへ $rsql1 = "SELECT SUM(RackDaisu) FROM RackKanri WHERE RackType='A' AND KokyakuNo = '".$kNo."' AND EdaNo = '".$eNo."' AND Settibi != '' AND DelDate = ''"; $rres1 = sqlsrv_query($db_ms,$rsql1); $rrow1 = sqlsrv_fetch_array($rres1); $rsql2 = "SELECT SUM(RackDaisu) FROM RackKanri WHERE RackType='A' AND KokyakuNo = '".$kNo."' AND EdaNo = '".$eNo."' AND Kaisyubi != '' AND DelDate = ''"; $rres2 = sqlsrv_query($db_ms,$rsql2); $rrow2 = sqlsrv_fetch_array($rres2); $SettiDaisuA = set_zero($rrow1[0]) - set_zero($rrow2[0]); $sql = "UPDATE Customer SET RackDaisu = '".$SettiDaisuA."' WHERE KokyakuNo = '".$kNo."' AND EdaNo = '".$eNo."'"; $res = sqlsrv_query($db_ms,$sql); } #メンテナンスがあったら $dcnt = $_POST{"dcnt"}; #設置SVR数 $svr_new = $_POST{"svr_new"}; #設置SVR数 if($MenteDspNo || $dcnt || $svr_new){ $cnt_dsp = set_zero($_POST{"cnt_dsp"}); for($i=0; $i <= $dcnt ;$i++){ $mente_dsp[$i] = $_POST{"mente_dsp_".$i}; //回収 $setti_dsp[$i] = conv_svr($_POST{"setti_dsp_".$i}); //設置 $NippouSvrBikou[$i] = $_POST{"NippouSvrBikou_".$i}; $SvrMenteBikou[$i] = $_POST{"SvrMenteBikou_".$i}; foreach( $_POST["SvrState_".$i] as $value ){ $SvrStateKB[$i] .= $value.","; } $SvrStateKB[$i] = substr($SvrStateKB[$i], 0, -1); //最後のカンマを削除 $sql_SettiSvrNo = ""; $sql_HaitatusyaNo = "0"; $sql_NipouHiduke = ""; $sql_NippouSvrBikou = ""; $InfoNo = ""; $RentaruKaisibi = ""; if($mente_dsp[$i] || $setti_dsp[$i] || $NippouSvrBikou[$i]){ /* ・回収処理  回収されたSVRNoに該当するSVRマスターの  顧客No、枝No、設置日をクリアし「回収日」項目に日付のセット */ if($mente_dsp[$i]){ #回収あり ##最新のInfoNoのみ変更する 2012/9/17 $tsql = "SELECT * from DSP_Setting_Info WHERE DspNo = '".$mente_dsp[$i]."' AND KokyakuNo = '".$kNo."' AND DelDate = '' ORDER BY InfoNo DESC"; $result = sqlsrv_query($db_ms, $tsql); $row = sqlsrv_fetch_array($result); $InfoNo = $row['InfoNo']; $SvrKubun = $row['SvrKubun']; $MenteRate = $row['MenteRate']; $RentaruKaisibi = $row['RentaruKaisibi']; sqlsrv_free_stmt($result); if($InfoNo){ //サーバ状態更新を追記 $tsql = "UPDATE DSP_Setting_Info SET NipouHiduke = '".$Haitatsubi."', Kaisyubi = '".$Haitatsubi."', SvrStateKB = '".$SvrStateKB[$i]."', NippouSvrBikou = '".$NippouSvrBikou[$i]."', SettiSvrNo = '".$setti_dsp[$i]."', HaitatusyaNo = '".$HaitatsusyaNo."' WHERE InfoNo = '".$InfoNo."'"; #print "\n"; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } } /* 2015/10/06 メンテ理由が「[L]お試しキャンセル」の場合、 Customerテーブルの「OtamesiKyanserubi」項目に 当日の日付(YYYY/MM/DD)を登録 */ if($NippouSvrBikou[$i] == "L"){ $canselday = date("Y/m/d"); $nsql = "UPDATE Customer SET OtamesiKyanserubi = '".$canselday."' WHERE KokyakuNo = '".$kNo."' AND EdaNo = '".$eNo."'"; $result = sqlsrv_query($db_ms, $nsql); #print "\n"; sqlsrv_free_stmt($result); } ##SVRマスタ変更 $tsql = "UPDATE M_Dsp SET KokyakuNo = '', EdaNo = '', Settibi = '', KojyoMentebi = '', Kaisyubi = '".$Haitatsubi."' WHERE DspNo = '".$mente_dsp[$i]."' AND Haikibi = '' AND DelDate = '' "; #print "\n"; $result = sqlsrv_query($db_ms, $tsql); }else{ #回収なしの場合、SVR区分、メンテナンス代は空、レンタル開始日は設置日 $SvrKubun = ""; $MenteRate = ""; $RentaruKaisibi = $Haitatsubi; #理由が「新規設置(D)」または「一時貸出(H)」の場合、備考に注釈 if(($NippouSvrBikou[$i] == "D") || ($NippouSvrBikou[$i] == "H")){ $SVR_Bikou = "SVR情報を登録すること!!"; $tsql = "UPDATE Work_Results SET Bikou = '".$Bikou.$SVR_Bikou."' WHERE JisekiNo = '".$JisekiNo."'"; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } #print "\n"; $sql_HaitatusyaNo = $HaitatsusyaNo; $sql_SettiSvrNo = $setti_dsp[$i]; $sql_NipouHiduke = $Haitatsubi; $sql_NippouSvrBikou = $NippouSvrBikou[$i]; } } if($setti_dsp[$i]){ /* ・SVR設置処理  設置されたSVRNoに該当するSVRマスターの  顧客No、枝No、設置日にデータをセットし  工場メンテ日、回収日をクリア  区分を「中古」とする */ if($Haitatsubi == "")$Haitatsubi = date("Y/m/d"); //20170418追加 #SVR設置情報登録 // $sql_HaitatusyaNo = $HaitatsusyaNo; // $sql_SettiSvrNo = $setti_dsp[$i]; // $sql_NipouHiduke = $Haitatsubi; // $sql_NippouSvrBikou = $NippouSvrBikou[$i]; // #202004設置サーバに対しては状態追記しない // $tsql = "INSERT INTO DSP_Setting_Info ( // KokyakuNo,EdaNo,DspNo,SvrKubun,MenteRate,Sechibi,Mentebi,Kaisyubi,RentaruKaisibi // ,Bikou,SvrStateKB,NipouHiduke,HaitatusyaNo,SettiSvrNo,NippouSvrBikou,DelDate) // VALUES ('".$kNo."','".$eNo."','".$setti_dsp[$i]."','".$SvrKubun."','".$MenteRate."','".$Haitatsubi."','','','".$RentaruKaisibi."' // ,'".$SvrMenteBikou[$i]."','".$SvrStateKB[$i]."','".$sql_NipouHiduke."','".$HaitatsusyaNo."','".$sql_SettiSvrNo."','".$sql_NippouSvrBikou."','' ); "; $tsql = "INSERT INTO DSP_Setting_Info ( KokyakuNo,EdaNo,DspNo,SvrKubun,MenteRate,Sechibi,Mentebi,Kaisyubi,RentaruKaisibi ,Bikou,SvrStateKB,NipouHiduke,HaitatusyaNo,SettiSvrNo,NippouSvrBikou,DelDate) VALUES ('".$kNo."','".$eNo."','".$setti_dsp[$i]."','".$SvrKubun."','".$MenteRate."','".$Haitatsubi."','','','".$RentaruKaisibi."' ,'".$SvrMenteBikou[$i]."','','".$sql_NipouHiduke."','".$HaitatsusyaNo."','".$sql_SettiSvrNo."','".$sql_NippouSvrBikou."','' ); "; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } #print "\n"; sqlsrv_free_stmt($result); /* 2015/12/28 メンテ理由が[D]新規設置かつ顧客区分が「契約(3)」以外でかつ お試し登録日(OtamesiTourokubi)が未入力の場合 当日の日付をセット */ $sql = "SELECT * FROM Customer WHERE KokyakuNo = '".$kNo."' AND EdaNo = '".$eNo."'"; $result = sqlsrv_query($db_ms, $sql); $row = sqlsrv_fetch_array($result); if(($NippouSvrBikou[$i] == "D")&&($row[Kubun] != "3")){ if($row[OtamesiTourokubi] == ""){ $OtamesiTourokubi = date("Y/m/d"); $nsql = "UPDATE Customer SET OtamesiTourokubi = '".$OtamesiTourokubi."' WHERE KokyakuNo = '".$kNo."' AND EdaNo = '".$eNo."'"; $result = sqlsrv_query($db_ms, $nsql); #print "\n"; sqlsrv_free_stmt($result); } } ##SVRマスター変更 $tsql = "UPDATE M_Dsp SET KokyakuNo = '".$kNo."', EdaNo = '".$eNo."', Settibi = '".$Haitatsubi."', KojyoMentebi = '', Kubun = '1', Kaisyubi = '' WHERE DspNo = '".$setti_dsp[$i]."' AND Haikibi = '' AND DelDate = '' "; #print "\n"; $result = sqlsrv_query($db_ms, $tsql); } } } } #契約処理 if($_POST[Keiyakushori]==1){ $tsql = "UPDATE Customer SET Keiyakubi='".$Haitatsubi."',Kubun='3' WHERE KokyakuNo='".$kNo."' AND EdaNo='".$eNo."'"; $result = sqlsrv_query($db_ms, $tsql); $cmp_cmt .= "

・契約処理を行いました

"; } #解約処理 if($_POST[Kaiyakushori]==1){ $tsql = "UPDATE Customer SET Kaiyakubi='".$Haitatsubi."',KaiyakuRiyuu='".$_POST[KaiyakuRiyuu]."',KaiyakuKanri='解約' WHERE KokyakuNo='".$kNo."' AND EdaNo='".$eNo."'"; $result = sqlsrv_query($db_ms, $tsql); $cmp_cmt .= "

・解約処理を行いました

"; } #受注データ更新 if($jNo){ if($hou_time){ #0:未配達 1:配達済み $HaitasuJyokyo = 1; }else{ $HaitasuJyokyo = 0; } #配達状況の更新 $tsql = "UPDATE Order_Info SET Haitatsubi = '".$Haitatsubi."', Haitatudate = '".$Haitatudate."', HaitasuJyokyo = '".$HaitasuJyokyo."' WHERE JyutyuNo = '".$jNo."' "; #print ""; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } } #対応計画があれば if($Mondai == '1'){ $tsql = "INSERT INTO Taiou_History (KokyakuNo,EdaNo,Hiduke,Kubun,TaiouSyubetu,TantosyaNo,Naiyo) VALUES ('".set_zero($kNo)."','".set_zero($eNo)."','".$Haitatsubi."','7','その他','".$HaitatsusyaNo."','要対応')"; $result = sqlsrv_query($db_ms, $tsql); #print ""; } if($Rouhou == '1'){ $tsql = "INSERT INTO Taiou_History (KokyakuNo,EdaNo,Hiduke,Kubun,TaiouSyubetu,TantosyaNo,Naiyo) VALUES ('".set_zero($kNo)."','".set_zero($eNo)."','".$Haitatsubi."','7','その他','".$HaitatsusyaNo."','朗報あり')"; $result = sqlsrv_query($db_ms, $tsql); #print ""; } #行って来い情報更新 if($gNo){ $Houmondate = $Haitatsubi." ".$hou_time; $tsql = "UPDATE Work_Instructions SET Houmondate = '".$Houmondate."' WHERE GyomuNo = '".$gNo."' "; #print ""; $result = sqlsrv_query($db_ms, $tsql); if(!$result){ $ErrorTime = date("Y/m/d H:i:s"); $txt = htmlspecialchars($tsql,ENT_QUOTES); $esql = "INSERT INTO ErrorLog (HaitatsusyaNo,KokyakuNo,EdaNo,ErrorTime,ErrorTxt) VALUES ('".set_zero($HaitatsusyaNo)."','".set_zero($kNo)."','".set_zero($eNo)."','".$ErrorTime."','".$txt."'); "; $eresult = sqlsrv_query($db_ms, $esql); } } } } ################################################# # ↑ データ登録ここまで ↑ # ################################################# ### 返金チェック ### $pre_date = date('Y/m/d',(strtotime("-6 month"))); //6か月前のデータまで取得する。 $i = 0; $j = 0; $cnt_c = 0; //入金・返金金額データ数カウント用 $cnt_u = 0; //売上データ数カウント用 //入金・返金金額チェック $csql = "SELECT DISTINCT Sales_Info.UriageNo, Money_Management.NyukinKB, Money_Management.Nyukingaku FROM Sales_Info LEFT OUTER JOIN Sales_Details ON Sales_Info.UriageNo = Sales_Details.UriageNo LEFT OUTER JOIN Money_Management ON Sales_Info.UriageNo = Money_Management.UriageNo WHERE Sales_Info.KokyakuNo = '".$kNo."' AND Sales_Info.EdaNo = '".$eNo."' AND Sales_Info.Uriagebi >= '".$pre_date."' AND Money_Management.Nyukingaku IS NOT NULL ORDER BY Sales_Info.UriageNo, Money_Management.NyukinKB DESC"; $cres = sqlsrv_query($db_ms,$csql); while($crow = sqlsrv_fetch_array($cres)){ $UriageNo_ch[$i] = $crow["UriageNo"]; $NyukinKB[$i] = $crow["NyukinKB"]; $Nyukingaku[$i] = $crow["Nyukingaku"]; $i++; } $cnt_c = $i; //入金・返金金額データ数 //売上チェック $usql = "SELECT DISTINCT Sales_Info.UriageNo,Sales_Info.Uriagebi,SUM(Sales_Details.Kingaku)AS Kingaku FROM Sales_Info LEFT OUTER JOIN Sales_Details ON Sales_Info.UriageNo = Sales_Details.UriageNo WHERE Sales_Info.KokyakuNo = '".$kNo."' AND Sales_Info.EdaNo = '".$eNo."' AND Sales_Info.Uriagebi >= '".$pre_date."' GROUP BY Sales_Info.UriageNo, Sales_Info.Uriagebi ORDER BY Sales_Info.Uriagebi DESC"; $ures = sqlsrv_query($db_ms,$usql); while($urow = sqlsrv_fetch_array($ures)){ $UriageNo_uri[$j] = $urow["UriageNo"]; $Uriagebi[$j] = $urow["Uriagebi"]; $Kingaku[$j] = $urow["Kingaku"]; $j++; } $cnt_u = $j; //売上データ数 ### 返金チェックここまで ### ######################################## # 情報取得その2 # ######################################## #住所情報 $jyuusyo = $CstmTbl['City'].$CstmTbl['Ku']."
".$CstmTbl['Machi'].$CstmTbl['Banchi']."
".$CstmTbl['Bill']; $jyuusyo_u = $CstmTbl['City'].$CstmTbl['Ku'].$CstmTbl['Machi'].$CstmTbl['Banchi']; $url_jyuusyo = urlencode($jyuusyo_u); $eda = ""; if($eNo != ""){ $eda = " AND EdaNo= '".$eNo."'"; } # SVR情報 $tsql = "SELECT * from DSP_Setting_Info WHERE KokyakuNo = '".$kNo."' ".$eda." AND DelDate = '' ORDER BY InfoNo"; $result = sqlsrv_query($db_ms, $tsql); $i = 0; $dcnt = 0; $HowSVR_BIKOU = ""; while($row = sqlsrv_fetch_array($result)) { if(!$row['Kaisyubi']){ #現在設置しているSVRのみ取り出し $SvrKubun = $row['SvrKubun']; $MenteRate = $row['MenteRate']; $Svr_Bikou = $row['Bikou']; $SvrMenteBikou[$i] = $row['Bikou']; $DspTbl[$i]["DspNo"] = $row['DspNo']; $DspTbl[$i]["Sechibi"] = $row['Sechibi']; $DspTbl[$i]["Mentebi"] = $row['Mentebi']; $DspTbl[$i]["Kaisyubi"] = $row['Kaisyubi']; $DspTbl[$i]["SvrStateKB"] = $row['SvrStateKB']; #print "\r\n"; #契約情報 if($dcnt){ $ten = ",";} $HowSVR .= $ten.$HowDsp[$SvrKubun]; $HowSVR_PAY = $Arr_MenteRate[$MenteRate]; if($Svr_Bikou){ //$HowSVR_BIKOU .= "
[".$DspTbl[$i]["DspNo"]."]:".$Svr_Bikou; //レンタル区分を追記 $HowSVR_BIKOU .= "
[".$DspTbl[$i]["DspNo"]."]:".$ten.$HowDsp[$SvrKubun]." ".$Svr_Bikou; if($DspTbl[$i]["SvrStateKB"])$HowSVR_BIKOU .= ' '.$DspTbl[$i]["SvrStateKB"]; } $dcnt++; $i++; } } sqlsrv_free_stmt($result); #設置可能SVR情報 $tsql = "SELECT * from M_Dsp WHERE KojyoMentebi != '' AND DelDate = '' AND Haikibi = '' ORDER BY DspCD"; $result = sqlsrv_query($db_ms, $tsql); $setcnt = 0; while($row = sqlsrv_fetch_array($result)) { if(!$row['KokyakuNo']){ $setSVRtbl[$setcnt]["DspCD"] = $row['DspCD']; $setSVRtbl[$setcnt]["DspNo"] = $row['DspNo']; $setcnt++; } } $chkG[$UriagekinKaisyuKB] = 'checked="checked"'; if($StarMark){ $chkS = 'checked="checked"';} #対応計画の情報があるか $sql = "SELECT * FROM Taiou_History WHERE KokyakuNo = '".$kNo."' ".$eda." AND Hiduke = '".$Haitatsubi."' AND Kubun='7'"; $res = sqlsrv_query($db_ms, $sql); $chkM = ""; $chkR = ""; while($row = sqlsrv_fetch_array($res)){ if($row[Naiyo] == "要対応")$chkM = 'checked="checked"'; if($row[Naiyo] == "朗報あり")$chkR = 'checked="checked"'; } #サーバ状態 $tsql = "SELECT * from M_SvrState ORDER BY SvrStateKB"; $result = sqlsrv_query($db_ms, $tsql); $statecnt = 0; while($row = sqlsrv_fetch_array($result)) { $setSVRstate[$statecnt]["SvrStateKB"] = $row['SvrStateKB']; $setSVRstate[$statecnt]["SvrStateName"] = $row['SvrStateName']; $statecnt++; } #客先本数の取得 $khsql = "SELECT ISNULL(SUM(Suryo_3G), 0) AS Suryo_3G, ISNULL(SUM(Suryo_5G), 0) AS Suryo_5G, ISNULL(SUM(Free_3G), 0) AS Free_3G, ISNULL(SUM(Free_5G), 0) AS Free_5G, ISNULL(SUM(Kara_3G), 0) AS Kara_3G, ISNULL(SUM(Kara_5G), 0) AS Kara_5G FROM Work_Results WHERE (DelDate = '') AND (KokyakuNo = '".$kNo."') AND (EdaNo = '". $eNo ."')"; $khres = sqlsrv_query($db_ms,$khsql); $khrow = sqlsrv_fetch_array($khres); $kyakusaki_honsuu = $khrow[Suryo_3G] + $khrow[Suryo_5G] + $khrow[Free_3G] + $khrow[Free_5G] - $khrow[Kara_3G] - $khrow[Kara_5G]; #ラック設置台数の取得 $rsql1 = "SELECT SUM(RackDaisu) FROM RackKanri WHERE RackType='A' AND KokyakuNo = '".$kNo."' AND EdaNo = '".$eNo."' AND Settibi != '' AND DelDate = ''"; $rres1 = sqlsrv_query($db_ms,$rsql1); $rrow1 = sqlsrv_fetch_array($rres1); $rsql2 = "SELECT SUM(RackDaisu) FROM RackKanri WHERE RackType='A' AND KokyakuNo = '".$kNo."' AND EdaNo = '".$eNo."' AND Kaisyubi != '' AND DelDate = ''"; $rres2 = sqlsrv_query($db_ms,$rsql2); $rrow2 = sqlsrv_fetch_array($rres2); $SettiDaisuA = set_zero($rrow1[0]) - set_zero($rrow2[0]); ######################################## # ↑ 情報取得その2ここまで ↑ # ######################################## print <<
戻るホーム

 

{$err_cmt} {$cmp_cmt}
  • No.{$kNo} {$CstmTbl['KokyakuName']}様
  • {$jyuusyo}
  • 地図を見る
  • 【SVR情報】{$HowSVR_BIKOU}
  • 【SVRメンテ代】{$HowSVR_PAY}円
  • 【付属品】{$CstmTbl["SvrOptionInfo"]}
  • 【支払方法(SVR)】{$HowPay[$CstmTbl['PaymentDsp']]}
  • 【支払方法(水等)】{$HowPay[$CstmTbl['PaymentWater']]}
  • EOM; if(($PaymentDsp == 2) || ($PaymentWater == 2)){ // SVRか水の支払方法がQネットの人のみ表示 print "
  • 【Qネット引落不能回数】".$HikiotosiFukaCnt."回
  • "; } //201906MEMO情報追記 print "
  • 【MEMO】".$Memo."
  • "; print "
"; #注意事項がある場合、表示 if($TyuiJikou){ print <<

【注意事項あり!】

{$TyuiJikou}

EOM; } #情報がある場合、表示 #情報は非表示 if($Information){ print <<

【情報】

{$Information}

--> EOM; } #時間指定等がある場合、表示 if($Jikansitei || $Order_Bikou || $Renraku){ if($Jikansitei){ $c1 = "※時間指定:".$Jikansitei."
"; } if($Order_Bikou){ $c2 = "※備考:".$Order_Bikou."
"; } if($Renraku){ $c3 = "※連絡事項※
".$Renraku."
"; } print <<

【時間指定等】

{$c1}{$c2}{$c3}

EOM; } #201910追加ToDoがある場合、表示 if($ToDo){ print <<

【ToDo】

{$ToDo}

EOM; } print <<訪問時刻

契約・解約処理

現在の区分: EOM; if($CstmTbl[Kubun]=='1')echo "見込み客
"; if($CstmTbl[Kubun]=='2')echo "お試しユーザ
"; if($CstmTbl[Kubun]=='3')echo "契約(会員)
"; if($CstmTbl[Kubun]=='4')echo "お問合せ
"; if($CstmTbl[Kubun]=='5')echo "担当者情報
"; if($CstmTbl[Kubun]=='6')echo "その他
"; if($CstmTbl[Kubun]=='7')echo "未開拓先
"; //区分が「契約」ではない人は「契約」にできるようにする if($HaitasuJyokyo!=1 && $CstmTbl[Kubun]!='3'){ print<< EOM; } //区分が「契約」の人は「解約」ができるようにする if($HaitasuJyokyo!=1 && $CstmTbl[Kubun]=='3'){ print<< 解約理由: EOM; } print<<

注文情報
EOM; if($CstmTbl["WaterTanka3"]){ #3Gの累計本数 $tsql3 = "SELECT SUM(Suryo) as sum3 from Order_Details WHERE JyutyuNo = '".$jNo."' AND SyouhinNo = '1'"; $result3 = sqlsrv_query($db_ms, $tsql3); $row = sqlsrv_fetch_array($result3); $sum3 = $row['sum3']; sqlsrv_free_stmt($result3); //print $sum3."あばばば"; #5Gの累計本数 $tsql5 = "SELECT SUM(Suryo) as sum5 from Order_Details WHERE JyutyuNo = '".$jNo."' AND SyouhinNo = '2'"; $result5 = sqlsrv_query($db_ms, $tsql5); $row = sqlsrv_fetch_array($result5); $sum5 = $row['sum5']; sqlsrv_free_stmt($result5); //print $sum5."あばばば"; print <<
EOM; } if($CstmTbl["WaterTanka5"]){ print <<
EOM; } $slt_kbn[$hanbai_kbn] = " selected"; print <<
EOM; if(!$houmonsumi){ print << EOM; } #####代金 print <<
  • 料金明細
  • 水代{$f_mizudai}円
  • 付属品代{$f_itemdai}円
  • EOM; if($MenteDspNo){ print <<メンテ代{$f_pay_mente}円 EOM; } print <<売上合計{$f_goukei}円 EOM; print <<

    入金: (現金回収の場合のみ選択してください)
    EOM; if($cnt_Misyu){ #未収回収 print <<

    未収回収

    EOM; if(!$houmonsumi){ for($i = 0 ; $i < $cnt_Sls ; $i++){ $sumi = ""; $color = ""; $ichibu = ""; if($SlsTbl[$i]["Nyukingaku"] != $SlsTbl[$i]["Totalkingaku"]){ $color = "red"; $ikura = $SlsTbl[$i]["Totalkingaku"] - $SlsTbl[$i]["Nyukingaku"]; if($SlsTbl[$i]["Nyukingaku"]){ ##一部入金 $ichibu = "(".number_format($SlsTbl[$i]["Nyukingaku"])."円)"; } $kingaku = ''.number_format($ikura).'円'; print <<{$SlsTbl[$i]["Uriagebi"]} {$kingaku} {$SlsTbl[$i]["re_flg"]} EOM; } } } print << EOM; #訪問済の場合は未収金額を表示 if($MisyuKingaku){ print <<
  • 未収回収合計{$f_MisyuKingaku}円
EOM; } print << EOM; } print<<

ボトル納品登録

EOM; if(!$houmonsumi){ print<<
※↑の入力欄をタップしてスキャン
※本日付で出荷登録済のボトルしか登録できません EOM; }else{ if(count($scan_bottle)>0){ echo "【納品登録ボトル】
"; for($i=0;$i<=count($scan_bottle);$i++){ echo $scan_bottle[$i]."
"; } }else{ echo "納品登録なし"; } } print<<
EOM; #付属品の注文がひとつでもある場合(コンテンツを開いた状態に) if($item1_no != ""){ print << EOM; #注文がない場合はコンテンツを閉じておく }else{ print << EOM; } print <<付属品
EOM; $Suryo = $item1_kosu; for($i=0 ; $i <=50 ; $i++){ $slt = ""; if($Suryo == $i){ $slt = " selected"; } print ' '."\n"; } print <<
EOM; print <<
EOM; $Suryo = $item2_kosu; for($i=0 ; $i <=50 ; $i++){ $slt = ""; if($Suryo == $i){ $slt = " selected"; } print ' '."\n"; } print <<
EOM; $Suryo = $item3_kosu; for($i=0 ; $i <=50 ; $i++){ $slt = ""; if($Suryo == $i){ $slt = " selected"; } print ' '."\n"; } print <<
EOM; print <<
EOM; ### 返金 ### //返金は表示しない if($cnt_c != 0){ //入金がない場合は表示しない print <<