Пример #1
0
} else {
    #JASのクライアントIDがない場合
    $rkw_rclid = jas_account_save($rowItem['accountid']);
}
//End if
$rkw_client = $rowItem['accountname'];
#exit;
//顧客担当者ID(contactid)
//$rowItem['rcm_id']の値があるかどうか
if ((int) $rowItem['rcm_id'] !== 0) {
    #担当者IDが保存されているとき
    $rkw_rcmid = $rowItem['rcm_id'];
} elseif ((int) $rowItem['contactid'] !== 0) {
    #担当者IDがない場合
    //JASに担当者情報を保存する
    $rkw_rcmid = jas_contact_save($rowItem['contactid']);
} else {
    $rkw_rcmid = 0;
}
//End if
/** ▼ キーワードIDの取得 ***/
$queryItem2 = " SELECT ";
$queryItem2 .= " `vtiger_products`.`seo_kwid` AS rkw_id_1, ";
$queryItem2 .= " \t`vtiger_products`.`productcategory`, ";
$queryItem2 .= " \t`vtiger_service`.`seo_kwid` AS rkw_id_2, ";
$queryItem2 .= " \t`vtiger_service`.`servicecategory`, ";
$queryItem2 .= " \t`vtiger_inventoryproductrel`.`productid` AS item_id ";
$queryItem2 .= " FROM  ";
$queryItem2 .= "  `vtiger_inventoryproductrel` ";
$queryItem2 .= "   LEFT JOIN `vtiger_products`  ON  ";
$queryItem2 .= "   `vtiger_inventoryproductrel`.`productid` = `vtiger_products`.`productid` ";
Пример #2
0
<?php

//月額固定の登録・更新
// テスト
#ini_set('include_path', '/var/www/vtigercrm');
#require_once('include/utils/utils.php');
#require_once('include/logging.php');
// テスト
require_once 'cin/defalut.php';
require_once 'cin/common/client_common.php';
require_once 'cin/common/charger_common.php';
#$contactid = 12793;
jas_contact_save($contactid);