function db_delete($gc) {
$gc->db->begin_tran();
$sql = "DELETE FROM";
$sql.= " propertylist ";
$sql.= "WHERE";
$sql.= " property_no = ".f_num_edit_db($gc->property_no);
$ret = $gc->db->execute($sql, true);
if($ret["errno"] > 0){
$gc->db->rollback();
if(db_set_delete_errmsg($gc, $ret["errno"], $ret["error"])){
return false;
}else{
die('delete error');
}
}
//詳細削除
$sql = "DELETE FROM";
$sql.= " propertydetail ";
$sql.= "WHERE";
$sql.= " property_no = ".f_num_edit_db($gc->property_no);
$ret = $gc->db->execute($sql, true);
if($ret["errno"] > 0){
$gc->db->rollback();
if(db_set_delete_errmsg($gc, $ret["errno"], $ret["error"])){
return false;
}else{
die('delete error');
}
}
$gc->db->commit();
return true;
}
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 update_tesuryo($gc, $kingaku_kotei, $kingaku_light)
{
$sql = "select * from t_tesuryou t ";
$sql .= "left join t_item i on t.item_no=i.item_no ";
$sql .= "left join (select company_no,shikucyouson_kingaku,shikucyouson_no from m_company_area where company_no=" . $gc->company_no . ") a on i.buken_shikucyouson_no=a.shikucyouson_no ";
$sql .= " where t.company_no=" . $gc->company_no . " and DATE_FORMAT(t.moushikomibi, '%Y%m')='" . date("Ym") . "'";
$rs = $gc->db->query($sql);
while ($rs->eof == false) {
$sql2 = "update t_tesuryou set";
$sql2 .= " kotei_flg=" . f_num_edit_db($kingaku_kotei, 0);
if ($kingaku_light > 0 && $rs->fields["purpose_flg"] == 1 && $rs->fields["plan_flg"] != 2) {
$sql2 .= ", light_flg=" . f_num_edit_db($kingaku_light, 0);
} else {
$sql2 .= ", light_flg=0";
}
if ($kingaku_kotei > 0) {
$sql2 .= ", tesuryou=" . f_num_edit_db($kingaku_kotei, 0);
} elseif ($kingaku_light > 0 && $rs->fields["purpose_flg"] == 1 && $rs->fields["plan_flg"] != 2) {
$sql2 .= ", tesuryou=" . f_num_edit_db($kingaku_light, 0);
} else {
$sql2 .= ", tesuryou=" . f_num_edit_db($rs->fields["shikucyouson_kingaku"], 0);
}
$sql2 .= " where company_no=" . $gc->company_no . " and item_no=" . $rs->fields["item_no"] . " and DATE_FORMAT(moushikomibi, '%Y%m')='" . date("Ym") . "'";
$ret = $gc->db->execute($sql2, true);
$ecnt++;
$rs->move_next();
}
return $ret;
}
function db_entry($gc) {
$gc->db->begin_tran();
$zip = $_POST["zip1"]."-".$_POST["zip2"];
if (!preg_match("/^\d{3}\-\d{4}$/", $zip)) {
$zip = "";
}
$sk_zip = $_POST["sk_zip1"]."-".$_POST["sk_zip2"];
if (!preg_match("/^\d{3}\-\d{4}$/", $sk_zip)) {
$sk_zip = "";
}
switch ($_POST["act"]) {
case "i":
//新規追加処理
$sql = "INSERT INTO m_company (";
$sql.= " company_nm,";
$sql.= " company_sh,";
$sql.= " company_kn,";
$sql.= " company_kbn,";
$sql.= " tantou,";
$sql.= " tel,";
$sql.= " fax,";
$sql.= " e_mail,";
$sql.= " e_mail_2,";
$sql.= " e_mail_3,";
$sql.= " e_mail_4,";
$sql.= " e_mail_5,";
$sql.= " e_mail_6,";
$sql.= " e_mail_7,";
$sql.= " e_mail_8,";
$sql.= " e_mail_9,";
$sql.= " e_mail_10,";
$sql.= " url,";
$sql.= " zip,";
$sql.= " todoufuken_no,";
$sql.= " add1,";
$sql.= " add2,";
$sql.= " sk_zip,";
$sql.= " sk_todoufuken_no,";
$sql.= " sk_add1,";
$sql.= " sk_add2,";
$sql.= " sk_jigyoubu,";
$sql.= " sk_tantou,";
$sql.= " jyougen,";
$sql.= " light_flg,";
$sql.= " kingaku_light,";
$sql.= " kingaku_kotei,";
$sql.= " kakuritsu,";
//$sql.= " chintai_flg,";
//$sql.= " relocation_flg,";
$sql.= " chintai_flg,";
$sql.= " chintai_ritu,";
$sql.= " relocation_flg,";
$sql.= " relocation_ritu,";
$sql.= " sublease_flg,";
$sql.= " sublease_ritu,";
$sql.= " comment,";
$sql.= " plan_flg,";
$sql.= " light_ritu,";
$sql.= " display_flg,";
$sql.= " buken_mansion_flg,";
$sql.= " buken_kodate_flg,";
$sql.= " buken_ittou_flg,";
$sql.= " keisai_flg,";
$sql.= " keisai_logo_flg,";
$sql.= " keisai_comment_flg,";
$sql.= " ddir,";
$sql.= " ltime";
$sql.= ") VALUES (";
$sql.= "'".f_dbs($_POST["company_nm"])."',";
$sql.= "'".f_dbs($_POST["company_sh"])."',";
$sql.= "'".f_dbs($_POST["company_kn"])."',";
$sql.= f_num_edit_db($_POST["company_kbn"], 0).",";
$sql.= "'".f_dbs($_POST["tantou"])."',";
$sql.= "'".f_dbs($_POST["tel"])."',";
$sql.= "'".f_dbs($_POST["fax"])."',";
$sql.= "'".f_dbs($_POST["e_mail"])."',";
$sql.= "'".f_dbs($_POST["e_mail_2"])."',";
$sql.= "'".f_dbs($_POST["e_mail_3"])."',";
$sql.= "'".f_dbs($_POST["e_mail_4"])."',";
$sql.= "'".f_dbs($_POST["e_mail_5"])."',";
$sql.= "'".f_dbs($_POST["e_mail_6"])."',";
$sql.= "'".f_dbs($_POST["e_mail_7"])."',";
$sql.= "'".f_dbs($_POST["e_mail_8"])."',";
$sql.= "'".f_dbs($_POST["e_mail_9"])."',";
$sql.= "'".f_dbs($_POST["e_mail_10"])."',";
$sql.= "'".f_dbs($_POST["url"])."',";
$sql.= "'".f_dbs($zip)."',";
$sql.= f_num_edit_db($_POST["todoufuken_no"]).",";
$sql.= "'".f_dbs($_POST["add1"])."',";
$sql.= "'".f_dbs($_POST["add2"])."',";
$sql.= "'".f_dbs($sk_zip)."',";
$sql.= f_num_edit_db($_POST["sk_todoufuken_no"]).",";
$sql.= "'".f_dbs($_POST["sk_add1"])."',";
$sql.= "'".f_dbs($_POST["sk_add2"])."',";
$sql.= "'".f_dbs($_POST["sk_jigyoubu"])."',";
$sql.= "'".f_dbs($_POST["sk_tantou"])."',";
$sql.= f_num_edit_db($_POST["jyougen"], 0).",";
$sql.= f_bool_edit_db($_POST["light_flg"], 0).",";
$sql.= f_num_edit_db($_POST["kingaku_light"], 0).",";
$sql.= f_num_edit_db($_POST["kingaku_kotei"], 0).",";
$sql.= f_num_edit_db($_POST["kakuritsu"], 0).",";
//$sql.= f_bool_edit_db($_POST["chintai_flg"], 0).",";
//$sql.= f_bool_edit_db($_POST["relocation_flg"], 0).",";
$sql.= f_bool_edit_db($_POST["chintai_flg"], 0).",";
$sql.= f_num_edit_db($_POST["chintai_ritu"], 0).",";
$sql.= f_bool_edit_db($_POST["relocation_flg"], 0).",";
$sql.= f_num_edit_db($_POST["relocation_ritu"], 0).",";
$sql.= f_bool_edit_db($_POST["sublease_flg"], 0).",";
$sql.= f_num_edit_db($_POST["sublease_ritu"], 0).",";
$sql.= "'".f_dbs($_POST["comment"])."',";
$sql.= f_num_edit_db($_POST["plan_flg"], 0).",";
$sql.= f_num_edit_db($_POST["light_ritu"], 0).",";
$sql.= f_num_edit_db($_POST["display_flg"], 0).",";
$sql.= f_bool_edit_db($_POST["buken_mansion_flg"], 0).",";
$sql.= f_bool_edit_db($_POST["buken_kodate_flg"], 0).",";
$sql.= f_bool_edit_db($_POST["buken_ittou_flg"], 0).",";
$sql.= f_bool_edit_db($_POST["keisai_flg"], 0).",";
$sql.= f_bool_edit_db($_POST["keisai_logo_flg"], 0).",";
$sql.= f_bool_edit_db($_POST["keisai_comment_flg"], 0).",";
$sql.= "'".f_dbs(f_get_random_str())."',";
$sql.= "CURRENT_TIMESTAMP)";
$ret = $gc->db->execute($sql, true);
if($ret["errno"] > 0){
$gc->db->rollback();
if(db_set_errmsg($gc, $ret["errno"], $ret["error"])){
return false;
}else{
die('insert error '.$sql);
}
}
$gc->company_no = $gc->db->get_last_id();
if (strlen($gc->img_tmp_nm)>0 and $gc->img_del!="y") {
fimg_tmp_rename($gc->img_tmp_nm, $gc->company_no, "logo/");
fimg_copy($gc->company_no, "logo/");
}
break;
case "u":
//更新処理
$sql = "UPDATE m_company SET";
$sql.= " company_nm = '".f_dbs($_POST["company_nm"])."',";
$sql.= " company_sh = '".f_dbs($_POST["company_sh"])."',";
$sql.= " company_kn = '".f_dbs($_POST["company_kn"])."',";
$sql.= " company_kbn = ".f_num_edit_db($_POST["company_kbn"], 0).",";
$sql.= " tantou = '".f_dbs($_POST["tantou"])."',";
$sql.= " tel = '".f_dbs($_POST["tel"])."',";
$sql.= " fax = '".f_dbs($_POST["fax"])."',";
$sql.= " e_mail = '".f_dbs($_POST["e_mail"])."',";
$sql.= " e_mail_2 = '".f_dbs($_POST["e_mail_2"])."',";
$sql.= " e_mail_3 = '".f_dbs($_POST["e_mail_3"])."',";
$sql.= " e_mail_4 = '".f_dbs($_POST["e_mail_4"])."',";
$sql.= " e_mail_5 = '".f_dbs($_POST["e_mail_5"])."',";
$sql.= " e_mail_6 = '".f_dbs($_POST["e_mail_6"])."',";
$sql.= " e_mail_7 = '".f_dbs($_POST["e_mail_7"])."',";
$sql.= " e_mail_8 = '".f_dbs($_POST["e_mail_8"])."',";
$sql.= " e_mail_9 = '".f_dbs($_POST["e_mail_9"])."',";
$sql.= " e_mail_10 = '".f_dbs($_POST["e_mail_10"])."',";
$sql.= " url = '".f_dbs($_POST["url"])."',";
$sql.= " zip = '".f_dbs($zip)."',";
$sql.= " todoufuken_no = ".f_num_edit_db($_POST["todoufuken_no"]).",";
$sql.= " add1 = '".f_dbs($_POST["add1"])."',";
$sql.= " add2 = '".f_dbs($_POST["add2"])."',";
$sql.= " sk_zip = '".f_dbs($sk_zip)."',";
$sql.= " sk_todoufuken_no = ".f_num_edit_db($_POST["sk_todoufuken_no"]).",";
$sql.= " sk_add1 = '".f_dbs($_POST["sk_add1"])."',";
$sql.= " sk_add2 = '".f_dbs($_POST["sk_add2"])."',";
$sql.= " sk_jigyoubu = '".f_dbs($_POST["sk_jigyoubu"])."',";
$sql.= " sk_tantou = '".f_dbs($_POST["sk_tantou"])."',";
$sql.= " jyougen = ".f_num_edit_db($_POST["jyougen"], 0).",";
$sql.= " light_flg = ".f_bool_edit_db($_POST["light_flg"], 0).",";
$sql.= " kingaku_light = ".f_num_edit_db($_POST["kingaku_light"], 0).",";
$sql.= " kingaku_kotei = ".f_num_edit_db($_POST["kingaku_kotei"], 0).",";
$sql.= " kakuritsu = ".f_num_edit_db($_POST["kakuritsu"], 0).",";
//$sql.= " chintai_flg = ".f_bool_edit_db($_POST["chintai_flg"], 0).",";
//$sql.= " relocation_flg = ".f_bool_edit_db($_POST["relocation_flg"], 0).",";
$sql.= " chintai_flg = ".f_bool_edit_db($_POST["chintai_flg"], 0).",";
$sql.= " chintai_ritu = ".f_num_edit_db($_POST["chintai_ritu"], 0).",";
$sql.= " relocation_flg = ".f_bool_edit_db($_POST["relocation_flg"], 0).",";
$sql.= " relocation_ritu = ".f_num_edit_db($_POST["relocation_ritu"], 0).",";
$sql.= " sublease_flg = ".f_bool_edit_db($_POST["sublease_flg"], 0).",";
$sql.= " sublease_ritu = ".f_num_edit_db($_POST["sublease_ritu"], 0).",";
$sql.= " comment = '".f_dbs($_POST["comment"])."',";
$sql.= " plan_flg = ".f_num_edit_db($_POST["plan_flg"], 0).",";
$sql.= " light_ritu = ".f_num_edit_db($_POST["light_ritu"], 0).",";
$sql.= " display_flg = ".f_num_edit_db($_POST["display_flg"], 0).",";
$sql.= " buken_mansion_flg = ".f_bool_edit_db($_POST["buken_mansion_flg"], 0).",";
$sql.= " buken_kodate_flg = ".f_bool_edit_db($_POST["buken_kodate_flg"], 0).",";
$sql.= " buken_ittou_flg = ".f_bool_edit_db($_POST["buken_ittou_flg"], 0).",";
$sql.= " keisai_flg = ".f_bool_edit_db($_POST["keisai_flg"], 0).",";
$sql.= " keisai_logo_flg = ".f_bool_edit_db($_POST["keisai_logo_flg"], 0).",";
$sql.= " keisai_comment_flg = ".f_bool_edit_db($_POST["keisai_comment_flg"], 0).",";
$sql.= " ltime = CURRENT_TIMESTAMP ";
$sql.= "WHERE";
$sql.= " company_no = ".$gc->company_no;
$ret = $gc->db->execute($sql, true);
if($ret["errno"] > 0){
$gc->db->rollback();
if(db_set_errmsg($gc, $ret["errno"], $ret["error"])){
return false;
}else{
die('update error');
}
}
if ($gc->img_del=="y") {
fimg_delete($gc->img_nm, "logo/");
}else{
if (strlen($gc->img_tmp_nm)>0) {
fimg_delete($gc->img_nm, "logo/");
fimg_tmp_rename($gc->img_tmp_nm, $gc->company_no, "logo/");
fimg_copy($gc->company_no, "logo/");
}
}
break;
}
$ret = edit_kotei($gc,$_POST["kingaku_kotei"]);
$ret = update_tesuryo($gc,$_POST["kingaku_kotei"],$_POST["kingaku_light"]);
if($ret["errno"] > 0){
$gc->db->rollback();
if(db_set_errmsg($gc, $ret["errno"], $ret["error"])){
return false;
}else{
die('SQL error');
}
}
$gc->db->commit();
return true;
}
function db_entry($gc) {
set_time_limit(600);
$gc->db->begin_tran();
$file_name = C_TMP_PATH.$gc->tmp_company_area_file;
if ( ($gc->tmp_company_area_file != "") and file_exists($file_name)) {
$fp = fopen($file_name, 'r');
$cnt = 0;
while(($line=f_mb_fgetcsv($fp)) !== false){
if(count($line) > 1){
if(implode("",$line)!=""){
if($cnt >0){
$todoufuken_no = $line[0]; //都道府県コード
$todoufuken_nm = $line[1]; //都道府県名
$shikucyouson_no = $line[2]; //市区町村コード
$shikucyouson_nm = $line[3]; //市区町村名
for ($i=5; $i<count($line); $i=$i+2) {
$company_no = $line[$i]; //提携会社コード
$shikucyouson_kingaku = $line[$i+1]; //金額
$delete_flg = 0;
$edit_flg = 0;
$sql = "";
if($shikucyouson_kingaku > 0){
if($gc->company_no > 0){
if($gc->company_no == $company_no){
$edit_flg = 1;
}
}else{
$edit_flg = 1;
}
}else{
if($gc->company_no > 0){
if($gc->company_no == $company_no){
$delete_flg = 1;
}
}else{
$delete_flg = 1;
}
}
if($edit_flg == 1){
if(checkinsert($gc, $company_no, $shikucyouson_no)){
$sql =" INSERT INTO m_company_area( ";
$sql.=" company_no";
$sql.=" , shikucyouson_no";
$sql.=" , shikucyouson_kingaku";
$sql.=" ) VALUES ( ";
$sql.= f_num_edit_db($company_no).",";
$sql.= f_num_edit_db($shikucyouson_no).",";
$sql.= f_num_edit_db($shikucyouson_kingaku);
$sql.= ")";
}else{
$sql =" UPDATE m_company_area SET ";
$sql.=" company_no='".f_num_edit_db($company_no)."'";
$sql.=" , shikucyouson_no='".f_num_edit_db($shikucyouson_no)."'";
$sql.=" , shikucyouson_kingaku='".f_num_edit_db($shikucyouson_kingaku)."'";
$sql.= " WHERE company_no='".f_num_edit_db($company_no)."' AND shikucyouson_no='".f_num_edit_db($shikucyouson_no)."'";
}
$ret = $gc->db->execute($sql, true);
if($ret["errno"] > 0){
$gc->db->rollback();
if(db_set_errmsg($gc, $ret["errno"], $ret["error"])){
//echo $sql;
return false;
}else{
die('system error1');
}
return false;
}
}elseif($delete_flg == 1){
if(!checkinsert($gc, $company_no, $shikucyouson_no)){
$sql =" DELETE from m_company_area";
$sql.= " WHERE company_no='".f_num_edit_db($company_no)."' AND shikucyouson_no='".f_num_edit_db($shikucyouson_no)."'";
$ret = $gc->db->execute($sql, true);
if($ret["errno"] > 0){
$gc->db->rollback();
if(db_set_errmsg($gc, $ret["errno"], $ret["error"])){
//echo $sql;
return false;
}else{
die('system error1');
}
return false;
}
}
}
}
}
$cnt++;
}
}
}
fclose($fp);
}
$gc->db->commit();
return true;
}
function checkinsert($gc, $property_nm, $todoufuken_nm, $shikucyouson_nm, $town_nm, $address, $rent){
$sql =" SELECT no";
$sql.=" FROM propertydetail ";
$sql.=" WHERE";
$sql.=" property_nm = '".f_dbs($property_nm)."'";
$sql.=" AND todoufuken_nm = '".f_dbs($todoufuken_nm)."'";
$sql.=" AND shikucyouson_nm = '".f_dbs($shikucyouson_nm)."'";
$sql.=" AND town_nm = '".f_dbs($town_nm)."'";
$sql.=" AND address = '".f_dbs($address)."'";
$sql.=" AND rent = ".f_num_edit_db($rent);
$rs = $gc->db->query($sql);
if(!$rs->eof){
return false;
}
$rs->free_result();
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;
}
