function verify_domain_by_url($url)
{
// echo "<br/>$url: [".$url."]";
$certificate_chain_length = load_certificate_chain($url);
$result_array = get_chain_verification_results($certificate_chain_length, $url);
$verification_result = verify_chain($result_array) ? "PASS" : "FAIL";
$result = get_company_data($url);
$result['verification_result'] = $verification_result;
$url_matching = match_urls(get_domain_from_url($url), $result['company_url']);
$result['url_matching'] = $url_matching;
// unset($result['company_url']); # we don't need it anymore after matching
return $result;
}
function db_entry($gc) {
$gc->db->begin_tran();
//新規追加処理
$sql = "INSERT INTO t_item (";
$sql.= " anken_no,";
$sql.= " relocation_flg,";
$sql.= " chintai_flg,";
$sql.= " sublease_flg,";
$sql.= " purpose_flg,";
$sql.= " buken_sbt,";
$sql.= " buken_shikucyouson_no,";
$sql.= " buken_banchi,";
$sql.= " buken_tatemono,";
$sql.= " chikunensu,";
$sql.= " menseki,";
$sql.= " input_val,";
$sql.= " input_kbn,";
$sql.= " land_val,";
$sql.= " madori_no,";
$sql.= " meigi_no,";
$sql.= " genjyou_no,";
$sql.= " room_cnt,";
$sql.= " fudousan_flg,";
$sql.= " fudousan_nm,";
$sql.= " bikou,";
$sql.= " lname,";
$sql.= " fname,";
$sql.= " lname_kn,";
$sql.= " fname_kn,";
$sql.= " tel,";
$sql.= " e_mail,";
$sql.= " sumai_flg,";
$sql.= " sumai_shikucyouson_no,";
$sql.= " sumai_banchi,";
$sql.= " sumai_tatemono,";
$sql.= " moushikomibi,";
$sql.= " rank_no,";
$sql.= " tesuryou,";
$sql.= " mukou_flg,";
$sql.= " ltime";
$sql.= ") VALUES (";
$sql.= "'未確定',";
$sql.= f_bool_edit_db($_POST["relocation_flg"], "0").",";
$sql.= f_bool_edit_db($_POST["chintai_flg"], "0").",";
$sql.= f_bool_edit_db($_POST["sublease_flg"], "0").",";
$sql.= f_num_edit_db($_POST["purpose_flg"], "0").",";
$sql.= f_num_edit_db($_POST["buken_sbt"], "0").",";
$sql.= f_num_edit_db($_POST["shikucyouson_no"]).",";
$sql.= "'".f_dbs($_POST["buken"].$_POST["banchi"])."',";
$sql.= "'".f_dbs($_POST["buken_tatemono"].$_POST["buken_heya"])."',";
$sql.= f_num_edit_db($_POST["chikunensu"], "0.00").",";
$sql.= f_num_edit_db($gc->menseki, "0.00").",";
$sql.= "'".f_dbs($_POST["input_val"])."',";
$sql.= f_num_edit_db($_POST["input_kbn"], "0").",";
$sql.= f_num_edit_db($_POST["land_val"], "0").",";
$sql.= f_num_edit_db($_POST["madori_no"], "0").",";
$sql.= f_num_edit_db($_POST["meigi_no"], "0").",";
$sql.= f_num_edit_db($_POST["genjyou_no"], "0").",";
$sql.= f_num_edit_db($_POST["room_cnt"], "0").",";
$sql.= f_bool_edit_db($_POST["fudousan_flg"], "0").",";
$sql.= "'".f_dbs($_POST["fudousan_nm"])."',";
$sql.= "'".f_dbs($_POST["bikou"])."',";
$sql.= "'".f_dbs($_POST["lname"])."',";
$sql.= "'".f_dbs($_POST["fname"])."',";
$sql.= "'".f_dbs($_POST["lname_kn"])."',";
$sql.= "'".f_dbs($_POST["fname_kn"])."',";
$sql.= "'".f_dbs($_POST["tel1"]."-".$_POST["tel2"]."-".$_POST["tel3"])."',";
$sql.= "'".f_dbs($_POST["e_mail"])."',";
$sql.= f_num_edit_db($_POST["sumai_flg"], "0").",";
$sql.= f_num_edit_db($_POST["sumai_shikucyouson_no"]).",";
$sql.= "'".f_dbs($_POST["sumai_banchi"])."',";
$sql.= "'".f_dbs($_POST["sumai_tatemono"])."',";
$sql.= "CURRENT_TIMESTAMP,";
$sql.= f_num_edit_db($gc->rank, "0").",";
$sql.= f_num_edit_db($gc->tesuryou, "0").",";
$sql.= "0,";
$sql.= "CURRENT_TIMESTAMP)";
$ret = $gc->db->execute($sql, true);
if($ret["errno"] > 0){
$gc->db->rollback();
$gc->msg->add("大変申し訳ございません申し込みができませんでした。");
return false;
}
$gc->item_no = $gc->db->get_last_id();
$buken_sbt = f_num_edit_db($_POST["buken_sbt"], "0");
$wk_anken_no = get_anken_no($gc, $buken_sbt, $gc->item_no);
$sql = "UPDATE t_item SET";
$sql.= " anken_no = '".$wk_anken_no."' ";
$sql.= "WHERE";
$sql.= " item_no = ".$gc->item_no;
$ret = $gc->db->execute($sql, true);
if($ret["errno"] > 0){
$gc->db->rollback();
$gc->msg->add("大変申し訳ございません申し込みができませんでした。");
return false;
}
$cpn_data = get_company_data($gc,$_POST["shikucyouson_no"]);
for ($i = 0; $i < count($gc->arr_company); $i++) {
$company_no = $gc->arr_company[$i];
if(!is_numeric($company_no)){
$company_no = 0;
}
$arr_company_kbn = $_POST["arr_company_kbn"];
if($arr_company_kbn[$company_no] == "relocation"){
$kubun_nm = "リロケーション";
}elseif($arr_company_kbn[$company_no] == "chintai"){
$kubun_nm = "賃貸募集・賃貸管理";
}elseif($arr_company_kbn[$company_no] == "sublease"){
$kubun_nm = "サブリース";
}
$sql = "INSERT INTO t_item_company (";
$sql.= " item_no,";
$sql.= " company_no,";
$sql.= " kubun_nm";
$sql.= ") VALUES (";
$sql.= $gc->item_no.",";
$sql.= $company_no.",";
$sql.= "'".f_dbs($kubun_nm)."')";
$ret = $gc->db->execute($sql, true);
if($ret["errno"] > 0){
$gc->db->rollback();
$gc->msg->add("大変申し訳ございません申し込みができませんでした。");
return false;
}
if(($_POST["purpose_flg"] == 1) && ($cpn_data[$company_no]["light_flg"] > 0) && ($cpn_data[$company_no]["plan_flg"] == 1 || $cpn_data[$company_no]["plan_flg"] == 3)){
$cpn_data[$company_no]["light_flg"] = $cpn_data[$company_no]["light_flg"];
}else{
$cpn_data[$company_no]["light_flg"] = 0;
}
$ret = set_tesuryo_table($gc,$gc->item_no,$company_no,$cpn_data[$company_no]["light_flg"],$cpn_data[$company_no]["kotei_flg"],$cpn_data[$company_no]["shikucyouson_kingaku"],"CURRENT_TIMESTAMP",f_num_edit_db($gc->rank, "0"));
if($ret["errno"] > 0){
$gc->db->rollback();
$gc->msg->add("大変申し訳ございません申し込みができませんでした。");
return false;
}
}
$gc->db->commit();
send_mail($gc);
return true;
}
