function db_entry2($gc) {
$gc->db->begin_tran();
switch ($_POST["act"]) {
case "u":
//更新処理
$sql = "UPDATE m_company_user SET";
$sql.= " password = '******',";
$sql.= " ltime = CURRENT_TIMESTAMP ";
$sql.= "WHERE";
$sql.= " user_no = ".$gc->user_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');
}
}
break;
}
$gc->db->commit();
return true;
}
function db_entry($gc) {
$gc->db->begin_tran();
//コメント更新処理
$sql = "UPDATE propertylist SET";
$sql.= " comment = '".f_dbs($_POST["comment"])."',";
$sql.= "latlon = GeomFromText('POINT($gc->lon $gc->lat)'),";
$sql.= " direction = ".f_num_edit_db($_POST["direction"]).",";
$sql.= " pitch = ".f_num_edit_db($_POST["pitch"]).",";
$sql.= " zoom = ".f_num_edit_db($_POST["zoom"]).",";
$sql.= " ltime = CURRENT_TIMESTAMP ";
$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_errmsg($gc, $ret["errno"], $ret["error"])){
return false;
}else{
die('update error');
}
}
$gc->db->commit();
return true;
}
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 db_entry($gc) {
set_time_limit(600);
$gc->db->begin_tran();
$file_name = C_TMP_PATH.$gc->tmp_buken_file;
if ( ($gc->tmp_buken_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_nm = $line[0]; //都道府県
$shikucyouson_nm = $line[1]; //市区町村
$town_nm = $line[2]; //町名
$address = mb_substr($line[3],1); //番地
$property_nm = mb_convert_kana($line[4],Kas,"UTF-8"); //物件名
$railroad = $line[5]; //沿線
$station = $line[6]; //駅名
$rent = $line[7]; //賃料
$unit_price = $line[8]; //㎡単価
$kouzou = $line[9]; //建物構造
$tijyokaisu = $line[10]; //地上階数
$tikakaisu = $line[11]; //地下階数
$comment = trim($line[12]); //コメント
$addressinfo = getaddressinfo($gc, $property_nm, $todoufuken_nm, $shikucyouson_nm, $town_nm, $address, $comment);
if($addressinfo["return"] == false){
$gc->msg->add("第".$cnt."行目 物件名:".$property_nm." ".$addressinfo["errmsg"]);
$gc->db->rollback();
return false;
}
if(checkinsert($gc, $property_nm, $todoufuken_nm, $shikucyouson_nm, $town_nm, $address, $rent)){
$sql =" INSERT INTO propertydetail( ";
$sql.=" property_no";
$sql.=" , property_nm";
$sql.=" , todoufuken_no";
$sql.=" , todoufuken_nm";
$sql.=" , shikucyouson_no";
$sql.=" , shikucyouson_nm";
$sql.=" , town_nm";
$sql.=" , address";
$sql.=" , railroad";
$sql.=" , station";
$sql.=" , kouzou";
$sql.=" , tijyokaisu";
$sql.=" , tikakaisu";
$sql.=" , rent";
$sql.=" , unit_price";
$sql.=" , ltime";
$sql.=" ) VALUES ( ";
$sql.= f_num_edit_db($addressinfo["property_no"]).",";
$sql.= "'".f_dbs($property_nm)."',";
$sql.= f_num_edit_db($addressinfo["todoufuken_no"]).",";
$sql.= "'".f_dbs($todoufuken_nm)."',";
$sql.= f_num_edit_db($addressinfo["shikucyouson_no"]).",";
$sql.= "'".f_dbs($shikucyouson_nm)."',";
$sql.= "'".f_dbs($town_nm)."',";
$sql.= "'".f_dbs($address)."',";
$sql.= "'".f_dbs($railroad)."',";
$sql.= "'".f_dbs($station)."',";
$sql.= f_num_edit_db($kouzou).",";
$sql.= f_num_edit_db($tijyokaisu).",";
$sql.= f_num_edit_db($tikakaisu).",";
$sql.= f_num_edit_db($rent).",";
$sql.= f_num_edit_db($unit_price).",";
$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"])){
//echo $sql;
return false;
}else{
die('system error1');
}
return false;
}
}
}
$cnt++;
}
}
}
fclose($fp);
}
$gc->db->commit();
return true;
}
function db_entry($gc) {
$gc->db->begin_tran();
switch ($_POST["act"]) {
case "i":
//新規追加処理
$sql = "INSERT INTO m_company_user (";
$sql.= " company_no,";
$sql.= " user_nm,";
$sql.= " user_kn,";
$sql.= " user_id,";
$sql.= " password,";
$sql.= " e_mail,";
$sql.= " auth,";
$sql.= " ltime";
$sql.= ") VALUES (";
$sql.= "'".f_dbs($_POST["company_no"])."',";
$sql.= "'".f_dbs($_POST["user_nm"])."',";
$sql.= "'".f_dbs($_POST["user_kn"])."',";
$sql.= "'".f_dbs($_POST["user_id"])."',";
$sql.= "'".f_dbs($_POST["password"])."',";
$sql.= "'".f_dbs($_POST["e_mail"])."',";
$sql.= "'".f_dbs(check_auth($gc))."',";
$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');
}
}
$gc->user_no = $gc->db->get_last_id();
break;
case "u":
//更新処理
$sql = "UPDATE m_company_user SET";
$sql.= " user_nm = '".f_dbs($_POST["user_nm"])."',";
$sql.= " user_kn = '".f_dbs($_POST["user_kn"])."',";
$sql.= " user_id = '".f_dbs($_POST["user_id"])."',";
$sql.= " password = '******',";
$sql.= " e_mail = '".f_dbs($_POST["e_mail"])."',";
$sql.= " ltime = CURRENT_TIMESTAMP ";
$sql.= "WHERE";
$sql.= " user_no = ".$gc->user_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');
}
}
break;
}
$gc->db->commit();
return true;
}
