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