function get_info($gc) { // if($relocation_flg==1){ // $tesuryou[1] = 20000; // $tesuryou[2] = 20000; // $tesuryou[3] = 20000; // $tesuryou[4] = 20000; // }else{ // // if($gc->menseki < 30){ // $tesuryou[1] = 20000; // $tesuryou[2] = 13000; // $tesuryou[3] = 10000; // $tesuryou[4] = 5000; // }elseif($gc->menseki < 50){ // $tesuryou[1] = 26000; // $tesuryou[2] = 19000; // $tesuryou[3] = 16000; // $tesuryou[4] = 7000; // }elseif($gc->menseki < 70){ // $tesuryou[1] = 35000; // $tesuryou[2] = 25000; // $tesuryou[3] = 20000; // $tesuryou[4] = 8000; // }else{ // $tesuryou[1] = 52000; // $tesuryou[2] = 43000; // $tesuryou[3] = 32000; // $tesuryou[4] = 10000; // } // // } $relocation_flg = f_bool_edit_db($_POST["relocation_flg"], "0"); $rank = get_rank($gc); if ($relocation_flg == 1) { $tesuryou[1] = 15000; $tesuryou[2] = 15000; $tesuryou[3] = 15000; $tesuryou[4] = 15000; } else { $tesuryou[1] = 15000; $tesuryou[2] = 15000; $tesuryou[3] = 8000; $tesuryou[4] = 8000; } $info["rank"] = $rank; //ライトプランのとき 金額だけ知りたいとき if ($_POST["purpose_flg"] == 1) { $info["tesuryou"] = 2500; } else { $info["tesuryou"] = $tesuryou[$rank]; } return $info; }
function get_info($gc) { $relocation_flg = f_bool_edit_db($_POST["relocation_flg"], "0"); $rank = get_rank($gc); if($relocation_flg==1){ $tesuryou[1] = 15000; $tesuryou[2] = 15000; $tesuryou[3] = 15000; $tesuryou[4] = 15000; }else{ $tesuryou[1] = 15000; $tesuryou[2] = 15000; $tesuryou[3] = 8000; $tesuryou[4] = 8000; } $info["rank"] = $rank; //ライトプランのとき 金額だけ知りたいとき if($_POST["purpose_flg"] == 1){ $info["tesuryou"] = 2500; }else{ $info["tesuryou"] = $tesuryou[$rank]; } return $info; }
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; }