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