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;
}
function usedSpace($curProjId = NULL, $company_id = SES_COMP)
{
App::import('Model', 'CaseFile');
$CaseFile = new CaseFile();
$CaseFile->recursive = -1;
$cond = " 1 ";
if ($company_id) {
$cond .= " AND company_id=" . $company_id;
}
if ($curProjId) {
$cond .= " AND project_id=" . $curProjId;
}
$sql = "SELECT SUM(file_size) AS file_size FROM case_files WHERE " . $cond;
$res1 = $CaseFile->query($sql);
$filesize = $res1['0']['0']['file_size'] / 1024;
return number_format($filesize, 2);
}
/**
* This method gets the total storage used by user.
*
* @author Orangescrum
* @method ajax_getStorage
* @param
* @return string
*/
function ajax_getStorage()
{
App::import('Model', 'CaseFile');
$CaseFile = new CaseFile();
$usedspace = $CaseFile->getStorage();
echo $usedspace;
exit;
}
function betauser_limitation()
{
App::import('Model', 'UserSubscription');
$usersubscription = new UserSubscription();
$limitation = $usersubscription->find('first', array('conditions' => array('company_id' => SES_COMP), 'order' => 'id DESC'));
$GLOBALS['Userlimitation'] = $limitation['UserSubscription'];
$GLOBALS['user_subscription'] = $limitation['UserSubscription'];
$this->set("user_subscription", $limitation['UserSubscription']);
if ($limitation['UserSubscription']['subscription_id'] == 1 || $limitation['UserSubscription']['subscription_id'] == 9) {
$GLOBALS['FREE_SUBSCRIPTION'] = 1;
}
//$this->set('sub_limitation',$limitation['UserSubscription']);
//echo $this->projcetcount(SES_COMP,$limitation)."====".$this->milestonecount(SES_COMP,$limitation)."--".$this->usercount(SES_COMP,$limitation);
$this->set('rem_projects', $this->projcetcount(SES_COMP, $limitation));
$this->set('rem_milestone', $this->milestonecount(SES_COMP, $limitation));
$this->set('rem_users', $this->usercount(SES_COMP, $limitation));
App::import('Model', 'CaseFile');
$cmpusr = new CaseFile();
$usedspace = $cmpusr->getStorage();
$this->set('used_storage', $usedspace);
$GLOBALS['usedspace'] = $usedspace;
if (isset($limitation['UserSubscriptions']['storage_limit']) && (strtolower($limitation['UserSubscriptions']['storage_limit']) == 'unlimited' || $limitation['UserSubscription']['is_free'])) {
$this->set('remspace', 'Unlimited');
$GLOBALS['remspace'] = 'Unlimited';
} elseif (isset($limitation['UserSubscriptions']['storage_limit']) && $usedspace <= $limitation['UserSubscriptions']['storage_limit']) {
$this->set('remspace', $limitation['UserSubscriptions']['storage_limit'] - $usedspace);
$GLOBALS['remspace'] = $limitation['UserSubscriptions']['storage_limit'] - $usedspace;
} else {
$GLOBALS['remspace'] = 0;
$this->set('remspace', 0);
}
//echo "Deal count=".$rem_deal_count."--Contact = ".$rem_contact_count."--User = "******"-Total Used Space:-".$totalused;exit;
}
