function transaksi_pembelian($tglTebus, $noLO, $noSA, $idBarang, $jmlTabung, $hargaSatuan, $pajak, $diskon, $beaAdmin, $grandTotal, $idBank, $bukti, $jenisTarikan, $idKaryawan, $idSPBE)
{
$tglTebus = $this->clearText($tglTebus);
$noLO = $this->clearText($noLO);
$noSA = $this->clearText($noSA);
$idBarang = $this->clearText($idBarang);
$jmlTabung = $this->clearText($jmlTabung);
$hargaSatuan = $this->clearText($hargaSatuan);
$pajak = $this->clearText($pajak);
$diskon = $this->clearText($diskon);
$beaAdmin = $this->clearText($beaAdmin);
$grandTotal = $this->clearText($grandTotal);
$idBank = $this->clearText($idBank);
$bukti = $this->clearText($bukti);
$jenisTarikan = $this->clearText($jenisTarikan);
$idKaryawan = $this->clearText($idKaryawan);
$idSPBE = $this->clearText($idSPBE);
$id = $this->autocode_pembelian($tglTebus);
$query = "INSERT INTO `pembelian` VALUES('{$id}', '{$tglTebus}', '{$noLO}', '{$noSA}', '{$idBarang}', \n\t\t\t'{$jmlTabung}', '{$hargaSatuan}', '{$pajak}', '{$diskon}', '{$beaAdmin}', '{$grandTotal}', '{$idBank}', \n\t\t\t'{$bukti}', '{$jenisTarikan}', '{$idKaryawan}', '{$idSPBE}');";
if ($result = $this->runQuery($query)) {
$bank = new bank();
$hasilBank = $bank->transaksi_tarik($idBank, $bukti, $tglTebus, "Pembelian " . $id, $grandTotal, 0, $idKaryawan, $jenisTarikan);
$loading = new loading();
$hasilLoading = $loading->loading_pembelian_baru($id);
if ($hasilBank == TRUE && $hasilLoading == TRUE) {
return TRUE;
} else {
return FALSE;
}
} else {
return FALSE;
}
}
public function search($params)
{
$id = isset($_GET['id']) ? $_GET['id'] : "";
$id_bank = isset($_GET['id_bank']) ? $_GET['id_bank'] : '';
$query = BankPool::find();
if (!isset($params['sort'])) {
$query->orderBy(['created_at' => SORT_DESC]);
}
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pagesize' => '10']]);
$this->load($params);
if (!$this->validate()) {
return $dataProvider;
}
if ($id) {
$query->andFilterWhere(["bank_pool.id_pool" => $id]);
if (isset($params['BankPoolSearch']['id_bank'])) {
$id_bank = bank::find()->where(["bank_id" => $params['BankPoolSearch']['id_bank']])->one()->id_bank;
}
}
if ($id_bank) {
$query->andFilterWhere(["bank.id_bank" => $id_bank]);
if (isset($params['BankPoolSearch']['id_pool'])) {
$id = pool::find()->where(["pool_id" => $params['BankPoolSearch']['id_pool']])->one()->id_pool;
$query->andFilterWhere(["bank_pool.id_pool" => $id]);
}
}
$query->select('bank.bank_id,pool.pool_id,bank_pool.*')->join("LEFT JOIN", 'bank', "bank.id_bank=bank_pool.id_bank")->join("LEFT JOIN", 'pool', "pool.id_pool=bank_pool.id_pool")->all();
return $dataProvider;
}
protected function findModel($id)
{
if (($model = bank::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
public function actionIndex()
{
$id = isset($_GET['id']) ? $_GET['id'] : null;
$id_bank = isset($_GET['id_bank']) ? $_GET['id_bank'] : null;
$model = new BankPool();
$searchModel = new BankPoolSearch();
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
$k = pool::find()->where(["id_pool" => $id])->one();
$b = bank::find()->where(["id_bank" => $id_bank])->one();
return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'model' => $model, 'id' => $id, 'id_bank' => $id_bank, 'pool_id' => $k['pool_id'], 'bank' => $b['name']]);
}
function get_form_html($form_id, $id, $page, $limit, $adjacents)
{
ob_start();
$bank_deposit = new bank_deposits();
$user = new user();
$user->id = $_SESSION['user_id'];
$user->getUser();
$count = $bank_deposit->getBankDepositsCount($user->company_id);
if ($page == 1) {
$start = 0;
$head_message = "LAST {$limit} BANK DEPOSITS";
} else {
$start = ($page - 1) * $limit;
$head_message = "BANK DEPOSITS {$start} TO " . ($start + $limit);
}
?>
<div id="head_div" style="padding: 5px 0; background-color: #ECECEC; color: #21ACD7;
border-radius: 5px;margin-left: auto; text-align: center; ">
<?php
echo $head_message;
?>
</div>
<div style="margin-top: 10px; background-color:transparent;padding-bottom: 30px;">
<style>
div#purchace_items td{
border: 1px solid #21ACD7;
}
div#purchace_items tbody td{
padding: 5px 0 5px 5px;
}
div#purchace_items tbody td input,div#purchace_items tbody td select{
padding: 0;
border: 0;
margin: 0;
height: 100%;
width: 100%;
background-color: transparent;
}
</style>
<div style="padding: 10px 0; background-color: transparent;
border-radius: 5px;margin-left: auto; text-align: center;overflow-x: auto; ">
<?php
echo pagination($limit, $adjacents, $count, $page);
?>
</div>
<div id="purchace_items" style="width: 100%; padding: 10px 0; color: #21ACD7;">
<table id="items_table" style="border-collapse: collapse; width: 100%;
background-color: #fff; border-radius: 10px; color: #21ACD7;">
<thead style="text-align: center;">
<tr status="not_selected">
<td>
#
</td>
<td>
ID
</td>
<td>
DATE AND TIME
</td>
<td>
AMOUNT
</td>
<td>
BANK
</td>
<td style="">
DESCRIPTION
</td>
</tr>
</thead>
<tbody style="padding-left: 3px; text-align: center; ">
<?php
$bank_deposits = $bank_deposit->getBankDeposits($user->company_id, $start, $limit);
$i = $start;
if ($bank_deposits == NULL || sizeof($bank_deposits) == 0) {
echo '<tr><td colspan="8"> No Bank deposits Found </td></tr>';
} else {
foreach ($bank_deposits as $bank_deposit) {
?>
<tr id="<?php
echo $bank_deposit->id;
?>
" onclick="select_row(this)" status="not_selected">
<td style="text-align: center;">
<?php
echo ++$i;
?>
</td>
<td>
<?php
echo $bank_deposit->id;
?>
</td>
<?php
$date = date('d/m/Y', strtotime($bank_deposit->deposited_at) + 5.5 * 60 * 60);
$time = date('h:m a', strtotime($bank_deposit->deposited_at) + 5.5 * 60 * 60);
?>
<td>
<?php
echo $date . ' - ' . $time;
?>
</td>
<td id="amount"><?php
echo number_format($bank_deposit->amount, 2, '.', '');
?>
</td>
<?php
$bank = new bank();
$bank->id = $bank_deposit->bank_id;
$bank->getBank();
?>
<td id="bank" bank_id="<?php
echo $bank->id;
?>
">
<?php
echo $bank->bank_name . ' - ' . $bank->branch . ' - ' . $bank->account_number;
?>
</td>
<td id="description"><?php
echo $bank_deposit->description;
?>
</td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
<div style="padding: 10px 0; background-color: transparent;
border-radius: 5px;margin-left: auto; text-align: center;overflow-x: auto; ">
<?php
echo pagination($limit, $adjacents, $count, $page);
?>
</div>
</div>
<script type="text/javascript">
function select_row(row) {
var j_row = $(row);
if(j_row.attr('status') == 'selected'){
$('table#items_table tr').attr('status', 'not_selected');
$('table#items_table tr').css('background-color', '#FFF');
$('img#edit').css('display', 'none');
$('img#edit_fade').css('display', 'block');
$('img#delete').css('display', 'none');
$('img#delete_fade').css('display', 'block');
}else{
$('table#items_table tr').attr('status', 'not_selected');
$('table#items_table tr').css('background-color', '#FFF');
j_row.attr('status', 'selected');
j_row.css('background-color', '#C0EFFD');
$('img#edit').css('display', 'block');
$('img#edit_fade').css('display', 'none');
$('img#delete').css('display', 'block');
$('img#delete_fade').css('display', 'none');
}
}
function on_edit_clicked(){
var selected_row = $('tr[status="selected"]');
var amount = selected_row.find('td#amount').html();
var id = selected_row.attr('id');
var description = selected_row.find('td#description').html();
var bank_id = selected_row.find('td#bank').attr('bank_id');
get_form(4, ///bank deposit create form
function (html, tools){
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
var form = $('div#form-body').find('form.action_form');
form.attr('operation', 'update');
form.attr('bank_deposit_id', id);
form.find('input#amount').val(amount);
form.find('textarea#description').val(description);
form.find('select#bank_account').val(bank_id);
form.find('input[type=submit]').val('UPDATE');
$('div#head_div').html('ID : BANK DEPOSIT-'+id);
$('div#head_div').css('display', 'block');
},
function (message){
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
}
);
}
function on_delete_clicked(){
var selected_row = $('tr[status="selected"]');
var id = selected_row.attr('id');
if(confirm('Are you sure you want to delete EXPENCE-'+id+' ?' )){
var data = {
form_id : 32,
bank_deposit_id : id
}
delete_form_data(data, function(message) {
get_form(32,
function(html, tools) {
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
}, function(message) {
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
});
alert(message);
}, function(message) {
alert(message);
});
}
}
function set_pagination_listener(){
$('.pagination').on('click','.page-numbers',function(e){
e.preventDefault();
var page = $(this).attr('page');
var id = 0;
get_form(32,
function(html, tools) {
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
}, function(message) {
$('font#section_heading').empty();
alert(message);
},id
,page
);
return false;
});
}
set_pagination_listener();
</script>
<?php
$form = ob_get_clean();
return $form;
}
<div class="bankuser-form">
<?php
$form = ActiveForm::begin();
?>
<?php
if (isset($id_pool) && $id_pool != '') {
?>
<input type="hidden" value="<?php
echo $id_pool;
?>
" name="BankPool[id_pool]">
<?php
echo $form->field($model, 'id_bank', ['options' => ['class' => 'col-xs-3', "id" => "id_extend"]])->dropDownList(ArrayHelper::map(bank::find()->all(), "id_bank", "bank_id"), ['maxlength' => true])->label('Bank ID');
?>
<div class="form-group" >
<div class="col-sm-2" style="padding-left: 15px;padding-top:27px">
<a href="index.php?r=bank/create" target="_blank"><?php
echo $m = Html::Button("NEW BANK", ['class' => 'btn btn-success']);
?>
</a>
</div>
<?php
}
?>
<?php
if (isset($id_bank) && $id_bank != '') {
?>
$mysql_error = mysql_error();
if (empty($mysql_error)) {
$error_message = 'Some server error occured';
} else {
$error_message = $mysql_error;
}
$responce = array('status' => 'failed', 'error' => $error_message, 'data' => array());
}
} else {
$responce = array('status' => 'failed', 'error' => 'Data missing', 'data' => array());
}
} else {
if ($form_id == 22) {
//bank form
if (isset($_POST['bank_name']) and !empty($_POST['bank_name']) and isset($_POST['branch']) and !empty($_POST['branch']) and isset($_POST['ifsc_code']) and !empty($_POST['ifsc_code']) and isset($_POST['account_number']) and !empty($_POST['account_number'])) {
$bank = new bank();
$bank->bank_name = $_POST['bank_name'];
$bank->branch = $_POST['branch'];
$bank->ifsc_code = $_POST['ifsc_code'];
$bank->account_number = $_POST['account_number'];
if ($bank->addBank()) {
$responce = array('status' => 'success', 'error' => '', 'data' => array('message' => 'Bank Added successfully'));
} else {
Log::e($tag, "Bank adding failed item : " . $bank->to_string() . 'Error : ' . mysql_error());
$mysql_error = mysql_error();
if (empty($mysql_error)) {
$error_message = 'Some server error occured';
} else {
$error_message = $mysql_error;
}
$responce = array('status' => 'failed', 'error' => $error_message, 'data' => array());
$mysql_error = mysql_error();
if (empty($mysql_error)) {
$error_message = 'Some server error occured';
} else {
$error_message = $mysql_error;
}
$responce = array('status' => 'failed', 'error' => $error_message, 'data' => array());
}
} else {
$responce = array('status' => 'failed', 'error' => 'Data missing', 'data' => array());
}
} else {
if ($form_id == 22) {
///edit bank
if (isset($_POST['bank_id']) and !empty($_POST['bank_id']) and isset($_POST['bank_name']) and !empty($_POST['bank_name']) and isset($_POST['branch']) and !empty($_POST['branch']) and isset($_POST['ifsc_code']) and !empty($_POST['ifsc_code']) and isset($_POST['account_number']) and !empty($_POST['account_number'])) {
$bank = new bank();
$bank->id = $_POST['bank_id'];
$bank->getBank();
$bank->bank_name = $_POST['bank_name'];
$bank->branch = $_POST['branch'];
$bank->ifsc_code = $_POST['ifsc_code'];
$bank->account_number = $_POST['account_number'];
if ($bank->updateBank()) {
$message = "Bank Updated Successfuly";
$responce = array('status' => 'success', 'error' => '', 'data' => array("message" => $message, "id" => $bank->id));
} else {
$description = "Bank update failed, Bank : " . $bank->to_string();
Log::e($tag, $description);
$mysql_error = mysql_error();
if (empty($mysql_error)) {
$error_message = 'Some server error occured';
/**************************************** Edit/Update Data ***********************************/
//Edit Data
$app->get('/edit/:id', function ($id) use($app) {
$app->view->setData('form_action', BASEURL . "dashboard/bank/edit");
$app->render(new u('bank.create'));
$app->render(new u('bank.edit'));
});
/***********************************SEARCH*************************************************/
$app->post('/search', function () use($app) {
$POST = $app->request()->post();
$SearchDb = new SearchDb('bank', 'accountname', $POST);
$app->view->setData('rows', $SearchDb->getSearchResult());
$app->render(new u('bank.view'));
});
/***********************************Delete*************************************************/
$app->get('/delete/:id', function ($id) use($app) {
$bank = new bank();
$bank->updateBankStatus($id);
if ($bank->fails()) {
$app->view->setData('error', "1");
$app->view->setData('msg', $admin->getError());
$app->render(new u('msg'));
} else {
$app->view->setData('success', "1");
$app->view->setData('msg', "Successfully Bank Blocked.");
$app->render(new u('msg'));
}
});
/*******************************************************************************************/
});
});
function get_form_html($form_id, $id)
{
ob_start();
?>
<style>
.field_name{
width: 20%;
}
.field input{
width: 100%;
margin-left: 0px;
}
.field textArea{
width: 100%;
margin-left: 0px;
}
.field .parent{
padding: 0px 0px;
}
.field select{
width: 100%;
}
</style>
<div id="head_div" style="padding: 5px 0; background-color: #ECECEC; color: #21ACD7;
border-radius: 5px;margin-left: auto;display: none; text-align: center; ">
</div>
<div style="margin-top: 10px; background-color:transparent;padding-bottom: 30px;">
<form action="#" method="post" class="action_form" operation="add" style="width:100%;" >
<table style="width:100%;">
<tr>
<td class="field_name">
<font>AMOUNT</font>
</td>
<td class="field">
<div class="parent">
<input type="number" step="0.01" id="amount" required />
</div>
</td>
</tr>
<tr>
<td class="field_name">
<font>BANK ACCOUNT</font>
</td>
<td class="field">
<div class="parent">
<select id="bank_account" required >
<?php
$bank = new bank();
$banks = $bank->getBanks();
if (is_array($banks) and count($banks) != 0) {
foreach ($banks as $bank) {
echo '<option value="' . $bank->id . '">' . $bank->bank_name . ' - ' . $bank->branch . ' - ' . $bank->account_number . '</option>';
}
}
?>
</select>
</div>
</td>
</tr>
<tr>
<td class="field_name">
<font>DESCRIPTION</font>
</td>
<td class="field">
<div class="parent">
<textarea id="description" required rows="5" ></textarea>
</div>
</td>
</tr>
<tr></tr>
<tr>
<td></td>
<td>
<div style="padding: 0px 12px;">
<div style="width: 100%; margin-left: -12px; padding: 12px;
background-color: #0d92bb; border-radius: 5px; float: left;">
<div style="width: 50%; float: right; ">
<input style="width: 100%;" type="submit" value="ADD" />
</div>
<div style="width: 50%;">
<input style="width: 100%;" type="reset" value="CANCEL" />
</div>
</div>
</div>
</td>
</tr>
</table>
</form>
</div>
<script type="text/javascript">
function setFormActionListener(){
$('form.action_form').on('submit', function(e) {
e.preventDefault();
var id = 4;
var operation = $(this).attr('operation');
if (operation == 'add') {
var data = {
form_id: id,
amount: $('form input#amount').val(),
bank_id: $('form select#bank_account').val(),
description: $('form textarea#description').val()
}
add_form_data(data, function(message) {
get_form(4,function(html) {
$('div#form-body').html(html);
}, function(message) {
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
});
alert(message);
}, function(message) {
alert(message);
});
}else if (operation == 'update') {
var bank_deposit_id = $('form.action_form').attr('bank_deposit_id');
var data = {
form_id: id,
bank_deposit_id: bank_deposit_id,
amount: $('form input#amount').val(),
bank_id: $('form select#bank_account').val(),
description: $('form textarea#description').val()
}
update_form_data(data, function(message) {
get_form(32,function(html, tools) {
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
}, function(message) {
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
});
alert(message);
}, function(message) {
alert(message);
});
} else {
alert("Invalid Operation " + id + ' - ' + operation);
}
});
};
setFormActionListener();
</script>
<?php
$form = ob_get_clean();
return $form;
}
echo "<label for='name'>Событие {$s->sort}:</label><input type='text' id='com_{$s->id}' name='sob[{$s->id}][com]' value='{$s->com}' size='10'><input type='text' id='kef_{$s->id}' name='sob[{$s->id}][kef]' value='" . round($s->kef, 2) . "' size='3'> <br />";
}
echo ' <input type="submit" value="Изменить">
</fieldset>
</form>
<div id="sob_result"></div>
';
die;
}
//end if (isset($_GET['edit_sob']))
/*
action block's
*/
$bank = dbObject::table('bank')->get();
$bank = bank::get();
foreach ($bank as $b) {
echo "<a href='?bank={$b->id}'>{$b->name} ({$b->name_vlad})</a>";
$db->where("bank_id", $b->id);
$sum = $db->getValue("provodki", "sum(sum)");
echo "Баланс: {$sum} <br />";
}
$sob = dbObject::table('sob')->get();
$db->orderBy("sort", "asc");
$sob = sob::get();
echo '<div id="sortable">';
foreach ($sob as $s) {
echo "<div id='{$s->id}''>Событие: {$s->com} Кэф: " . round($s->kef, 2) . "</div>";
}
echo '</div>';
echo "<a href='?edit_sob=1'>Изменить события</a>";
<?php
if (isset($_POST['apa']) && $_POST['apa'] != "") {
include 'modules/model/class.bank.php';
$bank = new bank();
switch ($_POST['apa']) {
case "get-bank":
$collect = array();
if ($query = $bank->get_bank()) {
while ($rs = $query->fetch_array()) {
$detail = array();
array_push($detail, $rs["nama"]);
array_push($detail, $rs["nomor_rekening"]);
array_push($detail, "Rp " . number_format($rs["saldo"], 2, ",", "."));
array_push($detail, "<button type='button' class='btn btn-sm btn-primary' id='btn-tarik' data-id='" . $rs["id"] . "'>\n\t\t\t\t\t\t\t\t\t<i class='fa fa-money'></i> Tarik Dana</button>");
array_push($collect, $detail);
unset($detail);
}
}
echo json_encode(array("aaData" => $collect));
break;
case "tarik-dana":
$arr = array();
if (isset($_POST['txt-idbank']) && $_POST['txt-idbank'] != "" && isset($_POST['txt-bukti']) && $_POST['txt-bukti'] != "" && isset($_POST['txt-tgltarik']) && $_POST['txt-tgltarik'] != "" && isset($_POST['txt-keterangan']) && $_POST['txt-keterangan'] != "" && isset($_POST['txt-jumlah']) && $_POST['txt-jumlah'] != "" && isset($_POST['txt-beaadmin']) && $_POST['txt-beaadmin'] != "" && isset($_POST['cmb-jenis']) && $_POST['cmb-jenis'] != "") {
if ($result = $bank->transaksi_tarik($_POST['txt-idbank'], $_POST['txt-bukti'], $_POST['txt-tgltarik'], $_POST['txt-keterangan'], $_POST['txt-jumlah'], $_POST['txt-beaadmin'], d_code($_SESSION['en-data']), $_POST['cmb-jenis'])) {
$arr['status'] = TRUE;
$arr['msg'] = "Data tersimpan..";
} else {
$arr['status'] = FALSE;
$arr['msg'] = "Gagal menyimpan..";
}
<li class="active"><?php
echo isset($_GET['id']) ? 'Update' : 'Add';
?>
Bank Transection</li>
</ol>
<div class="panel panel-info">
<div class="panel-heading">
<h3><?php
echo isset($_GET['id']) ? 'Update' : 'Add';
?>
Bank Transection</h3>
</div>
<div class="panel-body">
<?php
$bank = new bank();
$bank_result = $bank->get_banks();
$ID = isset($_GET['id']) ? $_GET['id'] : NULL;
if (isset($_POST['add_transection'])) {
// Update old record
$results = $bank->add_transection_bank($_POST);
if ($results) {
echo '<div class="alert alert-success" role="alert"> Add Bank Transection Sucessfully </div>';
} else {
echo '<div class="alert alert-danger" role="alert"> Error </div>';
}
}
?>
<div class="the-box noborder">
<form id="ExampleBootstrapValidationForm" method="post" action="" class="form-horizontal">
<fieldset>
<li class="active"><?php
echo isset($_GET['id']) ? 'Update' : 'Add';
?>
Bank</li>
</ol>
<div class="panel panel-info">
<div class="panel-heading">
<h3><?php
echo isset($_GET['id']) ? 'Update' : 'Add';
?>
Bank</h3>
</div>
<div class="panel-body">
<?php
$bank = new bank();
$ID = isset($_GET['id']) ? $_GET['id'] : NULL;
if (isset($_POST['add_bank'])) {
// Update old record
if (isset($ID)) {
$results = $bank->update_bank($_POST, $ID);
} else {
// Insert new
$results = $bank->add_bank($_POST);
}
if ($results) {
echo '<div class="alert alert-success" role="alert"> Add Bank Sucessfully </div>';
} else {
echo '<div class="alert alert-danger" role="alert"> Error </div>';
}
}
$mysql_error = mysql_error();
if (empty($mysql_error)) {
$error_message = 'Some server error occured';
} else {
$error_message = $mysql_error;
}
$responce = array('status' => 'failed', 'error' => $error_message, 'data' => array());
}
} else {
$responce = array('status' => 'failed', 'error' => 'Data missing', 'data' => array());
}
} else {
if ($form_id == 23) {
///bank delete
if (isset($_POST['bank_id']) and !empty($_POST['bank_id'])) {
$bank = new bank();
$bank->id = $_POST['bank_id'];
if ($bank->deleteBank()) {
$message = "Bank deleted Successfuly";
$responce = array('status' => 'success', 'error' => '', 'data' => array("message" => $message, "id" => $bank->id));
} else {
$description = "Bank delete failed, item : " . $bank->to_string() . " Error : " . mysql_error();
Log::e($tag, $description);
$mysql_error = mysql_error();
if (empty($mysql_error)) {
$error_message = 'Some server error occured';
} else {
$error_message = $mysql_error;
}
$responce = array('status' => 'failed', 'error' => $error_message, 'data' => array());
}
function get_form_html($form_id, $id)
{
ob_start();
?>
<div id="head_div" style="height: 150px;
width: 320px; background-color: #ECECEC;
border-radius: 5px;margin-left: auto;display: none; ">
</div>
<div style="margin-top: 10px; background-color:transparent;padding-bottom: 30px;">
<style>
div#purchace_items td{
border: 1px solid #21ACD7;
}
div#purchace_items tbody td{
padding: 5px 0 5px 5px;
}
div#purchace_items tbody td input,div#purchace_items tbody td select{
padding: 0;
border: 0;
margin: 0;
height: 100%;
width: 100%;
background-color: transparent;
}
</style>
<div id="purchace_items" style="width: 100%; padding: 10px 0; color: #21ACD7;">
<table id="items_table" style="border-collapse: collapse; width: 100%;
background-color: #fff; border-radius: 10px; color: #21ACD7;">
<thead style="text-align: center;">
<tr status="not_selected">
<td>
#
</td>
<td>
ID
</td>
<td>
BANK NAME
</td>
<td>
BRANCH
</td>
<td style="">
IFSC CODE
</td>
<td style="">
ACCOUNT NUMBER
</td>
</tr>
</thead>
<tbody style="padding-left: 3px; text-align: center; ">
<?php
$bank = new bank();
$banks = $bank->getBanks();
$i = 0;
if ($banks == NULL || sizeof($banks) == 0) {
echo '<tr><td colspan="8"> No Bank Found </td></tr>';
} else {
foreach ($banks as $bank) {
?>
<tr id="<?php
echo $bank->id;
?>
" onclick="select_row(this)">
<td style="text-align: center;"><?php
echo ++$i;
?>
</td>
<td id="bank_id"><?php
echo 'BANK-' . $bank->id;
?>
</td>
<td id="bank_name"><?php
echo $bank->bank_name;
?>
</td>
<td id="branch"><?php
echo $bank->branch;
?>
</td>
<td id="ifsc_code"><?php
echo $bank->ifsc_code;
?>
</td>
<td id="account_number"><?php
echo $bank->account_number;
?>
</td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
</div>
<script type="text/javascript">
function select_row(row) {
var j_row = $(row);
if(j_row.attr('status') == 'selected'){
$('table#items_table tr').attr('status', 'not_selected');
$('table#items_table tr').css('background-color', '#FFF');
$('img#edit').css('display', 'none');
$('img#edit_fade').css('display', 'block');
$('img#delete').css('display', 'none');
$('img#delete_fade').css('display', 'block');
}else{
$('table#items_table tr').attr('status', 'not_selected');
$('table#items_table tr').css('background-color', '#FFF');
j_row.attr('status', 'selected');
j_row.css('background-color', '#C0EFFD');
$('img#edit').css('display', 'block');
$('img#edit_fade').css('display', 'none');
$('img#delete').css('display', 'block');
$('img#delete_fade').css('display', 'none');
}
}
function on_edit_clicked(){
var selected_row = $('tr[status="selected"]');
var bank_name = selected_row.find('td#bank_name').html();
var id = selected_row.attr('id');
var branch = selected_row.find('td#branch').html();
var ifsc_code = selected_row.find('td#ifsc_code').html();
var account_number = selected_row.find('td#account_number').html();
get_form(22, ///bank create form
function (html, tools){
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
var form = $('div#form-body').find('form.action_form');
form.attr('operation', 'update');
form.attr('bank_id', id);
form.find('input#bank_name').val(bank_name);
form.find('input#branch').val(branch);
form.find('input#ifsc_code').val(ifsc_code);
form.find('input#account_number').val(account_number);
form.find('input[type=submit]').val('UPDATE');
$('div#head_div').html('ID : BANK-'+id);
$('div#head_div').css('display', 'block');
},
function (message){
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
}
);
}
function on_delete_clicked(){
var selected_row = $('tr[status="selected"]');
var id = selected_row.attr('id');
if(confirm('Are you sure you want to delete BANK-'+id+' ?' )){
var data = {
form_id : 23,
bank_id : id
}
delete_form_data(data, function(message) {
get_form(23,
function(html, tools) {
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
}, function(message) {
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
});
alert(message);
}, function(message) {
alert(message);
});
}
}
function on_add_clicked(){
get_form(22, ///bank create form
function (html, tools){
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
},
function (message){
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
}
);
}
</script>
<?php
$form = ob_get_clean();
return $form;
}
<?php
if (isset($_POST['apa']) && $_POST['apa'] != "") {
include 'modules/model/class.bank.php';
$bank = new bank();
switch ($_POST['apa']) {
case "get-bank":
$collect = array();
if ($query = $bank->get_bank()) {
while ($rs = $query->fetch_array()) {
$detail = array();
array_push($detail, $rs["nama"]);
array_push($detail, $rs["nomor_rekening"]);
array_push($detail, "Rp " . number_format($rs["saldo"], 2, ",", "."));
array_push($detail, "<button type='button' class='btn btn-sm btn-primary' id='btn-ubah-data' data-id='" . $rs["id"] . "' data-nama='" . $rs["nama"] . "' \n\t\t\t\t\t\t\t\t\tdata-rekening='" . $rs["nomor_rekening"] . "'><i class='fa fa-pencil'></i></button> \n\t\t\t\t\t\t\t\t\t<button type='button' class='btn btn-sm btn-danger' id='btn-hapus-bank' data-id='" . $rs["id"] . "'><i class='fa fa-trash-o'></i></button>");
array_push($collect, $detail);
unset($detail);
}
}
echo json_encode(array("aaData" => $collect));
break;
case "tambah-bank":
$arr = array();
if (isset($_POST['txt-nama']) && $_POST['txt-nama'] != "" && isset($_POST['txt-rekening']) && $_POST['txt-rekening'] != "") {
if ($result = $bank->tambah_baru($_POST['txt-nama'], $_POST['txt-rekening'])) {
$arr['status'] = TRUE;
$arr['msg'] = "Data tersimpan..";
} else {
$arr['status'] = FALSE;
$arr['msg'] = "Gagal menyimpan..";
}
<?php
require "cartes.php";
require "game.php";
require "joueur.php";
session_start();
if (!isset($_POST['jouer'])) {
$deck = new deck();
$bank = new bank('Bank', '', '');
$joueur = new joueur('Mougui', '', '');
echo "<i><b>" . $bank->getPseudo() . "</b></i> : <br>";
for ($i = 0; $i < 2; $i++) {
list($carte) = $deck->melanger()->tirerCarte(1);
serialize($deck);
$bank->ajouter($carte);
echo $carte . "<br>";
}
echo '<u>Resultat : ' . $bank->getValueTot() . "</u><br><br>";
///////////////////////////////////////////////////////
echo "<i><b>" . $joueur->getPseudo() . "</b></i> : <br>";
for ($i = 0; $i < 2; $i++) {
list($carte) = $deck->melanger()->tirerCarte(1);
serialize($deck);
$joueur->ajouter($carte);
echo $carte . "<br>";
}
echo '<u>Resultat : ' . $joueur->getValueTot() . "</u><br><br>";
////////////////////////////////////////////////////////
$game = new game();
$game->enregistrer($joueur->getMain(), $bank->getMain(), $bank->getValueTot(), $joueur->getValueTot());
} else {
<?php
if (isset($_POST['apa']) && $_POST['apa'] != "") {
include 'modules/model/class.bank.php';
$bank = new bank();
switch ($_POST['apa']) {
case "get-bank":
$collect = array();
if ($query = $bank->get_bank()) {
while ($rs = $query->fetch_array()) {
$detail = array();
array_push($detail, $rs["nama"]);
array_push($detail, $rs["nomor_rekening"]);
array_push($detail, "Rp " . number_format($rs["saldo"], 2, ",", "."));
array_push($detail, "<button type='button' class='btn btn-sm btn-primary' id='btn-setor' data-id='" . $rs["id"] . "'>\n\t\t\t\t\t\t\t\t\t<i class='fa fa-plus'></i> Setor Dana</button>");
array_push($collect, $detail);
unset($detail);
}
}
echo json_encode(array("aaData" => $collect));
break;
case "setor-dana":
$arr = array();
if (isset($_POST['txt-idbank']) && $_POST['txt-idbank'] != "" && isset($_POST['txt-bukti']) && $_POST['txt-bukti'] != "" && isset($_POST['txt-tglsetor']) && $_POST['txt-tglsetor'] != "" && isset($_POST['txt-keterangan']) && $_POST['txt-keterangan'] != "" && isset($_POST['txt-jumlah']) && $_POST['txt-jumlah'] != "") {
if ($result = $bank->transaksi_setor($_POST['txt-idbank'], $_POST['txt-bukti'], $_POST['txt-tglsetor'], $_POST['txt-keterangan'], $_POST['txt-jumlah'], d_code($_SESSION['en-data']))) {
$arr['status'] = TRUE;
$arr['msg'] = "Data tersimpan..";
} else {
$arr['status'] = FALSE;
$arr['msg'] = "Gagal menyimpan..";
}
public function edit($id = null)
{
$bank = bank::where(['id' => $id])->first();
return view('banks.edit')->with('bank', $bank);
}
if (isset($_POST['apa']) && $_POST['apa'] != "") {
include 'modules/model/class.pembelian.php';
$pembelian = new pembelian();
switch ($_POST['apa']) {
case "get-barang":
include 'modules/model/class.barang.php';
$barang = new barang();
if ($query = $barang->get_barang()) {
while ($rs = $query->fetch_array()) {
echo "<option value='" . $rs['id'] . "' data-harga='" . $rs['harga_beli'] . "'>" . $rs['nama'] . "</option>";
}
}
break;
case "get-bank":
$bank = new bank();
if ($query = $bank->get_bank()) {
while ($rs = $query->fetch_array()) {
echo "<option value='" . $rs['id'] . "'>" . $rs['nama'] . " " . $rs['nomor_rekening'] . "</option>";
}
}
break;
case "get-spbe":
include 'modules/model/class.spbe.php';
$spbe = new spbe();
if ($query = $spbe->get_spbe_barang_by_barang($_POST['barang'])) {
while ($rs = $query->fetch_array()) {
echo "<option value='" . $rs['id'] . "' data-ship='" . $rs['ship_to'] . "' data-sold='" . $rs['sold_to'] . "'>" . $rs['nama_spbe'] . "</option>";
}
}
break;
<?php
require_once 'header.php';
?>
<section>
<hr/>
<div class="container">
<div class="row">
<div class="tableHeading">
<p class="nomargin alignCenter">View Supplier</p>
</div>
<div class="col-md-12">
<?php
$bank = new bank();
$results = $bank->get_banks();
if ($results) {
?>
<table border="1" cellpadding="0" cellspacing="0" class="table table-hover tableView">
<tr>
<th>Bank Name</th>
<th>Branch</th>
<th>Account #</th>
<th>Account Title</th>
<th>Account Type</th>
<th>Action</th>
</tr>
<?php
foreach ($results as $res) {
echo '<tr>';
echo '<td>' . $res->bank_name . '</td>';
echo '<td>' . $res->bank_branch . '</td>';
function ambil_bg($idPelunasan, $tglBg, $totalBayar, $idBank, $bukti, $idKaryawan)
{
$idPelunasan = $this->clearText($idPelunasan);
$tglBg = $this->clearText($tglBg);
$totalBayar = $this->clearText($totalBayar);
$idBank = $this->clearText($idBank);
$bukti = $this->clearText($bukti);
$idKaryawan = $this->clearText($idKaryawan);
$query = "UPDATE `pelunasan` SET `ambil_bg` = '1' WHERE `id` = '{$idPelunasan}';";
if ($result = $this->runQuery($query)) {
$bank = new bank();
$hasilBank = $bank->transaksi_setor($idBank, $bukti, $tglBg, "Pencairan BG " . $bukti, $totalBayar, $idKaryawan);
if ($hasilBank) {
return TRUE;
} else {
return FALSE;
}
} else {
return FALSE;
}
}
<li><a href="suppliers.php">Suppliers</a></li>
<li class="active">Add Supplier Bill</li>
</ol>
<div class="panel panel-info">
<div class="panel-heading">
<h3><?php
echo isset($_GET['id']) ? 'Update' : 'Add';
?>
Supplier Bill</h3>
</div>
<div class="panel-body">
<?php
$suppliers = new supplier();
$all_suppliers = $suppliers->get_suppliers();
$bank = new bank();
$bank_result = $bank->get_banks();
$accounts = new accounts();
$ID = isset($_GET['id']) ? $_GET['id'] : NULL;
if (isset($_POST['add_bill'])) {
$supplier_id = $_POST['supplier_id'];
$bill_number = $_POST['bill_number'];
$due_date = $_POST['due_date'];
$bill_amount = $_POST['bill_amount'];
$payment_type = $_POST['payment_type'];
if ($payment_type == 'cheque') {
$type = 'credit';
} else {
$type = 'debit';
}
$bank_detail = $_POST['bank_detail'];
function penjualan_hapus($idPenjualan, $idKaryawan)
{
$idPenjualan = $this->clearText($idPenjualan);
$idKaryawan = $this->clearText($idKaryawan);
$bankRevisi = "";
$totalKasRevisi = 0;
$qFinal = "";
$qCekPenjualan = "SELECT * FROM `penjualan` WHERE `id` = '{$idPenjualan}';";
if ($resCekPenjualan = $this->runQuery($qCekPenjualan)) {
$rsCekPenjualan = $resCekPenjualan->fetch_array();
if ($rsCekPenjualan['jenis'] == "4") {
//cek penjualan jika tempo
$qCekPelunasan = "SELECT * FROM `pelunasan` WHERE `id_penjualan` = '{$idPenjualan}';";
if ($resCekPelunasan = $this->runQuery($qCekPelunasan)) {
$rsCekPelunasan = $resCekPelunasan->fetch_array();
if ($rsCekPelunasan['jenis'] == "4") {
//cek pelunasan jika bg
if ($rsCekPelunasan['ambil_bg'] == "1") {
//cek pelunasan jika bg sudah diambil
$bankRevisi = $rsCekPelunasan['id_bank'];
$totalKasRevisi = $rsCekPelunasan['total_bayar'];
$qFinal .= "DELETE FROM `pelunasan` WHERE `id_penjualan` = '{$idPenjualan}';";
} else {
//cek pelunasan jika bg belum diambil
$qFinal .= "DELETE FROM `pelunasan` WHERE `id_penjualan` = '{$idPenjualan}';";
}
} elseif ($rsCekPelunasan['jenis'] == "2" || $rsCekPelunasan['jenis'] == "3") {
//cek pelunasan jika debet atau trf
$bankRevisi = $rsCekPelunasan['id_bank'];
$totalKasRevisi = $rsCekPelunasan['total_bayar'];
$qFinal .= "DELETE FROM `pelunasan` WHERE `id_penjualan` = '{$idPenjualan}';";
} elseif ($rsCekPelunasan['jenis'] == "1") {
//cek pelunasan jika cash
if ($rsCekPelunasan['no_bukti'] == "") {
//cek pelunasan jika cash belum disetor
$qFinal .= "DELETE FROM `pelunasan` WHERE `id_penjualan` = '{$idPenjualan}';";
} else {
//cek pelunasan jika cash sudah disetor
$bankRevisi = $rsCekPelunasan['id_bank'];
$totalKasRevisi = $rsCekPelunasan['total_bayar'];
$qFinal .= "DELETE FROM `pelunasan` WHERE `id_penjualan` = '{$idPenjualan}';";
}
}
}
$qFinal .= "DELETE FROM `penjualan` WHERE `id` = '{$idPenjualan}';";
} elseif ($rsCekPenjualan['jenis'] == "2" || $rsCekPenjualan['jenis'] == "3") {
//cek penjualan jika debet atau trf
$bankRevisi = $rsCekPenjualan['id_bank'];
$totalKasRevisi = $rsCekPenjualan['total_bayar'];
$qFinal .= "DELETE FROM `penjualan` WHERE `id` = '{$idPenjualan}';";
} elseif ($rsCekPenjualan['jenis'] == "1") {
//cek penjualan jika cash
if ($rsCekPenjualan['no_bukti'] == "") {
//cek penjualan jika cash belum disetor
$qFinal .= "DELETE FROM `penjualan` WHERE `id` = '{$idPenjualan}';";
} else {
//cek penjualan jika cash sudah disetor
$bankRevisi = $rsCekPenjualan['id_bank'];
$totalKasRevisi = $rsCekPenjualan['total_bayar'];
$qFinal .= "DELETE FROM `penjualan` WHERE `id` = '{$idPenjualan}';";
}
}
$qCekGudang = "SELECT * FROM `penjualan_acc_gudang` WHERE `id_penjualan` = '{$idPenjualan}';";
if ($resCekGudang = $this->runQuery($qCekGudang)) {
$rsCekGudang = $resCekGudang->fetch_array();
if ($rsCekGudang['acc_gudang'] == "1") {
$qFinal .= "UPDATE `barang` SET `stok_isi` = `stok_isi` + " . $rsCekPenjualan['jml'] . ", \n\t\t\t\t\t\t`stok_kosong` = `stok_kosong` - " . $rsCekPenjualan['jml'] . " WHERE `id` = '" . $rsCekPenjualan['id_barang'] . "';";
$qFinal .= "DELETE FROM `penjualan_acc_gudang` WHERE `id_penjualan` = '{$idPenjualan}';";
} else {
$qFinal .= "DELETE FROM `penjualan_acc_gudang` WHERE `id_penjualan` = '{$idPenjualan}';";
}
}
$qFinal .= "UPDATE `request_hapus` SET `is_proses` = '1' WHERE `jenis` = '1' AND `id_hapus` = '{$idPenjualan}';";
}
if ($result = $this->runMultipleQueries($qFinal)) {
if ($bankRevisi != "" && $totalKasRevisi != 0) {
$cbank = new bank();
$hasilBank = $cbank->transaksi_tarik($bankRevisi, "0000", date("Y-m-d"), "Revisi Transaksi Penjualan", $totalKasRevisi, 0, $idKaryawan, "1");
if ($hasilBank) {
return TRUE;
} else {
return FALSE;
}
} else {
return TRUE;
}
} else {
return FALSE;
}
}
