public function overwriteRead($return)
{
$objs = $return['objs'];
foreach ($objs as $obj) {
if (isset($obj->id_restaurant)) {
$resto = new MasterRestaurantModel();
$resto->getByID($obj->id_restaurant);
$obj->id_restaurant = $resto->name;
}
if (isset($obj->id_bank)) {
$bank = new BankModel();
$bank->getByID($obj->id_bank);
$obj->id_bank = $bank->bank_name;
}
if (isset($obj->start_fee)) {
$date = new DateTime($obj->start_fee);
$obj->start_fee = $date->format('d.m.Y');
}
if (isset($obj->end_fee)) {
$dateEnd = new DateTime($obj->end_fee);
$obj->end_fee = $dateEnd->format('d.m.Y');
}
}
return $return;
}
public function ListBankToEmail($param)
{
$dataset = parent::ListBankProcess($param);
$str = '';
foreach ($dataset as $var) {
$var['bk_name'] = $this->BankName($var['bk_code']);
$str .= '<p><b>' . $var['bk_name'] . '</b> สาขา' . $var['bk_account_branch'] . ' – ชื่อบัญชี ' . $var['bk_account_name'] . '<br><b>' . $var['bk_account_number'] . '</b></p>';
}
return $str;
}
public function overwriteRead($return)
{
$objs = $return['objs'];
$dateNow = new DateTime('now');
foreach ($objs as $obj) {
foreach ($obj as $key => $val) {
if ($key == "end") {
$datetimeEnd = new DateTime($val);
$interval = $dateNow->diff($datetimeEnd);
if ($dateNow->format("Y.m.d") > $datetimeEnd->format("Y.m.d")) {
}
if ($interval->format('%R%a') >= 1) {
} else {
}
}
}
if (isset($obj->id_restaurant)) {
$resto = new MasterRestaurantModel();
$resto->getByID($obj->id_restaurant);
$obj->id_restaurant = $resto->name;
}
if (isset($obj->id_bank)) {
$bank = new BankModel();
$bank->getByID($obj->id_bank);
$obj->id_bank = $bank->bank_name;
}
if (isset($obj->start)) {
$date = new DateTime($obj->start);
$obj->start = $date->format('d.m.Y');
}
if (isset($obj->end)) {
$dateEnd = new DateTime($obj->end);
$obj->end = $dateEnd->format('d.m.Y');
}
?>
<script>
$(document).ready(function () {
var date = new Date();
var i = 1;
while ($('#id_bank_discount_' + i).text().trim()) {
var dateEndNow = $('#end_' + i).text().trim();
var dt1 = parseInt(dateEndNow.substring(0, 2));
var mon1 = parseInt(dateEndNow.substring(3, 5));
var yr1 = parseInt(dateEndNow.substring(6, 10));
var dateEnd = new Date(yr1, mon1 - 1, dt1);
var diff = dateEnd - date, sign = diff < 0 ? -1 : 1, milliseconds, seconds, minutes, hours, days;
diff = (diff - (milliseconds = diff % 1000)) / 1000;
diff = (diff - (seconds = diff % 60)) / 60;
diff = (diff - (minutes = diff % 60)) / 60;
days = (diff - (hours = diff % 24)) / 24;
if(days <2){
$("#BankDiscountModel_" + i).css("background-color", "red");
}
else{
$("#BankDiscountModel_" + i).css("background-color", "yellow");
}
i = i + 1;
}
});
</script>
<?php
}
?>
<style>
.table{
background-color: red;
}
#BankDiscountModel_1{
background-color: red;
}
#BankDiscountModel_{
background-color: greenyellow;
}
</style>
<?php
return $return;
}
public static function saveUserPaymentDetails($dokuResult, $idUser)
{
$user = new UserModel();
$user->getByID($idUser);
$bundleToken = $dokuResult->res_bundle_token;
$user->payment_token = $bundleToken['res_token_payment'];
$user->payment_mcn = $dokuResult->res_mcn;
$user->payment_bank = $dokuResult->res_bank;
$user->credit += Efiwebsetting::getData('credit_card_initial_amount');
$bank = new BankModel();
$aBank = $bank->getWhere("bank_name='{$dokuResult->res_bank}' LIMIT 1");
if (count($aBank) <= 0) {
$bank = new BankModel();
$bank->bank_name = $dokuResult->res_bank;
$bank->bank_identifier = Keys::$EMPTY;
$user->payment_bank_id = $bank->save();
} else {
$user->payment_bank_id = $aBank[0]->id_bank;
}
$user->save();
}
public function setupFeeCreditCard()
{
$resto = new MasterRestaurantModel();
$arrResto = $resto->getWhere("id_restaurant!='0' ORDER BY name ASC");
?>
<div class="col-sm-12">
<h1>Setup Fee Credit Card</h1>
</div>
<div id="formgroup_restaurant" class="form-group">
<label for="restaurant_cc_fee_choices" class=" col-sm-2 control-label">restaurant</label>
<div class="col-sm-8">
<select class="form-control" name="restaurant_cc_fee_choices" id="restaurant_cc_fee_choices">
<option value="-1">Select Restaurant</option>
<option value="0">All Restaurant</option>
<?php
foreach ($arrResto as $r) {
if (Generic::IsNullOrEmptyString($r->name)) {
continue;
}
?>
<option value="<?php
echo $r->id_restaurant;
?>
"><?php
echo $r->name;
?>
</option>
<?php
}
?>
</select>
<span class="help-block" id="warning_voided"></span>
</div>
<div class="col-sm-2">
<button type="button" id="button_select_resto_cc_fee" class="btn btn-default" style="width: 100%;">Add
</button>
</div>
<div class="clearfix"></div>
</div>
<div id="formgroup_selected_restaurant" class="form-group">
<label for="selected_restaurant_cc_fee" class=" col-sm-2 control-label">Selected Restaurant</label>
<div class="col-sm-10">
<input type="text" name="selected_restaurant_cc_fee" id="selected_restaurant_cc_fee"
class="form-control">
<span class="help-block" id="warning_id_user"></span>
</div>
<div class="clearfix"></div>
</div>
<div id="formgroup_restaurant" class="form-group">
<label for="bank_choices_cc_fee" class=" col-sm-2 control-label">Bank</label>
<div class="col-sm-10">
<select class="form-control" name="bank_choices_cc_fee" id="bank_choices_cc_fee">
<option value="-1">Select Bank</option>
<?php
$ba = new BankModel();
$arrBank = $ba->getAll();
foreach ($arrBank as $r) {
if (Generic::IsNullOrEmptyString($r->bank_name)) {
continue;
}
?>
<option value="<?php
echo $r->id_bank;
?>
"><?php
echo $r->bank_name;
?>
</option>
<?php
}
?>
</select>
<span class="help-block" id="warning_voided"></span>
</div>
<div class="clearfix"></div>
</div>
<div id="formgroup_fee_resto_cc" class="form-group">
<label for="fee_resto_cc" class=" col-sm-2 control-label">Fee</label>
<div class="col-sm-10">
<div class="input-group">
<input type="text" name="fee_resto_cc" value="0" id="fee_resto_cc" class="form-control">
<span class="input-group-addon"> % </span>
</div>
<span class="help-block" id="warning_id_user"></span>
</div>
<div class="clearfix"></div>
</div>
<div class="form-group">
<div class="col-sm-12">
<button id="submit_button_resto_cc_fee" class="btn btn-default">submit</button>
<button id="cancel_button_resto_cc_fee" class="btn btn-default">cancel</button>
</div>
</div>
<script>
$('#button_select_resto_cc_fee').click(
function () {
var restoChoice = $('select#restaurant_cc_fee_choices');
var selectedVal = restoChoice.val();
var selectedText = restoChoice.find('option:selected').text();
if (restoChoice.prop('disabled')) {
alert("All Restaurant Selected");
return;
}
if (selectedVal == '-1' || selectedVal == null || selectedVal == '') {
alert("Please Select Restaurant");
return;
} else if (selectedVal == '0') {
restoChoice.prop("disabled", true);
}
$("select#restaurant_cc_fee_choices option:selected").remove();
$('#selected_restaurant_cc_fee').tokenfield();
$('#selected_restaurant_cc_fee').tokenfield('createToken', {
value: selectedVal,
label: selectedText
});
restoChoice.val('');
}
);
$('#selected_restaurant_cc_fee')
.on('tokenfield:removedtoken', function (e) {
var value = e.attrs.value;
var label = e.attrs.label;
var restoChoice = $('select#restaurant_cc_fee_choices');
restoChoice
.append($("<option></option>")
.attr("value", value)
.text(label));
if (value == '0') {
restoChoice.prop("disabled", false);
}
var selectList = $('select#restaurant_cc_fee_choices option');
selectList.sort(function (a, b) {
a = a.value;
b = b.value;
return a - b;
});
restoChoice.html(selectList);
restoChoice.val(value);
});
$('#cancel_button_resto_cc_fee').click(function () {
clearFields();
});
$('#submit_button_resto_cc_fee').click(function () {
var arr = $('#selected_restaurant_cc_fee').tokenfield('getTokens');
if (!Array.isArray(arr) || arr.length <= 0) {
alert("No Restaurant Selected");
return;
}
var idBank = $('#bank_choices_cc_fee').val();
if (idBank == "-1" || idBank == "") {
alert("No Bank Selected");
return;
}
var arrValue = [];
arr.forEach(function (e) {
console.log(e);
var value = e.value;
var label = e.label;
arrValue.push(value);
// console.log(arrValue.join());
});
var fee = $('#fee_resto_cc').val();
updateFeeCreditCard(arrValue.join(), fee, idBank);
});
function updateFeeCreditCard(values, fee, idBank) {
$.ajax({
method: "POST",
url: _sppath + "Fee/updateRestoCCFee",
data: {id_restaurant: values, fee: fee, id_bank: idBank}
})
.done(function (msg) {
// console.log(msg);
var json_obj = $.parseJSON(msg);//parse JSON
if (json_obj.status_code == 0) {
alert(json_obj.status_message);
}
if (json_obj.status_code == 1) {
alert(json_obj.status_message);
clearFields();
}
});
}
function clearFields() {
lwrefresh(window.selected_page);
}
</script>
<?php
}
public function ListBank($param)
{
$dataset = parent::ListBankProcess($param);
$this->Render('null', $dataset);
}
