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 updateClientData($intRclId, $arrClientData) { backupRankClientData($intRclId); foreach ($arrClientData as $field_rank_client => $value_rank_client) { $_POST[$field_rank_client] = $value_rank_client; } //End foreach $_POST[rcl_id] = $intRclId; print DataJasUpdateString('rank_client') . "<br /><br />"; DataJasUpdate('rank_client'); # exit; }
function updateChargerMasData($intRcmId, $arrChargerMasData) { backupRankChargerData($intRcmId); foreach ($arrChargerMasData as $field_rank_charger_mas => $value_rank_charger_mas) { unset($_POST[$field_rank_charger_mas]); $_POST[$field_rank_charger_mas] = $value_rank_charger_mas; } //End foreach $_POST[rcm_id] = $intRcmId; print DataJasUpdateString('rank_charger_mas') . "<br /><br />"; DataJasUpdate('rank_charger_mas'); #exit; }