public static function getFeePercentCreditCard($id_restaurant, $id_bank)
{
$objFeeModel = new BankFeeModel();
$arrFeeBank = $objFeeModel->getWhere("id_restaurant='{$id_restaurant}' AND id_bank='{$id_bank}' AND start_fee <= CURDATE() AND end_fee >= CURDATE() ");
if (count($arrFeeBank) > 0) {
return $arrFeeBank[0]->fee;
} else {
return 0;
}
}
public function updateRestoCCFee()
{
$idsResto = Generic::mustCheck($_POST['id_restaurant'], "No Restaurant IDs Found");
$fee = Generic::mustCheck($_POST['fee'], "No Fee Found");
$idBank = Generic::mustCheck($_POST['id_bank'], "No ID Bank Found");
if (!is_numeric($fee)) {
Generic::errorMsg("Fee Must Numbers");
}
if (doubleval($fee) > 100) {
Generic::errorMsg("Fee Max 100%");
}
$ids = explode(',', $idsResto);
if (count($ids) <= 0) {
Generic::errorMsg("Empty Id");
}
$updateAll = in_array('0', $ids);
if ($updateAll) {
$r = new MasterRestaurantModel();
$arrResto = $r->getAll();
foreach ($arrResto as $resto) {
unset($bf);
unset($arrBankFee);
$bf = new BankFeeModel();
$arrBankFee = $bf->getWhere("id_bank='{$idBank}' AND id_restaurant='{$resto->id_restaurant}'");
if (count($arrBankFee) <= 0) {
unset($bFee);
$bFee = new BankFeeModel();
$bFee->id_bank = $idBank;
$bFee->id_restaurant = $resto->id_restaurant;
unset($log);
$log = new LogDiscFeeModel();
$log->id_reference = $resto->id_restaurant . "," . $idBank;
$log->change_type = "Fee Credit Card";
$log->change_from = Generic::IsNullOrEmptyString($bFee->fee) ? "0" : $bFee->fee;
$log->change_to = $fee;
$log->change_date_time = leap_mysqldate();
$log->save();
$bFee->fee = $fee;
$bFee->last_changed = leap_mysqldate();
$bFee->save();
} else {
unset($log);
$log = new LogDiscFeeModel();
$log->id_reference = $resto->id_restaurant . "," . $idBank;
$log->change_type = "Fee Credit Card";
$log->change_from = Generic::IsNullOrEmptyString($arrBankFee[0]->fee) ? "0" : $arrBankFee[0]->fee;
$log->change_to = $fee;
$log->change_date_time = leap_mysqldate();
$log->save();
$arrBankFee[0]->fee = $fee;
$arrBankFee[0]->last_changed = leap_mysqldate();
}
}
} else {
foreach ($ids as $id) {
unset($bf);
unset($arrBankFee);
$bf = new BankFeeModel();
$arrBankFee = $bf->getWhere("id_bank='{$idBank}' AND id_restaurant='{$id}'");
if (count($arrBankFee) <= 0) {
unset($bFee);
$bFee = new BankFeeModel();
$bFee->id_bank = $idBank;
$bFee->id_restaurant = $id;
unset($log);
$log = new LogDiscFeeModel();
$log->id_reference = $id . "," . $idBank;
$log->change_type = "Fee Credit Card";
$log->change_from = Generic::IsNullOrEmptyString($bFee->fee) ? "0" : $bFee->fee;
$log->change_to = $fee;
$log->change_date_time = leap_mysqldate();
$log->save();
$bFee->fee = $fee;
$bFee->last_changed = leap_mysqldate();
$bFee->save();
} else {
unset($log);
$log = new LogDiscFeeModel();
$log->id_reference = $id . "," . $idBank;
$log->change_type = "Fee Credit Card";
$log->change_from = Generic::IsNullOrEmptyString($arrBankFee[0]->fee) ? "0" : $arrBankFee[0]->fee;
$log->change_to = $fee;
$log->change_date_time = leap_mysqldate();
$log->save();
$arrBankFee[0]->fee = $fee;
$arrBankFee[0]->last_changed = leap_mysqldate();
}
}
}
$json['status_code'] = 1;
$json['status_message'] = "success";
echo json_encode($json);
die;
}
