function checkCaseFile($caseid)
 {
     App::import('Model', 'CaseFile');
     $CaseFile = new CaseFile();
     $CaseFile->recursive = -1;
     $caseFiles = $CaseFile->find('count', array('conditions' => array('CaseFile.easycase_id' => $caseid, 'CaseFile.comment_id !=' => 0, 'CaseFile.isactive' => 1), 'fields' => 'DISTINCT CaseFile.id'));
     return $caseFiles;
 }
예제 #2
0
 function getAllCaseFiles($pid, $cno)
 {
     if (!$pid || !$cno) {
         return false;
     }
     App::import('Model', 'CaseFile');
     $CaseFile = new CaseFile();
     $CaseFile->bindModel(array('belongsTo' => array('Easycase' => array('className' => 'Easycase', 'foreignKey' => 'easycase_id'))), false);
     $filesArr = $CaseFile->find('all', array('conditions' => array('Easycase.project_id' => $pid, 'Easycase.case_no' => $cno, 'CaseFile.isactive' => 1), 'fields' => array('CaseFile.id', 'CaseFile.file', 'CaseFile.file_size', 'CaseFile.downloadurl', 'Easycase.actual_dt_created'), 'order' => array('Easycase.actual_dt_created DESC', 'CaseFile.file ASC')));
     return $filesArr;
 }