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