function get_standard_company($gc){ //----------------------------------------------------- //スタンダードプラン //----------------------------------------------------- //会社取得数 $cnt = 3; $gc->arr_company = null; $gc->arr_company_kbn = null; $it = 0; if($_POST["relocation_flg"] == 1){ $it ++; } if($_POST["chintai_flg"] == 1){ $it ++; } if($_POST["sublease_flg"] == 1){ $it ++; } //一括抽選 $sql = "SELECT"; $sql.= " c.company_no,"; $sql.= " company_nm,"; $sql.= " company_kbn,"; $sql.= " kakuritsu,"; $sql.= " chintai_flg,"; $sql.= " chintai_ritu,"; $sql.= " relocation_flg,"; $sql.= " relocation_ritu,"; $sql.= " sublease_flg,"; $sql.= " sublease_ritu,"; $sql.= " c.display_flg,"; $sql.= " c.plan_flg,"; $sql.= " comment "; $sql.= "FROM"; $sql.= " m_company c "; $sql.= "INNER JOIN "; $sql.= "("; $sql.= "SELECT * FROM "; $sql.= " m_company_area mc "; $sql.= "WHERE "; $sql.= " mc.shikucyouson_no = ".$gc->shikucyouson_no.") mca "; $sql.= "ON c.company_no = mca.company_no "; $sql.= "WHERE"; $sql.= " c.keisai_flg = 1 AND"; $sql.= " c.plan_flg != 1 AND "; //物件種別により抽出する if($gc->buken_sbt == 1){ $sql.= " c.buken_mansion_flg = 1 AND"; } if($gc->buken_sbt == 2){ $sql.= " c.buken_ittou_flg = 1 AND"; } if($gc->buken_sbt == 3){ $sql.= " c.buken_kodate_flg = 1 AND"; } if(($gc->chintai_flg != 1) || ($gc->sublease_flg == 1) || ($gc->relocation_flg == 1)){ //ご希望サービスの賃貸募集・賃貸管理を選択した場合のみ表示 $sql.= " c.display_flg != 1 AND"; } if((($gc->chintai_flg == 1) || ($gc->sublease_flg != 1) || ($gc->relocation_flg == 1)) || (($gc->purpose_flg == 1) || ($gc->purpose_flg == 8))){ //ご希望のサービスのサブリースを選択した場合のみ表示 $sql.= " c.display_flg != 4 AND"; } if($gc->chikunensu > 15 || $gc->input_val < 35){ //築年数が15年以下で延床面積が35㎡以上の場合のみ表示 $sql.= " c.display_flg != 2 AND"; } if($gc->input_val < 40){ //延床面積が40平米以上のみ表示 $sql.= " c.display_flg != 3 AND"; } if(($gc->input_val < 10) || ($gc->input_val > 25)){ //延床面積10平米以上25平米以下の物件の場合のみ表示 $sql.= " c.display_flg != 5 AND"; } if($gc->purpose_flg != 4){ //賃貸管理会社を探しているにチェックが入った場合のみ表示 $sql.= " c.display_flg != 6 AND"; } $sql.= " ("; $sql.= " ("; $sql.= " (c.jyougen - mca.shikucyouson_kingaku) >= IFNULL(("; $sql.= " SELECT"; $sql.= " SUM(tesuryou) AS sum_tesuryou"; $sql.= " FROM"; $sql.= " t_tesuryou ti"; $sql.= " INNER JOIN"; $sql.= " t_item_company tc ON ti.item_no = tc.item_no AND tc.company_no = ti.company_no "; $sql.= " INNER JOIN ( "; $sql.= " SELECT * FROM"; $sql.= " m_company_area mc "; $sql.= " WHERE"; $sql.= " mc.shikucyouson_no = ".$gc->shikucyouson_no.") mca "; $sql.= " ON tc.company_no = mca.company_no "; $sql.= " WHERE"; $sql.= " tc.c_mukou_flg = 0 AND"; $sql.= " DATE_FORMAT(ti.moushikomibi,'%Y%m%d') BETWEEN '".date("Ym01", time())."' AND '".date("Ymt", time())."' AND"; $sql.= " tc.company_no = c.company_no"; $sql.= " ), 0)"; $sql.= " ) OR"; $sql.= " c.jyougen = 0"; $sql.= " OR c.kingaku_kotei > 0"; $sql.= " ) AND"; $sql.= " EXISTS ("; $sql.= " SELECT * FROM"; $sql.= " m_company_area ca"; $sql.= " WHERE"; $sql.= " ca.company_no = c.company_no AND"; $sql.= " ca.shikucyouson_no = ".$gc->shikucyouson_no.")"; $rs = $gc->db->query($sql); //print $sql; while ($rs->eof==false) { //大手=1 地場=2 $company_kbn = $rs->fields["company_kbn"]; $wk_r["kakuritsu"]["r"] = 0; $wk_r["kakuritsu"]["c"] = 0; $wk_r["kakuritsu"]["s"] = 0; if(($_POST["relocation_flg"] == 1) && ($rs->fields["relocation_flg"] == 1)){ $wk_r["company_no"] = $rs->fields["company_no"]; $wk_r["kakuritsu"]["r"] = $rs->fields["relocation_ritu"]; } if(($_POST["chintai_flg"] == 1) && ($rs->fields["chintai_flg"] == 1)){ $wk_r["company_no"] = $rs->fields["company_no"]; $wk_r["kakuritsu"]["c"] = $rs->fields["chintai_ritu"]; } if(($_POST["sublease_flg"] == 1) && ($rs->fields["sublease_flg"] == 1)){ if($rs->fields["display_flg"] == 4){ if($rs->fields["plan_flg"] == 2){ $wk_r["company_no"] = $rs->fields["company_no"]; $wk_r["kakuritsu"]["s"] = $rs->fields["sublease_ritu"]; } }else{ $wk_r["company_no"] = $rs->fields["company_no"]; $wk_r["kakuritsu"]["s"] = $rs->fields["sublease_ritu"]; } } $company_r[] = $wk_r; $rs->move_next(); } $rs->free_result(); //確率で会社取得 if($it == 1){ arr_company2($gc, $company_r, 3, "relocation"); }else{ arr_company2($gc, $company_r, 6, "relocation"); if(count($gc->arr_company) == 6){ $cnt --; } } //賃貸件数 $gc->r_cnt = count($gc->arr_company); //print_r($gc->arr_company); }
function get_standardplan($posted){ //----------------------------------------------------- //スタンダードプラン //----------------------------------------------------- require_once(dirname(__FILE__)."/../../../init.inc.php"); require_once(C_INC_DIR_SSL."db_utils.php"); $db = connect_db(); //会社取得数 $cnt = 3; $arr_company = array(); $it = 0; if($posted["relocation_flg"] == 1){ $it ++; } if($posted["chintai_flg"] == 1){ $it ++; } if($posted["sublease_flg"] == 1){ $it ++; } //一括抽選 $sql = "SELECT"; $sql.= " c.company_no,"; $sql.= " company_nm,"; $sql.= " company_kbn,"; $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.= " kakuritsu,"; $sql.= " chintai_flg,"; $sql.= " chintai_ritu,"; $sql.= " relocation_flg,"; $sql.= " relocation_ritu,"; $sql.= " sublease_flg,"; $sql.= " sublease_ritu,"; $sql.= " c.display_flg,"; $sql.= " c.plan_flg,"; $sql.= " comment "; $sql.= "FROM"; $sql.= " m_company c "; $sql.= "INNER JOIN "; $sql.= "("; $sql.= "SELECT * FROM "; $sql.= " m_company_area mc "; $sql.= "WHERE "; $sql.= " mc.shikucyouson_no = :shikucyouson_no) mca "; $sql.= "ON c.company_no = mca.company_no "; $sql.= "WHERE"; $sql.= " c.keisai_flg = 1 AND"; $sql.= " c.plan_flg != 1 AND "; //物件種別により抽出する if($posted["buken_sbt"] == 1){ $sql.= " c.buken_mansion_flg = 1 AND"; } if($posted["buken_sbt"] == 2){ $sql.= " c.buken_ittou_flg = 1 AND"; } if($posted["buken_sbt"] == 3){ $sql.= " c.buken_kodate_flg = 1 AND"; } if(($posted["chintai_flg"] != 1) || ($posted["sublease_flg"] == 1) || ($posted["relocation_flg"] == 1)){ //ご希望サービスの賃貸募集・賃貸管理を選択した場合のみ表示 $sql.= " c.display_flg != 1 AND"; } if($posted["chikunensu"] <= 15 && $posted["input_val"] >= 35){ }else{ //築年数が15年以下で延床面積が35㎡以上の場合のみ表示 $sql.= " c.display_flg != 2 AND"; } if($posted["input_val"] < 40){ //延床面積が40平米以上のみ表示 $sql.= " c.display_flg != 3 AND"; } if((($posted["chintai_flg"] == 1) || ($posted["sublease_flg"] != 1) || ($posted["relocation_flg"] == 1)) || (($posted["purpose_flg"] == 1) || ($posted["purpose_flg"] == 8))){ //ご希望のサービスのサブリースを選択した場合のみ表示 $sql.= " c.display_flg != 4 AND"; } if(($posted["input_val"] >= 10) && ($posted["input_val"] <= 25)){ }else{ //延床面積10平米以上25平米以下の物件の場合のみ表示 $sql.= " c.display_flg != 5 AND"; } if($posted["purpose_flg"] != 4){ //賃貸管理会社を探しているにチェックが入った場合のみ表示 $sql.= " c.display_flg != 6 AND"; } if($posted["chikunensu"] > 20){ //築年数が20年以下の場合のみ表示 $sql.= " c.display_flg != 7 AND"; } $sql.= " ("; $sql.= " ("; $sql.= " (c.jyougen - mca.shikucyouson_kingaku) >= IFNULL(("; $sql.= " SELECT"; $sql.= " SUM(tesuryou) AS sum_tesuryou"; $sql.= " FROM"; $sql.= " t_tesuryou ti"; $sql.= " INNER JOIN"; $sql.= " t_item_company tc ON ti.item_no = tc.item_no AND tc.company_no = ti.company_no "; $sql.= " INNER JOIN ( "; $sql.= " SELECT * FROM"; $sql.= " m_company_area mc "; $sql.= " WHERE"; $sql.= " mc.shikucyouson_no = :shikucyouson_no) mca "; $sql.= " ON tc.company_no = mca.company_no "; $sql.= " WHERE"; $sql.= " tc.c_mukou_flg = 0 AND"; $sql.= " DATE_FORMAT(ti.moushikomibi,'%Y%m%d') BETWEEN '".date("Ym01", time())."' AND '".date("Ymt", time())."' AND"; $sql.= " tc.company_no = c.company_no"; $sql.= " ), 0)"; $sql.= " ) OR"; $sql.= " c.jyougen = 0"; $sql.= " OR c.kingaku_kotei > 0"; $sql.= " ) AND"; $sql.= " EXISTS ("; $sql.= " SELECT * FROM"; $sql.= " m_company_area ca"; $sql.= " WHERE"; $sql.= " ca.company_no = c.company_no AND"; $sql.= " ca.shikucyouson_no = :shikucyouson_no)"; $stmt = $db->prepare($sql); $stmt->bindParam(":shikucyouson_no", $posted["shikucyouson_no"], PDO::PARAM_STR); $stmt->execute(); $company_ref = array(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { //大手=1 地場=2 $wk_r["kakuritsu"]["r"] = 0; $wk_r["kakuritsu"]["c"] = 0; $wk_r["kakuritsu"]["s"] = 0; if (($posted["relocation_flg"] == 1) && ($row["relocation_flg"] == 1)) { $wk_r["company_no"] = $row["company_no"]; $wk_r["kakuritsu"]["r"] = $row["relocation_ritu"]; } if( ($posted["chintai_flg"] == 1) && ($row["chintai_flg"] == 1)) { $wk_r["company_no"] = $row["company_no"]; $wk_r["kakuritsu"]["c"] = $row["chintai_ritu"]; } if (($posted["sublease_flg"] == 1) && ($row["sublease_flg"] == 1)) { if ($row["display_flg"] == 4) { if($row["plan_flg"] == 2) { $wk_r["company_no"] = $row["company_no"]; $wk_r["kakuritsu"]["s"] = $row["sublease_ritu"]; } } else { $wk_r["company_no"] = $row["company_no"]; $wk_r["kakuritsu"]["s"] = $row["sublease_ritu"]; } } $company_r[] = $wk_r; $company = $row; $company["sub_mails"] = [$row["e_mail_2"], $row["e_mail_3"], $row["e_mail_4"], $row["e_mail_5"], $row["e_mail_6"], $row["e_mail_7"], $row["e_mail_8"], $row["e_mail_9"], $row["e_mail_10"]]; $company_ref[$row["company_no"]] = $company; } $stmt->closeCursor(); //確率で会社取得 if ($it == 1) { $arr_company = arr_company2($company_r, $company_ref, 3); } else { $arr_company = arr_company2($company_r, $company_ref, 6); if (count($arr_company) == 6) { $cnt --; } } //賃貸件数 $_SESSION["r_cnt"] = count($arr_company); return $arr_company; }