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; }