break; } //End switch #exit; /* ▼ * JASのキーワードのクライアントID、クライアント名、顧客担当IDのひもづけ *******/ if ((int) $intKwId !== 0) { require 'cin/SQLConnect_jas.php'; /** ▼ ** キーワードの履歴を保存する ****/ foreach ($arrRkw as $rkw_fields_name => $strRkwValue) { unset($_POST[$rkw_fields_name]); $_POST[$rkw_fields_name] = $strRkwValue; } //End foreach $_POST[rkw_create_datetime] = date('Y-m-d H:i:s'); print "Insert : " . DataInsertString('backup_keyword') . "<br /><br />"; DataInsert('backup_keyword'); //初期化 foreach ($arrRkw as $rkw_fields_name => $strRkwValue) { unset($_POST[$rkw_fields_name]); } //End foreach /** ▲ ** キーワードの履歴を保存する ****/ require 'cin/SQLConnect_jas.php'; $sqlUpdate = " UPDATE rank_keyword SET "; if ($rkw_rclid) { $sqlUpdate .= " rkw_rclid = {$rkw_rclid}, "; } if ($rkw_rcmid) { $sqlUpdate .= " rkw_rcmid = {$rkw_rcmid}, "; } if ($rkw_client) {
function jas_products_save($productid, $salesorderflag) { $arrrUrlStrict = array("part" => "0", "部分一致(下層ページも課金対象)" => "0", "domain" => "1", "ドメイン一致" => "1", "perfect" => "2", "完全一致" => "2", "文字のマッチ" => "3", "文字マッチ" => "3", "character" => "3"); $queryItem = " SELECT * FROM `vtiger_products` "; $queryItem .= " LEFT JOIN `vtiger_account` ON `seo_agency_customers` = `accountid`"; $queryItem .= " WHERE TRUE "; $queryItem .= " AND productid = {$productid} "; $queryItem .= " AND productcategory = 'SEO' "; print $queryItem . "<br /><br />"; global $adb; $resultItem = $adb->pquery($queryItem); $countItemNum = $adb->num_rows($resultItem); $rowItem = $adb->fetch_array($resultItem); #if($countItemNum === 0) return false; #print "コメントあうとしてね<br /><br />"; if (is_null($rowItem[seo_keyword]) || is_null($rowItem[seo_url])) { return false; } #キーワード、URLどちらかが空で合った場合、登録・変更しない //KwIDの取得(基幹) $arrKeywordInfo['rkw_id'] = (int) $rowItem['seo_kwid']; #Kwid /** ▼ JASへの代理店顧客情報保存準備 ****/ if ((int) $rowItem['seo_agency_customers'] !== 0) { #代理店顧客があるとき if ($rowItem['jgid'] == false) { //JASに代理店顧客情報がないので登録する $_POST['agencyflag'] = true; $arrKeywordInfo['rkw_child_cliid'] = jas_account_save($rowItem['accountid']); $arrKeywordInfo['rkw_child_client'] = $rowItem['accountname']; } else { $arrKeywordInfo['rkw_child_cliid'] = $rowItem['jgid']; $arrKeywordInfo['rkw_child_client'] = $rowItem['accountname']; } //End if } else { #代理店顧客がないとき $arrKeywordInfo['rkw_child_cliid'] = 0; $arrKeywordInfo['rkw_child_client'] = ""; } //End if /** ▲ JASへの代理店顧客情報保存準備 ****/ #rkw_word キーワード名 $arrKeywordInfo['rkw_word'] = $rowItem['seo_keyword']; #rkw_url $arrKeywordInfo['rkw_url'] = $rowItem['seo_url']; #$arrKeywordInfo['rkw_resistdate'] = date('Y-m-d'); #rkw_contract_startdate 契約期間開始日 $arrKeywordInfo['rkw_contract_startdate'] = $rowItem['start_date']; #rkw_contract_enddate 契約期間終了日 $arrKeywordInfo['rkw_contract_enddate'] = $rowItem['expiry_date']; #rkw_url_strict 順位チェック方法 $arrKeywordInfo['rkw_url_strict'] = $arrrUrlStrict[$rowItem['seo_rank_check']]; #rkw_away_flag 解約処理 if ((int) $rowItem['seo_away_flag'] === 1) { #有効がいいえのとき $arrKeywordInfo['rkw_away_flag'] = 1; #JASの解約フラグをたてる } else { #それ以外(有効がはいのとき) $arrKeywordInfo['rkw_away_flag'] = 0; #JASの解約フラグを解除する } //End if #rkw_fee_month 月額固定金額 $arrKeywordInfo['rkw_fee_month'] = (int) preg_replace('@,@', '', $rowItem['unit_price']); print "KwId : " . $arrKeywordInfo['rkw_id'] . "<br />"; echo "<pre>"; var_dump($salesorderflag); var_dump($arrKeywordInfo); echo "</pre>"; /** ▼ JASへの反映 **/ if ($salesorderflag == true && $arrKeywordInfo['rkw_id'] === 0) { #JASにKWが登録されているとき /** ▼ JASのキーワードデータの追加 *****/ #rkw_input_flag キーワード内訳 $arrKeywordInfo['rkw_input_flag'] = 1; #rkw_segment セグメント $arrKeywordInfo['rkw_segment'] = 1; #rkw_random_flag ランダムフラグ デフォルト値:1 $arrKeywordInfo['rkw_random_flag'] = 1; $arrKeywordInfo['rkw_fee_status'] = '固定'; $arrKeywordInfo['rkw_account_type'] = 4; foreach ($arrKeywordInfo as $rkw_fields_name => $strKeywordData) { $_POST[$rkw_fields_name] = $strKeywordData; } //End foreach //キーワードIDの初期化 unset($_POST['rkw_id']); print "Insert : " . DataJasInsertString('rank_keyword') . "<br /><br />"; $_POST['rkw_id'] = DataJasInsert('rank_keyword'); $queryInsert = " UPDATE `vtiger_products` SET "; $queryInsert .= " seo_kwid = {$_POST['rkw_id']} "; $queryInsert .= " WHERE TRUE "; $queryInsert .= " AND productid = {$productid} "; print $queryInsert . "<br /><br />"; global $adb; $adb->pquery($queryInsert); /** ▲ JASのキーワードデータの追加 *****/ } elseif ($arrKeywordInfo['rkw_id'] === 0) { #キーワードIDが0のときはなにもしない return false; } elseif ($module === 'Products' || $module === 'Services') { #製品登録のみキーワードの更新をおこなう /** ▼ JASのキーワードデータの更新 ***/ /** ▼ 変更前キーワード情報の取得 ****/ # require('cin/SQLConnect.php'); require 'cin/SQLConnect_jas.php'; $sqlRkw = "SELECT * FROM rank_keyword WHERE TRUE AND rkw_id = {$arrKeywordInfo['rkw_id']} "; print $sqlRkw . "<br /><br />"; $rsRkw = mysql_db_query($dbName, $sqlRkw); $rsCountRkw = mysql_num_rows($rsRkw); $rowRkw = mysql_fetch_array($rsRkw); $arrRkw = $rowRkw; if ((int) $rowRkw['rkw_account_type'] !== 4) { return false; } require 'cin/SQLClose.php'; /** ▲ 変更前キーワード情報の取得 ****/ /** ▼ ** キーワードの履歴を保存する ****/ foreach ($arrRkw as $rkw_fields_name => $strRkwValue) { unset($_POST[$rkw_fields_name]); $_POST[$rkw_fields_name] = $strRkwValue; } //End foreach $_POST[rkw_create_datetime] = date('Y-m-d H:i:s'); print "Insert : " . DataInsertString('backup_keyword') . "<br /><br />"; DataInsert('backup_keyword'); /** ▲ ** キーワードの履歴を保存する ****/ /** ▼ ** 変更後の反映 *********/ foreach ($arrKeywordInfo as $rkw_fields_name => $strKeywordData) { $_POST[$rkw_fields_name] = $strKeywordData; } //End foreach print "Update : " . DataJasUpdateString('rank_keyword') . "<br /><br />"; DataJasUpdate('rank_keyword'); /** ▲ ** 変更後の反映 **********/ /** ▲ JASのキーワードデータの更新 ***/ } //End if /** ▼ ** vitiger_crmentityへの契約期間を説明に反映 ***/ $queryUpdate = " UPDATE `vtiger_crmentity` SET "; $queryUpdate .= " description = CONCAT("; $queryUpdate .= " description, ' 契約期間:" . $arrKeywordInfo['rkw_contract_startdate'] . "~" . $arrKeywordInfo['rkw_contract_enddate'] . "' "; $queryUpdate .= " ) "; $queryUpdate .= " WHERE TRUE "; $queryUpdate .= " AND crmid = {$productid} "; print $queryUpdate . "<br /><br />"; global $adb; $adb->pquery($queryUpdate); /** ▲ ** vtiger_crmentityへの契約期間を説明の反映 ***/ registDomain($_POST[rkw_id]); return (int) $_POST[rkw_id]; }
/** ▼ * 顧客企業データのバックアップ ***/ function backupRankClientData($intRclId) { # require ('cin/SQLConnect.php'); require 'cin/SQLConnect_jas.php'; $sql = " SELECT * FROM rank_client "; $sql .= " WHERE TRUE "; $sql .= " AND rcl_id = " . $intRclId . " ;"; print $sql . "<br />"; $rs = mysql_db_query($dbName, $sql); $rsCount = mysql_num_rows($rs); $row = mysql_fetch_array($rs); require 'cin/SQLClose.php'; if ($rsCount !== 0) { foreach ($row as $rcl_fields_name => $strRclValue) { $_POST[$rcl_fields_name] = $strRclValue; } //End foreach $_POST[rcl_datetime] = date('Y-m-d H:i:s'); print DataInsertString('backup_rank_client') . "<br /><br />"; DataInsert('backup_rank_client'); } //End if foreach ($row as $rcl_fields_name => $strRclValue) { unset($_POST[$rcl_fields_name]); } //End foreach }
function registDomain($intRkwid = 0) { if ($intRkwid == 0) { return; } require 'cin/SQLConnect.php'; $sqlRkw = " SELECT rkw_id, rkw_domid, rkw_url, rkw_rclid FROM rank_keyword "; $sqlRkw .= " WHERE TRUE "; $sqlRkw .= " AND rkw_domid = 0 "; if ($intRkwid) { $sqlRkw .= " AND rkw_id = {$intRkwid} "; } $sqlRkw .= " AND rkw_url != '' "; print $sqlRkw . "<br />"; #exit; $rsRkw = mysql_db_query($dbName, $sqlRkw); $rsRkwCount = mysql_num_rows($rsRkw); if ($rsRkwCount) { for ($intRkw = 0; $intRkw < $rsRkwCount; $intRkw++) { $rowRkw = mysql_fetch_array($rsRkw); $strDomain = getUrlDomain3($rowRkw[rkw_url]); $sqlDom = " SELECT * FROM domain_mgt "; $sqlDom .= " WHERE TRUE "; $sqlDom .= " AND dom_domain = '{$strDomain}'"; $rsDom = mysql_db_query($dbName, $sqlDom); $rsCountDom = mysql_num_rows($rsDom); print $sqlDom . "<br />"; if (!$rsCountDom) { #ドメインが保存されていない場合 $_POST[dom_rclid] = $rowRkw[rkw_rclid]; $_POST[dom_registdate] = date('Y-m-d'); $_POST[dom_domain] = $strDomainName; print DataInsertString(domain_mgt) . "<br />"; $_POST[rkw_domid] = DataInsert(domain_mgt); $sqlUpDate = " UPDATE rank_keyword SET rkw_domid = {$_POST[rkw_domid]} "; $sqlUpDate .= " WHERE TRUE "; $sqlUpDate .= " AND rkw_id = {$intRkwid} "; # print $sqlUpDate . "<br />"; mysql_db_query($dbName, $sqlUpDate); } //End if } //End for } //End if require 'cin/SQLClose.php'; }