} 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` ";
<?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);