public function getCurrentCredits()
{
if (Efiwebsetting::getData('checkOAuth') == 'yes') {
IMBAuth::checkOAuth();
}
$idResto = Generic::mustCheck($_GET['id_restaurant'], "No ID Restaurant Found");
global $db;
$rt = new MasterRestoTransactionModel();
$q = "SELECT IFNULL(SUM(gross_amount),0) AS gross_amount,IFNULL(SUM(net_amount),0) AS net_amount FROM {$rt->table_name} WHERE id_restaurant='{$idResto}' AND approved='1'";
$arrTrans = $db->query($q, 2);
$result['gross_amount'] = (double) $arrTrans[0]->gross_amount;
$result['net_amount'] = (double) $arrTrans[0]->net_amount;
$r = new MasterCashOutRequestModel();
$arr = $r->getWhere("id_restaurant= '{$idResto}' AND status='0'");
$result['has_pending_request'] = count($arr) <= 0 ? false : true;
$result['pending_amount'] = count($arr) <= 0 ? (double) 0 : (double) $arr[0]->amount;
$json['status_code'] = 1;
$json['results'] = $result;
echo json_encode($json);
die;
}
public function setCashOutPaid()
{
$idRequest = Generic::mustCheck($_GET['id_request'], "Required ID Request");
$cashOutModel = new MasterCashOutRequestModel();
$cashOutModel->getByID($idRequest);
$restoTrans = new MasterRestoTransactionModel();
$arrRestoTrans = $restoTrans->getWhere("type_transaction = '2' AND id_request = '{$idRequest}'");
if (count($arrRestoTrans) <= 0) {
Generic::errorMsg("Transaction not found");
}
if ($cashOutModel->status == "1") {
Generic::errorMsg("This Request Already Paid");
}
$rt = new MasterRestoTransactionModel();
$rt->getByID($arrRestoTrans[0]->id_transaction);
$rt->approved = "1";
$rt->save();
$cashOutModel->status = "1";
$cashOutModel->save();
$json['status_code'] = 1;
$json['status_message'] = "Request status set to Paid";
echo json_encode($json);
die;
}
