Esempio n. 1
0
         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];
}
Esempio n. 3
0
/** ▼ * 顧客企業データのバックアップ ***/
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';
}