function db_entry($gc) { $gc->db->begin_tran(); //新規追加処理 $sql = "INSERT INTO t_item ("; $sql.= " anken_no,"; $sql.= " relocation_flg,"; $sql.= " chintai_flg,"; $sql.= " sublease_flg,"; $sql.= " purpose_flg,"; $sql.= " buken_sbt,"; $sql.= " buken_shikucyouson_no,"; $sql.= " buken_banchi,"; $sql.= " buken_tatemono,"; $sql.= " chikunensu,"; $sql.= " menseki,"; $sql.= " input_val,"; $sql.= " input_kbn,"; $sql.= " land_val,"; $sql.= " madori_no,"; $sql.= " meigi_no,"; $sql.= " genjyou_no,"; $sql.= " room_cnt,"; $sql.= " fudousan_flg,"; $sql.= " fudousan_nm,"; $sql.= " bikou,"; $sql.= " lname,"; $sql.= " fname,"; $sql.= " lname_kn,"; $sql.= " fname_kn,"; $sql.= " tel,"; $sql.= " e_mail,"; $sql.= " sumai_flg,"; $sql.= " sumai_shikucyouson_no,"; $sql.= " sumai_banchi,"; $sql.= " sumai_tatemono,"; $sql.= " moushikomibi,"; $sql.= " rank_no,"; $sql.= " tesuryou,"; $sql.= " mukou_flg,"; $sql.= " ltime"; $sql.= ") VALUES ("; $sql.= "'未確定',"; $sql.= f_bool_edit_db($_POST["relocation_flg"], "0").","; $sql.= f_bool_edit_db($_POST["chintai_flg"], "0").","; $sql.= f_bool_edit_db($_POST["sublease_flg"], "0").","; $sql.= f_num_edit_db($_POST["purpose_flg"], "0").","; $sql.= f_num_edit_db($_POST["buken_sbt"], "0").","; $sql.= f_num_edit_db($_POST["shikucyouson_no"]).","; $sql.= "'".f_dbs($_POST["buken"].$_POST["banchi"])."',"; $sql.= "'".f_dbs($_POST["buken_tatemono"].$_POST["buken_heya"])."',"; $sql.= f_num_edit_db($_POST["chikunensu"], "0.00").","; $sql.= f_num_edit_db($gc->menseki, "0.00").","; $sql.= "'".f_dbs($_POST["input_val"])."',"; $sql.= f_num_edit_db($_POST["input_kbn"], "0").","; $sql.= f_num_edit_db($_POST["land_val"], "0").","; $sql.= f_num_edit_db($_POST["madori_no"], "0").","; $sql.= f_num_edit_db($_POST["meigi_no"], "0").","; $sql.= f_num_edit_db($_POST["genjyou_no"], "0").","; $sql.= f_num_edit_db($_POST["room_cnt"], "0").","; $sql.= f_bool_edit_db($_POST["fudousan_flg"], "0").","; $sql.= "'".f_dbs($_POST["fudousan_nm"])."',"; $sql.= "'".f_dbs($_POST["bikou"])."',"; $sql.= "'".f_dbs($_POST["lname"])."',"; $sql.= "'".f_dbs($_POST["fname"])."',"; $sql.= "'".f_dbs($_POST["lname_kn"])."',"; $sql.= "'".f_dbs($_POST["fname_kn"])."',"; $sql.= "'".f_dbs($_POST["tel1"]."-".$_POST["tel2"]."-".$_POST["tel3"])."',"; $sql.= "'".f_dbs($_POST["e_mail"])."',"; $sql.= f_num_edit_db($_POST["sumai_flg"], "0").","; $sql.= f_num_edit_db($_POST["sumai_shikucyouson_no"]).","; $sql.= "'".f_dbs($_POST["sumai_banchi"])."',"; $sql.= "'".f_dbs($_POST["sumai_tatemono"])."',"; $sql.= "CURRENT_TIMESTAMP,"; $sql.= f_num_edit_db($gc->rank, "0").","; $sql.= f_num_edit_db($gc->tesuryou, "0").","; $sql.= "0,"; $sql.= "CURRENT_TIMESTAMP)"; $ret = $gc->db->execute($sql, true); if($ret["errno"] > 0){ $gc->db->rollback(); $gc->msg->add("大変申し訳ございません申し込みができませんでした。"); return false; } $gc->item_no = $gc->db->get_last_id(); $buken_sbt = f_num_edit_db($_POST["buken_sbt"], "0"); $wk_anken_no = get_anken_no($gc, $buken_sbt, $gc->item_no); $sql = "UPDATE t_item SET"; $sql.= " anken_no = '".$wk_anken_no."' "; $sql.= "WHERE"; $sql.= " item_no = ".$gc->item_no; $ret = $gc->db->execute($sql, true); if($ret["errno"] > 0){ $gc->db->rollback(); $gc->msg->add("大変申し訳ございません申し込みができませんでした。"); return false; } $cpn_data = get_company_data($gc,$_POST["shikucyouson_no"]); for ($i = 0; $i < count($gc->arr_company); $i++) { $company_no = $gc->arr_company[$i]; if(!is_numeric($company_no)){ $company_no = 0; } $arr_company_kbn = $_POST["arr_company_kbn"]; if($arr_company_kbn[$company_no] == "relocation"){ $kubun_nm = "リロケーション"; }elseif($arr_company_kbn[$company_no] == "chintai"){ $kubun_nm = "賃貸募集・賃貸管理"; }elseif($arr_company_kbn[$company_no] == "sublease"){ $kubun_nm = "サブリース"; } $sql = "INSERT INTO t_item_company ("; $sql.= " item_no,"; $sql.= " company_no,"; $sql.= " kubun_nm"; $sql.= ") VALUES ("; $sql.= $gc->item_no.","; $sql.= $company_no.","; $sql.= "'".f_dbs($kubun_nm)."')"; $ret = $gc->db->execute($sql, true); if($ret["errno"] > 0){ $gc->db->rollback(); $gc->msg->add("大変申し訳ございません申し込みができませんでした。"); return false; } if(($_POST["purpose_flg"] == 1) && ($cpn_data[$company_no]["light_flg"] > 0) && ($cpn_data[$company_no]["plan_flg"] == 1 || $cpn_data[$company_no]["plan_flg"] == 3)){ $cpn_data[$company_no]["light_flg"] = $cpn_data[$company_no]["light_flg"]; }else{ $cpn_data[$company_no]["light_flg"] = 0; } $ret = set_tesuryo_table($gc,$gc->item_no,$company_no,$cpn_data[$company_no]["light_flg"],$cpn_data[$company_no]["kotei_flg"],$cpn_data[$company_no]["shikucyouson_kingaku"],"CURRENT_TIMESTAMP",f_num_edit_db($gc->rank, "0")); if($ret["errno"] > 0){ $gc->db->rollback(); $gc->msg->add("大変申し訳ございません申し込みができませんでした。"); return false; } } $gc->db->commit(); send_mail($gc); return true; }
function db_entry($posted) { require_once(dirname(__FILE__)."/../../../init.inc.php"); require_once(C_LIB_PATH.'lib.php'); require_once(C_LIB_PATH.'lib_db.php'); require_once(C_LIB_PATH.'class_db.php'); require_once(C_LIB_PATH.'lib_mail.php'); require_once(C_LIB_PATH.'lib_img.php'); require_once(C_LIB_PATH.'lib_div.php'); require_once(C_LIB_PATH.'lib_sel_area.php'); require_once(C_LIB_PATH.'lib_tesuryo.php'); require_once(C_INC_DIR_SSL."db_utils.php"); $db = connect_db(); $db->beginTransaction(); //新規追加処理 $sql = "INSERT INTO t_item ("; $sql.= " anken_no,"; $sql.= " relocation_flg,"; $sql.= " chintai_flg,"; $sql.= " sublease_flg,"; $sql.= " purpose_flg,"; $sql.= " buken_sbt,"; $sql.= " buken_shikucyouson_no,"; $sql.= " buken_shozai,"; $sql.= " sonota_jusho,"; $sql.= " buken_tatemono,"; $sql.= " chikunensu,"; $sql.= " menseki,"; $sql.= " input_val,"; $sql.= " input_kbn,"; $sql.= " land_val,"; $sql.= " madori_no,"; $sql.= " meigi_no,"; $sql.= " genjyou_no,"; $sql.= " room_cnt,"; $sql.= " fudousan_flg,"; $sql.= " fudousan_nm,"; $sql.= " bikou,"; $sql.= " fullname,"; $sql.= " fullname_kn,"; $sql.= " tel,"; $sql.= " e_mail,"; $sql.= " sumai_flg,"; $sql.= " sumai_yubin,"; $sql.= " sumai_jusho,"; $sql.= " sumai_tatemono,"; $sql.= " moushikomibi,"; $sql.= " rank_no,"; $sql.= " tesuryou,"; $sql.= " mukou_flg,"; $sql.= " ltime"; $sql.= ") VALUES ("; $sql.= " '未確定',"; $sql.= " :relocation_flg,"; $sql.= " :chintai_flg,"; $sql.= " :sublease_flg,"; $sql.= " :purpose_flg,"; $sql.= " :buken_sbt,"; $sql.= " :shikucyouson_no,"; $sql.= " :buken_shozai,"; $sql.= " :sonota_jusho,"; $sql.= " :buken_tatemono,"; $sql.= " :chikunensu,"; $sql.= " :menseki,"; $sql.= " :input_val,"; $sql.= " :input_kbn,"; $sql.= " :land_val,"; $sql.= " :madori_no,"; $sql.= " :meigi_no,"; $sql.= " :genjyou_no,"; $sql.= " :room_cnt,"; $sql.= " :fudousan_flg,"; $sql.= " :fudousan_nm,"; $sql.= " :bikou,"; $sql.= " :namae,"; $sql.= " :namae_kn,"; $sql.= " :tel,"; $sql.= " :e_mail,"; $sql.= " :sumai_flg,"; $sql.= " :sumai_zipcode,"; $sql.= " :sumai_addr,"; $sql.= " :sumai_tatemono,"; $sql.= " CURRENT_TIMESTAMP,"; $sql.= " :rank_no,"; $sql.= " :tesuryou,"; $sql.= " 0,"; $sql.= " CURRENT_TIMESTAMP)"; $stmt = $db->prepare($sql); $buken_basho = $posted["buken_tatemono"]." ".$posted["buken_heya"]; $stmt->bindParam(":relocation_flg", f_bool_edit_db($posted["relocation_flg"], "0"), PDO::PARAM_INT); $stmt->bindParam(":chintai_flg", f_bool_edit_db($posted["chintai_flg"], "0"), PDO::PARAM_INT); $stmt->bindParam(":sublease_flg", f_bool_edit_db($posted["sublease_flg"], "0"), PDO::PARAM_INT); $stmt->bindParam(":purpose_flg", f_num_edit_db($posted["purpose_flg"], "0"), PDO::PARAM_INT); $stmt->bindParam(":buken_sbt", f_num_edit_db($posted["buken_sbt"], "0"), PDO::PARAM_INT); $stmt->bindParam(":shikucyouson_no", f_num_edit_db($posted["shikucyouson_no"], "0"), PDO::PARAM_STR); $stmt->bindParam(":buken_shozai", $posted["buken_shozai"], PDO::PARAM_STR); $stmt->bindParam(":sonota_jusho", $posted["sonota_jusho"], PDO::PARAM_STR); $stmt->bindParam(":buken_tatemono", $buken_basho, PDO::PARAM_STR); $stmt->bindParam(":chikunensu", f_num_edit_db($posted["chikunensu"], "0.00"), PDO::PARAM_STR); $stmt->bindParam(":menseki", $posted["input_val"], PDO::PARAM_STR); $stmt->bindParam(":input_val", $posted["input_val"], PDO::PARAM_STR); $stmt->bindParam(":input_kbn", f_num_edit_db($posted["input_kbn"], "0"), PDO::PARAM_INT); $stmt->bindParam(":land_val", f_num_edit_db($posted["land_val"], "0"), PDO::PARAM_STR); $stmt->bindParam(":madori_no", f_num_edit_db($posted["madori_no"], "0"), PDO::PARAM_INT); $stmt->bindParam(":meigi_no", f_num_edit_db($posted["meigi_no"], "0"), PDO::PARAM_INT); $stmt->bindParam(":genjyou_no", f_num_edit_db($posted["genjyou_no"], "0"), PDO::PARAM_INT); $stmt->bindParam(":room_cnt", f_num_edit_db($posted["room_cnt"], "0"), PDO::PARAM_INT); $stmt->bindParam(":fudousan_flg", f_bool_edit_db($posted["fudousan_flg"], "0"), PDO::PARAM_INT); $stmt->bindParam(":fudousan_nm", $posted["fudousan_nm"], PDO::PARAM_STR); $stmt->bindParam(":bikou", $posted["bikou"], PDO::PARAM_STR); $stmt->bindParam(":namae", $posted["namae"], PDO::PARAM_STR); $stmt->bindParam(":namae_kn", $posted["namae_kn"], PDO::PARAM_STR); $stmt->bindParam(":tel", $posted["tel"], PDO::PARAM_STR); $stmt->bindParam(":e_mail", $posted["e_mail"], PDO::PARAM_STR); $stmt->bindParam(":sumai_flg", f_num_edit_db($posted["sumai_flg"], "0"), PDO::PARAM_INT); $stmt->bindParam(":sumai_zipcode", $posted["sumai_zipcode"], PDO::PARAM_STR); $stmt->bindParam(":sumai_addr", $posted["sumai_addr"], PDO::PARAM_STR); $stmt->bindParam(":sumai_tatemono", $posted["sumai_tatemono"], PDO::PARAM_STR); $stmt->bindParam(":rank_no", f_num_edit_db($_SESSION["rank_no"], "0"), PDO::PARAM_INT); $stmt->bindParam(":tesuryou", f_num_edit_db($_SESSION["tesuryou"], "0"), PDO::PARAM_STR); $ret = $stmt->execute(); if ($ret == False) { $db->rollback(); //print_r($stmt->errorInfo()); $_SESSION["ErrorMessage"] = "大変申し訳ございません申し込みができませんでした。"; return false; } $item_no = $db->lastInsertId("item_no"); $_SESSION["item_no"] = $item_no; $buken_sbt = f_num_edit_db($posted["buken_sbt"], "0"); $wk_anken_no = get_anken_no($buken_sbt, $item_no); $sql = "UPDATE t_item SET"; $sql.= " anken_no = :wk_anken_no "; $sql.= "WHERE"; $sql.= " item_no = :item_no"; $stmt = $db->prepare($sql); $stmt->bindParam(":wk_anken_no", $wk_anken_no, PDO::PARAM_STR); $stmt->bindParam(":item_no", $item_no, PDO::PARAM_INT); $stmt->execute(); if($ret["errno"] > 0){ $db->rollback(); $msg = "大変申し訳ございません申し込みができませんでした。"; return false; } $cpn_data = get_com_data($_SESSION["arr_company_info"], $posted["shikucyouson_no"]); $arr_company = $_SESSION["arr_company_info"]; for ($i = 0; $i < count($arr_company); $i++) { $company = $arr_company[$i]; $company_no = $company["company_no"]; if (!is_numeric($company_no)) { $company_no = 0; } $company_kbn = $company["kubun"]; if ($company_kbn == "relocation") { $kubun_nm = "リロケーション"; } else if ($company_kbn == "chintai") { $kubun_nm = "賃貸募集・賃貸管理"; } else if ($company_kbn == "sublease") { $kubun_nm = "サブリース"; } $sql = "INSERT INTO t_item_company ("; $sql.= " item_no,"; $sql.= " company_no,"; $sql.= " kubun_nm"; $sql.= ") VALUES ("; $sql.= $item_no.","; $sql.= $company_no.","; $sql.= "'".$kubun_nm."')"; $ret = $db->query($sql); if ($ret == False){ $db->rollback(); $msg = "大変申し訳ございません申し込みができませんでした。"; return false; } if (($posted["purpose_flg"] == 1) && ($cpn_data[$company_no]["light_flg"] > 0) && ($cpn_data[$company_no]["plan_flg"] == 1 || $cpn_data[$company_no]["plan_flg"] == 3)) { $cpn_data[$company_no]["light_flg"] = $cpn_data[$company_no]["light_flg"]; } else { $cpn_data[$company_no]["light_flg"] = 0; } $ret = set_tesuryo_tab($item_no, $company_no, $cpn_data[$company_no]["light_flg"], $cpn_data[$company_no]["kotei_flg"], $cpn_data[$company_no]["shikucyouson_kingaku"], "CURRENT_TIMESTAMP", f_num_edit_db($_SESSION["rank_no"], "0")); if ($ret == False) { $db->rollback(); $msg = "大変申し訳ございません申し込みができませんでした。"; return false; } } $db->commit(); send_mail($posted); $db = null; return true; }