Can not negosiation a temporary card."; echo json_encode( $result ); fflush(); exit(); } $sql="INSERT INTO shodan(kaisai_no,spno,posno,uketsuke_time,shodan_price,shodan_result)VALUES([KAISAI_NO],'[SPNO]','[POSNO]',to_timestamp('[UKETSUKE_TIME]','YYYYMMDDHH24MISS'),[SHODAN_PRICE],'[SHODAN_RESULT]')"; $sql="SELECT count(*) FROM shodan WHERE kaisai_no=[KAISAI_NO] AND posno='[POSNO]' AND spno='[SPNO]' AND shodan_result='[SHODAN_RESULT]'"; $sql=str_replace("[KAISAI_NO]",$kai,$sql); $sql=str_replace("[SPNO]",$syupno,$sql); $sql=str_replace("[POSNO]",$posno,$sql); $sql=str_replace("[SHODAN_RESULT]","00",$sql); $r = pg_query( $dbconn, $sql ); if( $r ){ $num = pg_num_rows( $r ); if( $num == 0 ){ $result["ret"] = "92"; $result["msg"] = "商談検索結果の取得に失敗しました。"; }else{ $l = pg_fetch_array( $r ); if($l[0]==0){ $result["ret"]="00"; $result["msg"] = "商談未登録"; }else{ $result["ret"]="01"; $result["msg"] = "商談既に登録"; } } }else{ $result["ret"] = "92"; $result["msg"] = "商談の検索に失敗しました。"; } log_write($result["ret"].":".$result["msg"]); echo json_encode( $result ); function log_write($msg) { error_log(date("Y/m/d H:i:s")." : ".$msg."\n" , 3, '/home/mli/www/app.log'); } ?>