<?php
/* +**********************************************************************************
 * The contents of this file are subject to the vtiger CRM Public License Version 1.1
 * ("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.
 * ***********************************************************************************/

function vtws_getfileslist($inn, $sms, $user) {
	$logstring = date('Y-m-d H:i:s').' - запрос с ИНН '.$inn.', SMS: '.$sms.PHP_EOL;
	file_put_contents('logs/GetFilesList.log', $logstring, FILE_APPEND);
	
	global $adb;
	
	if(empty($inn)){
		throw new WebServiceException(WebServiceErrorCode::$INVALIDID,"ИНН не указан");
	}
	
	if(empty($sms)){
		throw new WebServiceException(WebServiceErrorCode::$INVALIDID,"СМС-код не указан");
	}
	
	$output = array();
	$query = 'select c.contactid, e.createdtime
				from vtiger_contactscf c
				left join vtiger_crmentity e on e.crmid = c.contactid 
				where e.deleted = 0 and c.cf_1257 = "'.$inn.'" and c.cf_1706 = "'.$sms.'" order by 2 desc';
	$result = $adb->pquery($query);
	
	if ($adb->num_rows($result) == 0) {
		$logstring = date('Y-m-d H:i:s').' - Клиент не найден'.PHP_EOL;
		file_put_contents('logs/GetFilesList.log', $logstring, FILE_APPEND);
		
		$output['status'] = 'failed';
		$output['message'] = 'Клиент с указанным СМС-кодом и ИНН не найден';
	} else {
		$output['status'] = 'ok';
		$output['files'] = array();
		$contactid = $adb->query_result($result, 0, 'contactid');
		$logstring = date('Y-m-d H:i:s').' - Клиент найден. Его id - '.$contactid.', поищем его файлы'.PHP_EOL;
		file_put_contents('logs/GetFilesList.log', $logstring, FILE_APPEND);
		$query = 'select n.title, a.path, a.storedname, s.attachmentsid 
					from vtiger_senotesrel r
					left join vtiger_notes n on n.notesid = r.notesid
					left join vtiger_seattachmentsrel s on s.crmid = r.notesid
					left join vtiger_attachments a on a.attachmentsid = s.attachmentsid 
					where r.crmid = '.$contactid;
		$result = $adb->pquery($query);
		
		if ($adb->num_rows($result) > 0) {
			$logstring = date('Y-m-d H:i:s').' - найдено файлов: '.$adb->num_rows($result).PHP_EOL;
			file_put_contents('logs/GetFilesList.log', $logstring, FILE_APPEND);
			
			for ($i=0; $i<$adb->num_rows($result); $i++) {
				$output['files'][$i]['title'] = $adb->query_result($result, $i, 'title');
				$output['files'][$i]['path'] = $adb->query_result($result, $i, 'path').$adb->query_result($result, $i, 'attachmentsid').'_'.$adb->query_result($result, $i, 'storedname');
			}
		} else {
			$logstring = date('Y-m-d H:i:s').' - файлов у клиента нет'.PHP_EOL;
			file_put_contents('logs/GetFilesList.log', $logstring, FILE_APPEND);
		}
	}
	
	return $output;
}