ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / letacommog / crmleta / modules / Mobile / api / ws

<?php
/*+**********************************************************************************
 * The contents of this file are subject to the vtiger CRM Public License Version 1.0
 * ("License"); You may not use this file except in compliance with the License
 * The Original Code is:  vtiger CRM Open Source
 * The Initial Developer of the Original Code is vtiger.
 * Portions created by vtiger are Copyright (C) vtiger.
 * All Rights Reserved.
 ************************************************************************************/

include_once 'include/Webservices/DescribeObject.php';
include_once 'include/Webservices/Query.php';

class Mobile_WS_FetchReferenceRecords extends Mobile_WS_Controller {
    
    function process(Mobile_API_Request $request) {
        
        $response = new Mobile_API_Response();
		$current_user = $this->getActiveUser();
        
        //fetch reference records request params
        $referenceModule = $request->get('module');
        $searchKey = $request->get('searchValue');
        
        if($referenceModule=='Documents') {
            $labelFields = 'notes_title';
        } else if($referenceModule=='HelpDesk') {
            $labelFields = 'ticket_title';
        } else {
            $describe = vtws_describe($referenceModule, $current_user);
            $labelFields = $describe['labelFields'];
        }
        
        $labelFieldsArray = explode(',', $labelFields);
        
        $sql = sprintf("SELECT %s FROM %s WHERE ",$labelFields,$referenceModule);
        
        foreach($labelFieldsArray as $labelField) {
            
            $sql .= $labelField . " LIKE '%" . $searchKey . "%' OR ";
        }
        $sql = rtrim($sql,' OR ') . ';';

$wsresult = vtws_query($sql,$current_user);
        
        $referenceRecords = array();
        foreach($wsresult as $result) {
            $record = array();
            foreach($labelFieldsArray as $labelField) {
                $record['label'] .= $result[$labelField] . ' ';
            }
            $record['label'] = trim($record['label']);
            $record['value'] = decode_html($result['id']);
            $referenceRecords[] = $record;
        }
        
        $response->setResult($referenceRecords);
        return $response;
    }
    
}
?>

[+] ..
[-] Login.php [edit]
[-] FetchModules.php [edit]
[-] TaxByType.php [edit]
[-] Describe.php [edit]
[-] FetchReferenceRecords.php [edit]
[+] models
[-] Query.php [edit]
[-] SaveRecord.php [edit]
[-] FetchModuleFilters.php [edit]
[-] Logout.php [edit]
[-] Controller.php [edit]
[-] FetchModuleOwners.php [edit]
[-] History.php [edit]
[-] AddRecordComment.php [edit]
[-] ListModuleRecords.php [edit]
[-] UserInfo.php [edit]
[-] FetchAllAlerts.php [edit]
[-] RelatedRecordsWithGrouping.php [edit]
[-] FetchRecordWithGrouping.php [edit]
[-] FetchRecordsWithGrouping.php [edit]
[-] FilterDetailsWithCount.php [edit]
[-] LoginAndFetchModules.php [edit]
[-] SyncModuleRecords.php [edit]
[-] DeleteRecords.php [edit]
[-] FetchRecord.php [edit]
[-] Utils.php [edit]
[-] AlertDetailsWithMessage.php [edit]
[-] QueryWithGrouping.php [edit]