public function requestCashOut() { if (Efiwebsetting::getData('checkOAuth') == 'yes') { IMBAuth::checkOAuth(); } $idResto = Generic::mustCheck($_GET['id_restaurant'], "No ID Restaurant Found"); $amount = Generic::mustCheck($_GET['amount'], "No Amount Found"); if ($amount == "0") { Generic::errorMsg("Zero Amount not Allowed"); } $bankAcc = new RestoBankAccModel(); $arrBank = $bankAcc->getWhere("id_restaurant='{$idResto}'"); if (count($arrBank) <= 0) { Generic::errorMsg("You Have Not Set Your Cash Out Account"); } $req = new MasterCashOutRequestModel(); $arrReq = $req->getWhere("id_restaurant='{$idResto}' AND status='0'"); if (count($arrReq) > 0) { Generic::errorMsg("You Already Request Cash Out"); } $resto = new MasterRestaurantModel(); $resto->getByID($idResto); $cashOut = new MasterCashOutRequestModel(); $cashOut->id_restaurant = $idResto; $cashOut->datetime_request = leap_mysqldate(); $cashOut->amount = $amount; $cashOut->status = 0; $idNewRequest = $cashOut->save(); $tr = new MasterRestoTransactionModel(); $tr->id_request = $idNewRequest; $tr->id_restaurant = $idResto; $tr->gross_amount = (double) $amount * -1; $tr->net_amount = (double) $amount * -1; $tr->approved = "0"; $tr->type_transaction = "2"; $tr->datetime_transaction = leap_mysqldate(); $tr->mr_fee = 0; $tr->credit_card_fee = 0; $tr->other_fee = 0; $tr->bank_disc = 0; $tr->save(); $json['status_code'] = 1; $json['results']['messages'] = "success"; echo json_encode($json); die; }
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; }