public function cetak()
{
$this->load->model('penjualan_model');
$mode = $this->input->post('mode');
$data = array('data' => $this->penjualan_model->laporanKeuangan());
$content = array('content' => $this->load->view($this->kelas . '/cetak_' . $mode, $data, true), 'profil' => $this->auth->profil(), 'title' => 'Rekap Transaksi ' . ucwords($mode), 'tanggal' => dateToIndo(date("Y-m-d")));
$this->load->view($this->kelas . '/html_cetak', $content);
}
<div class="col-md-3 col-sm-3"> </div>
<div class="col-md-6 col-sm-6">
<table class="table table-condensed">
<thead>
<tr><th>Hasil Pencarian . . .</th></tr>
</thead>
<tbody>
<?php
if (isset($data)) {
foreach ($data as $r) {
if ($r['foto']) {
$img = "<img src='" . base_url('asset/images/blog/' . $r['foto']) . "' class='img-responsive' />";
} else {
$img = '';
}
echo "<tr>\n\t\t\t\t\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t\t\t\t\t{$img} <br />\n\t\t\t\t\t\t\t\t\t\t\t<h3 class='panel-title'>" . $r['judul'] . " <small>" . dateToIndo($r['tanggal']) . "</small></h3><br />\n\t\t\t\t\t\t\t\t\t\t\t" . nl2br($r['isi']) . "\n\t\t\t\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t\t\t</tr>";
}
}
?>
</tbody>
</table>
</div>
<div class="col-md-3 col-sm-3"> </div>
</div>
</section>
</div>
<footer class="main-footer" style="padding:0">
<div class="col-md-12 col-sm-12" style="background:#eeeddd;padding:10px">
<div class="col-md-1 col-sm-1">
</div>
<tr>
<th width="15%">No. Faktur</th>
<td width="2%">:</td>
<td width="33%"><?php
echo $faktur['trbr_faktur'];
?>
</td>
<th width="15%"> </th>
<td width="2%"> </td>
<td width="33%"> </td>
</tr>
<tr>
<th width="15%">Tanggal</th>
<td width="2%">:</td>
<td width="33%"><?php
echo dateToIndo($faktur['trbr_tgl']);
?>
</td>
<th width="15%">Pay Method</th>
<td width="2%">:</td>
<td width="33%"><?php
echo $faktur['trbr_pay_method'];
?>
</td>
</tr>
<tr>
<th width="15%">Kode Supplier</th>
<td width="2%">:</td>
<td width="33%"><?php
echo $faktur['trbr_supid'];
?>
<thead>
<tr>
<th>User & Time</th>
<th>Isi</th>
</tr>
</thead>
<tbody>
<?php
$n = 1;
foreach ($data['child'] as $r) {
if ($r['user_id']) {
$user = "******";
} else {
$user = '******';
}
echo "<tr>\n\t\t\t\t\t\t\t\t<td>{$user}<br />" . dateToIndo($r['waktu'], true, true) . "</td>\n\t\t\t\t\t\t\t\t<td>" . nl2br($r['isi']) . "</td>\n\t\t\t\t\t\t\t\t</tr>";
$n++;
}
?>
</tbody>
</table>
<?php
}
?>
</form>
</div>
<?php
if ($data['parent']['pelanggan_id'] > 0) {
?>
<div class="box-footer">
<form class="cmxform form-horizontal tasi-form" role="form" id="myForm">
},
select: function(event, ui) {
$("#prosid").val(ui.item.prosid);
$('.page-content-area').ace_ajax('startLoading');
$.ajax({
url: '<?php
echo site_url('master_sales/getDataProspek');
?>
',
dataType: 'json',
type: 'POST',
data: {param : ui.item.prosid},
success: function(data) {
var tgl = "";
if (data['pros_tgl_lahir'] != "<?php
echo dateToIndo(DEFAULT_TGL);
?>
") {
var date = data['pros_tgl_lahir'].split("-");
tgl = date['2']+"-"+date['1']+"-"+date['0'];
}
$('#kr_kotaid').html('');
$("#pel_alamat").html(data['pros_alamat']);
$("#propinsi").val(data['kota_propid']);
$("#pel_hp").val(data['pros_hp']);
$("#pel_nomor_id").val(data['prop_nomor_id']);
$("#pel_telpon").val(data['pros_telpon']);
$("#pel_fax").val(data['pros_fax']);
$("#pel_email").val(data['pros_email']);
$("#"+data['pros_gender']).checked = true;
$("#"+data['pros_agama']).checked = true;
<div class="form-group">
<label class="col-sm-2 control-label no-padding-right" for="form-field-1">Tahun</label>
<div class="col-sm-8">
<input type="text" name="msc_tahun" value="<?php
echo $data['msc_tahun'];
?>
" maxlength="4" id="msc_nomesin" placeholder="Tahun" class="number ace col-xs-10 col-sm-2" />
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label no-padding-right" for="form-field-1">STNK Expired</label>
<div class="col-sm-8">
<div class="input-group input-group-sm col-sm-3">
<input type="text" name="msc_stnkexp" value="<?php
if (dateToIndo($data['msc_stnkexp']) != defaultTgl()) {
echo dateToIndo($data['msc_stnkexp']);
}
?>
" id="datepicker" class="datepicker form-control" />
<span class="input-group-addon">
<i class="ace-icon fa fa-calendar"></i>
</span>
</div>
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label no-padding-right" for="form-field-1">Type Pelanggan</label>
<div class="col-sm-8">
<select name="msc_inextern" required="required" id="msc_inextern" class="ace col-xs-10 col-sm-3">
<option value="">Pilih</option>
<option value="1" <?php
public function loadTrans()
{
$page = isset($_POST['page']) ? $_POST['page'] : 1;
$limit = isset($_POST['rows']) ? $_POST['rows'] : 10;
$sidx = isset($_POST['sidx']) ? $_POST['sidx'] : 'kstid';
$sord = isset($_POST['sord']) ? $_POST['sord'] : 'DESC';
$start = $limit * $page - $limit;
$start = $start < 0 ? 0 : $start;
$param = array('start' => $start, 'limit' => $limit, 'sidx' => $sidx, 'sord' => $sord, 'kategori' => isset($_POST['kategori']) ? $_POST['kategori'] : '', 'dateFrom' => isset($_POST['dateFrom']) ? dateToIndo($_POST['dateFrom']) : date('Y-01-01'), 'dateTo' => isset($_POST['dateTo']) ? dateToIndo($_POST['dateTo']) : date('Y-m-d'), 'trans' => isset($_POST['trans']) ? $_POST['trans'] : '', 'type' => isset($_POST['type']) ? $_POST['type'] : '', 'subtrans' => isset($_POST['subtrans']) ? $_POST['subtrans'] : '0', 'key' => isset($_POST['key']) ? $_POST['key'] : '');
$query = $this->model_trfinance->loadSubTrans($param);
$count = $query['numrows'];
if ($count > 0) {
$total_pages = ceil($count / $limit);
} else {
$total_pages = 0;
}
if ($page > $total_pages) {
$page = $total_pages;
}
$responce = new stdClass();
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$i = 0;
if (count($query['result']) > 0) {
foreach ($query['result'] as $row) {
$nominal = $param['type'] == 'I' ? $row->kst_debit : $row->kst_kredit;
$del = "hapusData('" . $row->kstid . "', '" . $row->kst_nomer . "')";
$pr = "cetakData('" . $row->kstid . "', '" . $row->kst_nomer . "')";
$hapus = '<a href="javascript:void(0);" onclick="' . $del . '" title="Hapus"><i class="ace-icon fa fa-trash-o bigger-120 orange"></i>';
$print = '<a href="javascript:void(0);" onclick="' . $pr . '" title="Cetak"><i class="ace-icon fa fa-print bigger-120 blue"></i>';
$detail = '<a href="#transaksi_finance/detailTrans?id=' . $row->kstid . '" title="Detail"><i class="ace-icon glyphicon glyphicon-list bigger-100"></i>';
$edit = '<a href="#transaksi_finance/editTrans?id=' . $row->kstid . '" title="Edit"><i class="ace-icon glyphicon glyphicon-pencil bigger-100"></i>';
$responce->rows[$i]['id'] = $row->kstid;
$responce->rows[$i]['cell'] = array(dateToIndo($row->kst_tgl), strtoupper($row->kst_nomer), $row->kst_coa, $row->kst_desc, number_format($nominal, 2), $row->kst_status, $edit, $detail, $print, $hapus);
$i++;
}
}
echo json_encode($responce);
}
/**
*
* @param type $output
*/
public function showAgendaFaktur($output)
{
$end = dateToIndo($this->input->post('end'));
$start = dateToIndo($this->input->post('start'));
$cabang = ses_cabang;
$this->data['data'] = $this->model_lap_service->getAgendaFakturService($start, $end, $cabang);
$this->data['output'] = $output;
$this->load->view('showAgendaFaktur', $this->data);
}
</div>
<div class="form-group">
<label class="col-sm-2 control-label no-padding-right" for="form-field-1">Tempat Lahir</label>
<div class="col-sm-8">
<input type="text" name="kr_tempat_lahir" value="<?php
echo $kar['kr_tempat_lahir'];
?>
" placeholder="Tempat Lahir" class="ace col-xs-10 col-sm-5 upper req" />
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label no-padding-right" for="form-field-1">Tgl Lahir</label>
<div class="col-sm-8">
<div class="input-group input-group-sm col-sm-2">
<input type="text" name="kr_tgl_lahir" value="<?php
echo dateToIndo($kar['kr_tgl_lahir']);
?>
" id="datepicker" class="form-control" />
<span class="input-group-addon">
<i class="ace-icon fa fa-calendar"></i>
</span>
</div>
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label no-padding-right" for="form-field-1">Email</label>
<div class="col-sm-8">
<input type="text" name="kr_email" value="<?php
echo $kar['kr_email'];
?>
" placeholder="Email" class="ace col-xs-10 col-sm-5" />
?>
</td>
<td><?php
echo $value['sup_nama'];
?>
</td>
<td><?php
echo $value['sup_alamat'];
?>
</td>
<td><?php
echo $value['bpk_nodo'];
?>
</td>
<td><?php
echo dateToIndo($value['bpk_tgldo']) != DEFAULT_TGL ? dateToIndo($value['bpk_tgldo']) : '';
?>
</td>
<td><?php
echo $value['merk_deskripsi'];
?>
</td>
<td><?php
echo $value['model_deskripsi'];
?>
</td>
<td><?php
echo str_replace(' ', ' ', $value['cty_deskripsi']);
?>
</td>
<td><?php
</thead>
<tbody>
<?php
$n = 1;
foreach ($data as $r) {
?>
<tr>
<td><?php
echo $n++;
?>
</td>
<td><?php
echo $r['subject'];
?>
</td>
<td><?php
echo dateToIndo($r['waktu'], true, true);
?>
</td>
<td>
<a href="<?php
echo site_url('shop/detailmessage/' . $r['id']);
?>
" class="btn btn-xs btn-info"><i class="fa fa-search"></i> View</a>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
?>
<tr>
<td><?php
echo $no;
?>
</td>
<td><?php
echo " " . $value['spk_no'];
?>
</td>
<td><?php
echo $value['spk_nokontrak'];
?>
</td>
<td><?php
echo dateToIndo($value['spk_tgl']);
?>
</td>
<td><?php
echo str_replace(' ', ' ', $value['kr_nama']);
?>
</td>
<td><?php
echo str_replace(' ', ' ', $value['pel_nama']);
?>
</td>
<td><?php
echo str_replace(' ', ' ', $value['pel_alamat']);
?>
</td>
<td><?php
public function loadDataFpt()
{
$page = isset($_POST['page']) ? $_POST['page'] : 1;
$limit = isset($_POST['rows']) ? $_POST['rows'] : 10;
$sidx = isset($_POST['sidx']) ? $_POST['sidx'] : 'prosid';
$status = isset($_POST['status']) ? $_POST['status'] : '1';
$sord = isset($_POST['sord']) ? $_POST['sord'] : 'DESC';
$start = $limit * $page - $limit;
$start = $start < 0 ? 0 : $start;
$where = "";
// log_message('error', 'AAAA '.$status);
$searchField = isset($_POST['searchField']) ? $_POST['searchField'] : false;
$searchOper = isset($_POST['searchOper']) ? $_POST['searchOper'] : false;
$searchString = isset($_POST['searchString']) ? $_POST['searchString'] : false;
if ($_POST['_search'] == 'true') {
if ($searchField == 'fpt_approve') {
if (strtoupper($searchString) == 'PROSES') {
$searchString = '1';
} else {
if (strtoupper($searchString) == 'SETUJU') {
$searchString = '2';
} else {
if (strtoupper($searchString) == 'DEAL') {
$searchString = '3';
} else {
if (strtoupper($searchString) == 'TOLAK') {
$searchString = '4';
}
}
}
}
}
$ops = array('eq' => '=', 'ne' => '<>', 'lt' => '<', 'le' => '<=', 'gt' => '>', 'ge' => '>=', 'bw' => 'LIKE', 'bn' => 'NOT LIKE', 'in' => 'LIKE', 'ni' => 'NOT LIKE', 'ew' => 'LIKE', 'en' => 'NOT LIKE', 'cn' => 'LIKE', 'nc' => 'NOT LIKE');
foreach ($ops as $key => $value) {
if ($searchOper == $key) {
$ops = $value;
}
}
if ($searchOper == 'eq') {
$searchString = $searchString;
}
if ($searchOper == 'bw' || $searchOper == 'bn') {
$searchString .= '%';
}
if ($searchOper == 'ew' || $searchOper == 'en') {
$searchString = '%' . $searchString;
}
if ($searchOper == 'cn' || $searchOper == 'nc' || $searchOper == 'in' || $searchOper == 'ni') {
$searchString = '%' . $searchString . '%';
}
$where = "{$searchField} {$ops} '{$searchString}' ";
}
if ($where != '') {
$where .= " AND ";
}
if ($status != '0') {
$where .= " fpt_approve = {$status}";
}
$count = $this->model_prospect->getTotalFpt($where);
if ($count > 0) {
$total_pages = ceil($count / $limit);
} else {
$total_pages = 0;
}
if ($page > $total_pages) {
$page = $total_pages;
}
$query = $this->model_prospect->getDataFpt($start, $limit, $sidx, $sord, $where);
$responce = new stdClass();
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$i = 0;
if (count($query) > 0) {
foreach ($query as $row) {
$validasi = "-";
if ($row->kr_atasan == ses_krid && $row->fpt_approve == 1) {
$val = "validasiData('" . $row->fptid . "','" . $row->pros_nama . "')";
$validasi = '<a href="javascript:void(0);" onclick="' . $val . '" title="Validasi"><i class="ace-icon glyphicon glyphicon-check bigger-110 green"></i>';
}
$edit = '<a href="#transaksi_prospect/editFpt?id=' . $row->fptid . '" title="Edit"><i class="ace-icon glyphicon glyphicon-pencil bigger-110 orange"></i>';
$detail = '<a href="#transaksi_prospect/detailFpt?id=' . $row->fptid . '" title="Detail"><i class="ace-icon glyphicon glyphicon-list bigger-110"></i>';
$print = '<a href="javascript:;" onclick="print(\'' . $row->fptid . '\')" title="Print"><i class="ace-icon glyphicon glyphicon-print bigger-120"></i>';
$responce->rows[$i]['id'] = $row->fptid;
$responce->rows[$i]['cell'] = array($row->fpt_kode, $row->pros_nama, $row->pros_alamat, $row->fpt_status, $row->kr_nama, dateToIndo($row->fpt_tgl), $validasi, $edit, $print, $detail);
$i++;
}
}
echo json_encode($responce);
}
public function saveSubTrans()
{
$main = array('kst_trans' => $this->input->post('trans_trans', TRUE), 'kst_type' => $this->input->post('trans_type', TRUE), 'kst_nomer' => strtoupper($this->input->post('trans_docno', TRUE)), 'kst_noreff' => $this->input->post('trans_noreff', TRUE), 'kst_tgl' => dateToIndo($this->input->post('trans_tgl', TRUE)), 'kst_coa' => $this->input->post('trans_coa', TRUE), 'kst_desc' => strtoupper($this->input->post('trans_desc', TRUE)), 'kst_debit' => numeric($this->input->post('totalTrans', TRUE)), 'kst_kredit' => numeric($this->input->post('totalTrans', TRUE)), 'kst_createon' => date('Y-m-d H:i:s'), 'kst_sub_trans' => $this->input->post('trans_subtrans', TRUE), 'kst_createby' => ses_krid, 'kst_cbid' => ses_cabang);
$detail = array('coa' => $this->input->post('dtrans_coa', TRUE), 'desc' => $this->input->post('trans_desc', TRUE), 'nota' => $this->input->post('dtrans_nota', TRUE), 'pelid' => $this->input->post('dtrans_pelid', TRUE), 'supid' => $this->input->post('dtrans_supid', TRUE), 'ccid' => $this->input->post('dtrans_ccid', TRUE), 'nominal' => $this->input->post('dtrans_nominal', TRUE));
$bank = array('bank' => $this->input->post('dbnk_bankid', TRUE), 'norek' => $this->input->post('dbnk_norek', TRUE), 'nocek' => $this->input->post('dbnk_nocek', TRUE), 'jtempo' => $this->input->post('dbnk_jtempo', TRUE), 'kota' => $this->input->post('dbnk_kotaid', TRUE), 'nominal' => $this->input->post('dbnk_nominal', TRUE));
$etc = array('purpose' => $this->input->post('trans_purpose', TRUE), 'kstid' => $this->input->post('trans_kstid', TRUE));
$save = $this->model_trfinance->addSubTrans($etc, $main, $detail, $bank);
if ($save['status'] == TRUE) {
$result = array('status' => TRUE, 'msg' => $this->sukses($save['msg']));
} else {
$result = array('status' => FALSE, 'msg' => $this->error($save['msg']));
}
echo json_encode($result);
}
<table id="tb" class="table">
<thead>
<tr>
<th>No</th>
<th>Tanggal</th>
<th>No Invoice</th>
<th>Total</th>
<th>Penerima</th>
<th>Status</th>
<th>Detail</th>
</tr>
</thead>
<tbody>
<?php
$n = 1;
foreach ($data->result_array() as $r) {
echo "<tr>\n\t\t<td>{$n}</td>\n\t\t<td>" . dateToIndo($r['tanggal']) . "</td>\n\t\t<td>{$r['no_invoice']}</td>\n\t\t<td>" . numIndo($r['total'], 0) . "</td>\n\t\t<td>{$r['nama']}</td>\n\t\t<td>" . statusOrder($r['status_order']) . "</td>\n\t\t<td><a href='" . site_url('product/invoice') . "/{$r['id']}' class='btn btn-xs btn-info'><i class='fa fa-search'></i> Detail</a></td>\n\t\t</tr>";
$n++;
}
?>
</tbody>
</table>
<script type="text/javascript">
</script>
NAMA SUPERVISOR : <?php
echo $value['supervisor'];
?>
</td>
</tr>
<?php
}
?>
<tr>
<td><?php
echo $no;
?>
</td>
<td><?php
echo dateToIndo($value['pros_tgl']);
?>
</td>
<td><?php
echo $value['kr_nama'];
?>
</td>
<td><?php
echo $value['pros_type'];
?>
</td>
<td><?php
echo $value['pros_nama'] . "</br>" . $value['pros_alamat'] . '</br>' . $value['pros_hp'];
?>
</td>
<!--<td></td>-->
public function addSubTrans($etc = array(), $main = array(), $detail = array(), $bank = array())
{
$this->db->trans_begin();
try {
if ($etc['purpose'] == 'ADD') {
$tahun = date('y');
$main['kstid'] = NUM_TRANS . $tahun . sprintf("%08s", $this->getCounter(NUM_TRANS . $tahun));
if ($main['kst_type'] == 'I') {
$main['kst_kredit'] = 0;
} else {
if ($main['kst_type'] == 'O') {
$main['kst_debit'] = 0;
}
}
$this->addMain($main);
} else {
$this->editMain($main, $etc['kstid']);
$this->flagDetail(0, $etc['kstid']);
$main['kstid'] = $etc['kstid'];
}
if (count($detail) < 1) {
$e = "DETAIL TRANSAKSI KOSONG";
throw new Exception($e);
} else {
if (!empty($detail['nota'][0])) {
for ($i = 0; $i <= count($detail['coa']) - 1; $i++) {
if ($main['kst_trans'] != 'ADJUST') {
if ($main['kst_type'] == 'I') {
$kredit = numeric($detail['nominal'][$i]);
$debit = 0;
} else {
$kredit = 0;
$debit = numeric($detail['nominal'][$i]);
}
} else {
$debit = numeric($detail['debit'][$i]);
$kredit = numeric($detail['kredit'][$i]);
}
if ($this->addDetail(array('dkst_kstid' => $main['kstid'], 'dkst_coa' => $detail['coa'], 'dkst_descrip' => strtoupper($detail['desc']), 'dkst_nota' => strtoupper($detail['nota'][$i]), 'dkst_pelid' => strtoupper($detail['pelid']), 'dkst_supid' => strtoupper($detail['supid']), 'dkst_ccid' => $detail['ccid'], 'dkst_debit' => $debit, 'dkst_kredit' => $kredit, 'dkst_flag' => '1', 'dkst_lastupdate' => date('Y-m-d H:i:s'))) == FALSE) {
throw new Exception('GAGAL TAMBAH DETAIL');
}
$arrLog[] = array("trl_cbid" => ses_cabang, "trl_nomer" => $main['kst_nomer'], 'trl_date' => $main['kst_tgl'], "trl_coa" => $detail['coa'][$i], "trl_descrip" => $detail['desc'], "trl_debit" => $debit, "trl_kredit" => $kredit, "trl_croscoa" => $main['kst_coa'], "trl_nota" => $detail['nota'][$i], "trl_pelid" => $detail['pelid'], "trl_ccid" => $detail['ccid'][$i], "trl_supid" => $detail['supid'][$i], "trl_headstatus" => '0', "trl_name" => $main['kst_trans'], "trl_trans" => $main['kst_type'], "trl_createon" => date('Y-m-d H:i:s'));
if ($main['kst_trans'] != 'ADJ') {
$arrLog[] = array("trl_cbid" => ses_cabang, "trl_nomer" => $main['kst_nomer'], 'trl_date' => $main['kst_tgl'], "trl_coa" => $main['kst_coa'], "trl_descrip" => $detail['desc'], "trl_debit" => $kredit, "trl_kredit" => $debit, "trl_croscoa" => $main['kst_coa'], "trl_nota" => $detail['nota'][$i], "trl_pelid" => $detail['pelid'], "trl_ccid" => $detail['ccid'], "trl_supid" => $detail['supid'], "trl_headstatus" => '1', "trl_name" => $main['kst_trans'], "trl_trans" => $main['kst_type'], "trl_createon" => date('Y-m-d H:i:s'));
}
}
}
}
if (count($bank['bank']) > 0) {
if (!empty($bank['bank'][0])) {
for ($i = 0; $i <= count($bank['bank']) - 1; $i++) {
if ($this->addBank(array('dbnk_kstid' => $main['kstid'], 'dbnk_bankid' => $bank['bank'][$i], 'dbnk_norek' => $bank['norek'][$i], 'dbnk_nocek' => $bank['nocek'][$i], 'dbnk_jtempo' => dateToIndo($bank['jtempo'][$i]), 'dbnk_kotaid' => $bank['kota'][$i], 'dbnk_nominal' => numeric($bank['nominal'][$i]), 'dbnk_flag' => '1', 'dbnk_lastupdate' => date('Y-m-d H:i:s'))) == FALSE) {
throw new Exception('GAGAL TAMBAH DETAIL BANK');
}
}
}
}
/* INSERTING TO LEDGER */
$this->db->insert_batch('ksr_ledger', $arrLog);
if ($this->db->trans_status() == TRUE) {
$this->db->trans_commit();
return array('status' => TRUE, 'msg' => 'INPUT DATA BERHASIL');
} else {
$e = "GAGAL MENYIMPAN DATA";
throw new Exception($e);
}
} catch (Exception $e) {
$this->db->trans_rollback();
return array('status' => FALSE, 'msg' => $e->getMessage());
}
}
<th width="10%">Merk<br>Type<br>Warna</th>
<th width="10%">Diskon<br>Cashback<br>Komisi</th>
<th width="10%">Total Harga<br>Salesman</th>
</tr>
<?php
if (count($data) > 0) {
$no = 1;
foreach ($data as $value) {
?>
<tr>
<td><?php
echo $no;
?>
</td>
<td><?php
echo $value['fpt_kode'] . "<br>" . $value['pros_kode'] . "<br>" . dateToIndo($value['fpt_tgl']);
?>
</td>
<td><?php
echo $value['pros_nama'] . "<br>" . $value['pros_alamat'] . "<br>" . $value['pros_hp'];
?>
</td>
<td><?php
echo $value['merk_deskripsi'] . "<br>" . $value['cty_deskripsi'] . "<br>" . $value['warna_deskripsi'];
?>
</td>
<td style="text-align: right"><?php
echo number_format($value['fpt_diskon']) . "<br>" . number_format($value['fpt_cashback']) . "<br>" . number_format($value['fpt_komisi']);
?>
</td>
<td style="text-align: right"><?php
<div class="form-group">
<label class="col-sm-2 control-label no-padding-right" for="form-field-1">Tempat Lahir</label>
<div class="col-sm-8">
<input type="text" name="pel_tempat_lahir" value="<?php
echo $data['pel_tempat_lahir'];
?>
" placeholder="Tempat Lahir" class="ace col-xs-10 col-sm-5" />
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label no-padding-right" for="form-field-1">Tgl Lahir</label>
<div class="col-sm-8">
<div class="input-group input-group-sm col-sm-2">
<input type="text" name="pel_tgl_lahir" value="<?php
if ($data['pel_tgl_lahir'] != '9999-01-01') {
echo dateToIndo($data['pel_tgl_lahir']);
}
?>
" id="datepicker" class="form-control" />
<span class="input-group-addon">
<i class="ace-icon fa fa-calendar"></i>
</span>
</div>
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label no-padding-right" for="form-field-1">Jenis Kelamin</label>
<div class="col-sm-8">
<div class="radio">
<label>
<input name="pel_gender" type="radio" <?php
/**
*
* @param type $output
*/
public function showAgingStockSparepart($output)
{
$end = dateToIndo($this->input->post('end'));
$start = dateToIndo($this->input->post('start'));
$cabang = ses_cabang;
$this->data['start'] = $start;
$this->data['end'] = $end;
$this->data['cabang'] = $cabang;
$datesa = date("Y-m-d", mktime(0, 0, 0, date("m", strtotime($start)), date("d", strtotime($start)) - 1, date("Y", strtotime($start))));
$this->data['sa'] = $this->model_lap_sparepart->getRekapPosisiStock($datesa, $cabang, '', '');
$this->data['beli'] = $this->model_lap_sparepart->getTotalPembelian($start, $end, $cabang);
$this->data['jual'] = $this->model_lap_sparepart->getTotalPenjualanSupply($start, $end, $cabang);
$this->data['adj'] = $this->model_lap_sparepart->getTotalAdjustmentStock($start, $end, $cabang);
$this->data['returJual'] = $this->model_lap_sparepart->getTotalReturPenjualan($start, $end, $cabang);
$this->data['returBeli'] = $this->model_lap_sparepart->getTotalReturPembelian($start, $end, $cabang);
$this->data['moving'] = $this->model_lap_sparepart->getMovingPart2($start, $end, $cabang);
$this->data['output'] = $output;
$this->load->view('showAgingStockSparepart', $this->data);
}
/**
*
* @param type $output
*/
public function showFakturPenjualan($output)
{
$end = dateToIndo($this->input->post('end'));
$start = dateToIndo($this->input->post('start'));
$cabang = ses_cabang;
$this->data['data'] = $this->model_lap_sales->getFakturPenjualan($start, $end, $cabang);
$this->data['output'] = $output;
$this->load->view('showFakturPenjualan', $this->data);
}
<br />
<b>Tanggal Transaksi</b> <?php
echo dateToIndo($_POST['tanggal']);
?>
<table width="100%" border="1" cellspacing="1" cellpadding="2" rules="all">
<tr>
<th>No Trx</th>
<th>Kode Barang</th>
<th>Harga Jual</th>
<th>Qty</th>
<th>Sub Total</th>
</tr>
<?php
$total = 0;
$qtyTotal = 0;
foreach ($data->result_array() as $r) {
$subTotal = $r['qty'] * $r['harga'];
$total += $subTotal;
$qtyTotal += $r['qty'];
?>
<tr>
<td><?php
echo $r['no_trx'];
?>
</td>
<td><?php
echo $r['kode_barang'];
?>
</td>
<td><?php
echo numIndoNull($r['harga'], 0);
<div class="form-group">
<label class="col-sm-2 control-label no-padding-right" for="form-field-1">Tempat Lahir</label>
<div class="col-sm-8">
<input type="text" name="pros_tempat_lahir" value="<?php
echo $data['pros_tempat_lahir'];
?>
" placeholder="Tempat Lahir" class="ace col-xs-10 col-sm-5 upper" />
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label no-padding-right" for="form-field-1">Tgl Lahir</label>
<div class="col-sm-2">
<div class="input-group">
<input type="text" name="pros_tgl_lahir" value="<?php
if ($data['pros_tgl_lahir'] != dateToIndo(DEFAULT_TGL)) {
echo dateToIndo($data['pros_tgl_lahir']);
}
?>
" id="datepicker" readonly="readonly" class="form-control" />
<span class="input-group-addon">
<i class="ace-icon fa fa-calendar" style="width: 12px;"></i>
</span>
</div>
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label no-padding-right" for="form-field-1">Jenis Kelamin</label>
<div class="col-sm-8">
<div class="radio">
<label>
<input name="pros_gender" <?php
<div class="tab-pane fade" id="reviews" >
<div class="col-sm-12">
<?php
foreach ($this->auth->getReviews($data['id']) as $r) {
?>
<ul>
<li><a href=""><i class="fa fa-user"></i><?php
echo $r['nama'];
?>
</a></li>
<li><i class="fa fa-inbox"></i> <?php
echo strtolower($r['email']);
?>
</li>
<li><a href=""><i class="fa fa-calendar-o"></i><?php
echo dateToIndo($r['updated_at']);
?>
</a></li>
</ul>
<p><?php
echo nl2br($r['isi']);
?>
</p>
<?php
}
?>
<hr />
<p><b>Write Your Review</b></p>
<form action="<?php
echo site_url('product/review/' . $data['id']);
?>
<th width="125">Aksi</th>
</tr>
</thead>
<tbody>
<?php
$no = 1;
foreach ($data as $r) {
$status = $r['is_aktif'] == 1 ? 'Aktif' : 'Non Aktif';
?>
<tr>
<td><?php
echo $no++;
?>
</td>
<td><?php
echo dateToIndo($r['tanggal']);
?>
</td>
<td><?php
echo $r['judul'];
?>
</td>
<td><?php
echo $status;
?>
</td>
<td>
<a href="<?php
echo "{$link}/form/{$r['id']}";
?>
" class="btn btn-xs btn-info"><i class="fa fa-edit"></i> Edit</a>
/**
* Function ini digunakan untuk menyimpan karyawan
*/
public function simpanKaryawan()
{
$this->form_validation->set_rules('kr_nama', '<b>Fx</b>', 'xss_clean');
if ($this->form_validation->run() == TRUE) {
$data = array('kr_nik' => $this->input->post('kr_nik'), 'kr_nama' => $this->input->post('kr_nama'), 'kr_alamat' => $this->input->post('kr_alamat'), 'kr_jabatanid' => $this->input->post('kr_jabatanid'), 'kr_nomorktp' => $this->input->post('kr_nomorktp'), 'kr_cbid' => $this->input->post('kr_cbid'), 'kr_username' => $this->input->post('kr_username'), 'kr_password' => sha1('123456'), 'kr_hp' => $this->input->post('kr_hp'), 'kr_email' => $this->input->post('kr_email'), 'kr_tempat_lahir' => $this->input->post('kr_tempat_lahir'), 'kr_tgl_lahir' => dateToIndo($this->input->post('kr_tgl_lahir')));
$hasil = $this->model_admin->simpanKaryawan($data);
if ($hasil) {
$this->session->set_flashdata('msg', $this->sukses("Berhasil menyimpan karyawan"));
} else {
$this->session->set_flashdata('msg', $this->error("Gagal menyimpan karyawan"));
}
}
redirect('administrator/karyawan');
}
function saveNoKontrak()
{
$this->load->library('form_validation');
$this->form_validation->set_rules('pel_nama', '<b>Fx</b>', 'xss_clean');
if ($this->form_validation->run() == TRUE) {
$tgl = $this->input->post('pel_tgl_lahir');
if (empty($tgl)) {
$tgl = defaultTgl();
}
$data = array('pel_cbid' => ses_cabang, 'pel_prosid' => strtoupper($this->input->post('prosid')), 'pel_nama' => strtoupper($this->input->post('pel_nama')), 'pel_alamat' => strtoupper($this->input->post('pel_alamat')), 'pel_gender' => $this->input->post('pel_gender'), 'pel_kotaid' => $this->input->post('pel_kotaid'), 'pel_type' => $this->input->post('pel_type'), 'pel_alamat_surat' => $this->input->post('pel_alamat_surat'), 'pel_hp' => $this->input->post('pel_hp'), 'pel_nomor_id' => $this->input->post('pel_nomor_id'), 'pel_telpon' => $this->input->post('pel_telpon'), 'pel_fax' => $this->input->post('pel_fax'), 'pel_tempat_lahir' => strtoupper($this->input->post('pel_tempat_lahir')), 'pel_tgl_lahir' => dateToIndo($tgl), 'pel_email' => $this->input->post('pel_email'), 'pel_agama' => $this->input->post('pel_agama'));
$kontrak = $this->input->post('kon_nomer');
$hasil = $this->model_sales->saveNoKontrak($data, $kontrak);
$retur = array();
if ($hasil) {
$retur['result'] = true;
$this->session->set_flashdata('msg', $this->sukses('Berhasil menambah kontrak'));
$retur['msg'] = $this->sukses("Berhasil menyimpan kontrak");
} else {
$retur['result'] = false;
$this->session->set_flashdata('msg', $this->error('Gagal menambah kontrak'));
$retur['msg'] = $this->error("Gagal menyimpan kontrak");
}
}
echo json_encode($retur);
}
<section class="content-header">
<h1>
<?php
echo $title;
?>
<small>
<?php
echo dateToIndo(date("Y-m-d"));
?>
<b>(Saldo Awal Anda)</b>
<input class="form-control input-sm" name="saldo_awal" id="saldo_awal" value="{so}" style="font-size:16px" />
</small>
</h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-th"></i> Transaksi</a></li>
<li><a href="<?php
echo base_url($link);
?>
"><i class="fa fa-angle-double-right"></i> <?php
echo $title;
?>
</a></li>
</ol>
</section>
<section class="content">
<div class="row">
<?php
$this->load->view($link . '/pencarian');
?>
</div>
<div class="row">
public function rugilabaShow($output)
{
$bulan = dateToIndo($this->input->post('bulan', TRUE));
$cbid = $this->input->post('cbid', TRUE);
$tgl = explode('-', $bulan);
$month = $tgl['0'];
$year = $tgl['1'];
$output = $this->uri->segment(3);
$this->data['cabang'] = $this->model_lap_finance->getDetailCabang($cbid);
log_message('error', 'CEK : ' . $this->db->last_query());
$this->data['etc'] = array('judul' => 'RUGI LABA', 'targetLoad' => 'rugilabaShow', 'output' => $output, 'periode' => $bulan);
$datasubject = array('month' => $month, 'year' => $year, 'cbid' => $cbid);
$datasubject['jenis'] = 'JC15';
$this->data['penjualan'] = $this->model_lap_finance->loadRugiLaba($datasubject);
$datasubject['jenis'] = 'JC17';
$this->data['pendapatan'] = $this->model_lap_finance->loadRugiLaba($datasubject);
$datasubject['jenis'] = 'JC19';
$this->data['biayaProduksi'] = $this->model_lap_finance->loadRugiLaba($datasubject);
$datasubject['jenis'] = 'JC16';
$this->data['hpp'] = $this->model_lap_finance->loadRugiLaba($datasubject);
$datasubject['jenis'] = 'JC20';
$this->data['biayaUsaha'] = $this->model_lap_finance->loadRugiLaba($datasubject);
$datasubject['jenis'] = 'JC21';
$this->data['biayaOperasional'] = $this->model_lap_finance->loadRugiLaba($datasubject);
$datasubject['jenis'] = 'JC22';
$this->data['biayaNonOperasional'] = $this->model_lap_finance->loadRugiLaba($datasubject);
$datasubject['jenis'] = 'JC23';
$this->data['pendapatanLuarUsaha'] = $this->model_lap_finance->loadRugiLaba($datasubject);
$this->load->view('rugilabaShow', $this->data);
}
/**
* Function ini digunakan untuk menyimpan karyawan
*/
public function updateKaryawan()
{
$this->form_validation->set_rules('kr_nama', '<b>Fx</b>', 'xss_clean');
if ($this->form_validation->run() == TRUE) {
$tgl = $this->input->post('kr_tgl_lahir');
if (empty($tgl)) {
$tgl = defaultTgl();
}
// $kota = $this->input->post('kr_kotaid');
// log_message('error', 'KOTA '.$kota);
$data = array('krid' => $this->input->post('krid'), 'kr_nik' => $this->input->post('kr_nik'), 'kr_nama' => strtoupper($this->input->post('kr_nama')), 'kr_kotaid' => $this->input->post('kr_kotaid'), 'kr_alamat' => strtoupper($this->input->post('kr_alamat')), 'kr_jabid' => $this->input->post('kr_jabid'), 'kr_atasan' => $this->input->post('kr_atasanid'), 'kr_nomor_ktp' => $this->input->post('kr_nomor_ktp'), 'kr_cbid' => $this->input->post('kr_cbid'), 'kr_username' => $this->input->post('kr_username'), 'kr_password' => sha1('123456'), 'kr_hp' => $this->input->post('kr_hp'), 'kr_email' => $this->input->post('kr_email'), 'kr_tempat_lahir' => strtoupper($this->input->post('kr_tempat_lahir')), 'kr_tgl_lahir' => dateToIndo($tgl));
$hasil = $this->model_admin->updateKaryawan($data);
if ($hasil) {
$hasil = $this->sukses("Berhasil menyimpan karyawan");
} else {
$hasil = $this->error("Gagal menyimpan karyawan");
}
}
echo json_encode($hasil);
}
