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;
}
