public function loadProspect() { $page = isset($_POST['page']) ? $_POST['page'] : 1; $limit = isset($_POST['rows']) ? $_POST['rows'] : 10; $sidx = isset($_POST['sidx']) ? $_POST['sidx'] : 'prosid'; $sord = isset($_POST['sord']) ? $_POST['sord'] : 'DESC'; $start = $limit * $page - $limit; $start = $start < 0 ? 0 : $start; $where = whereLoad(); $count = $this->model_prospect->getTotalProspect($where); if ($count > 0) { $total_pages = ceil($count / $limit); } else { $total_pages = 0; } if ($page > $total_pages) { $page = $total_pages; } $query = $this->model_prospect->getDataProspect($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) { $del = "hapusData('" . $row->prosid . "','" . $row->pros_nama . "')"; $hapus = '<a href="javascript:void(0);" onclick="' . $del . '" title="Hapus"><i class="ace-icon fa fa-trash-o bigger-120 orange"></i>'; $agenda = '-'; $fpt = '-'; $edit = '-'; $detail = '<a href="#transaksi_prospect/detailProspect?id=' . $row->prosid . '" title="Detail"><i class="ace-icon glyphicon glyphicon-list bigger-100"></i>'; if ($row->pros_salesman == ses_krid) { $agenda = '<a href="#transaksi_prospect/agendaProspect?id=' . $row->prosid . '" title="Agenda"><i class="ace-icon fa fa-calendar"></i>'; if ($row->warm > 0) { $fpt = '<a href="#transaksi_prospect/addFpt?id=' . $row->prosid . '" title="FPT"><i class="ace-icon fa fa-book bigger-100"></i>'; } $edit = '<a href="#transaksi_prospect/editProspect?id=' . $row->prosid . '" title="Edit"><i class="ace-icon glyphicon glyphicon-pencil bigger-100"></i>'; } $responce->rows[$i]['id'] = $row->prosid; if ($row->deal > 0) { $status = '<img src="' . path_img() . 'hot_deal.png" width=20;height=20;>'; } else { if ($row->hot > 0) { $status = '<img src="' . path_img() . 'hot.png" width=20;height=20;>'; } else { if ($row->warm > 0) { $status = '<img src="' . path_img() . 'warm.png" width=20;height=20;>'; } else { $status = '<img src="' . path_img() . 'prospek.png" width=20;height=20;>'; } } } $responce->rows[$i]['cell'] = array($row->pros_kode, $row->pros_nama, $row->kr_nama, $status, $agenda, $fpt, $edit, $detail); $i++; } } echo json_encode($responce); }
public function loadStockUnit() { $page = isset($_POST['page']) ? $_POST['page'] : 1; $limit = isset($_POST['rows']) ? $_POST['rows'] : 10; $sidx = isset($_POST['sidx']) ? $_POST['sidx'] : 'merkid'; $sord = isset($_POST['sord']) ? $_POST['sord'] : ''; $start = $limit * $page - $limit; $start = $start < 0 ? 0 : $start; $where = whereLoad(); $count = $this->model_sales->getTotalStockUnit($where); if ($count > 0) { $total_pages = ceil($count / $limit); } else { $total_pages = 0; } if ($page > $total_pages) { $page = $total_pages; } $query = $this->model_sales->getDataStockUnit($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) { $del = "hapusData('" . $row->mscid . "', '" . $row->cty_deskripsi . "')"; $hapus = '<a href="javascript:void(0);" onclick="' . $del . '" title="Hapus"><i class="ace-icon fa fa-trash-o bigger-120 orange"></i>'; $edit = '<a href="#master_sales/editStockUnit?id=' . $row->mscid . '" title="Edit"><i class="ace-icon glyphicon glyphicon-pencil bigger-100"></i>'; $view = '<a href="#master_sales/viewStockUnit?id=' . $row->mscid . '" title="View"><i class="ace-icon glyphicon glyphicon-list bigger-100"></i>'; $responce->rows[$i]['id'] = $row->mscid; $responce->rows[$i]['cell'] = array($view, $edit, $hapus, $row->merk_deskripsi, $row->cty_deskripsi, $row->warna_deskripsi, $row->msc_norangka, $row->msc_nomesin, $row->msc_kondisi); $i++; } } echo json_encode($responce); }
function loadRak() { $page = isset($_POST['page']) ? $_POST['page'] : 1; $limit = isset($_POST['rows']) ? $_POST['rows'] : 10; $sidx = isset($_POST['sidx']) ? $_POST['sidx'] : 'gdg_deskripsi'; $sord = isset($_POST['sord']) ? $_POST['sord'] : ''; $start = $limit * $page - $limit; $start = $start < 0 ? 0 : $start; $where = whereLoad(); $this->load->model('model_sparepart'); $count = $this->model_sparepart->getTotalRak($where); if ($count > 0) { $total_pages = ceil($count / $limit); } else { $total_pages = 0; } if ($page > $total_pages) { $page = $total_pages; } $query = $this->model_sparepart->getAllRak($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) { $del = "hapusRak('" . $row->rakid . "')"; $hapus = '<a href="javascript:;" onclick="' . $del . '" title="Hapus"><i class="ace-icon fa fa-trash-o bigger-120 orange"></i>'; $edit = '<a href="#master_sparepart/editRak?id=' . $row->rakid . '" title="edit"><i class="ace-icon glyphicon glyphicon-pencil bigger-100"></i>'; $responce->rows[$i]['id'] = $row->gdgid; $responce->rows[$i]['cell'] = array($row->rak_deskripsi, $row->gdg_deskripsi, $edit); $i++; } } echo json_encode($responce); }
public function loadTipeJurnal() { $page = isset($_POST['page']) ? $_POST['page'] : 1; $limit = isset($_POST['rows']) ? $_POST['rows'] : 10; $sidx = isset($_POST['sidx']) ? $_POST['sidx'] : 'ccid'; $sord = isset($_POST['sord']) ? $_POST['sord'] : ''; $start = $limit * $page - $limit; $start = $start < 0 ? 0 : $start; $where = whereLoad(); $count = $this->model_finance->getTotalTipeJurnal($where); if ($count > 0) { $total_pages = ceil($count / $limit); } else { $total_pages = 0; } if ($page > $total_pages) { $page = $total_pages; } $query = $this->model_finance->getDataTipeJurnal($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) { $del = "hapusData('" . $row->tipeid . "', '" . $row->tipe_deskripsi . "')"; $vie = "viewData('" . $row->tipeid . "', '" . $row->tipe_deskripsi . "')"; $hapus = '<a href="javascript:void(0);" onclick="' . $del . '" title="Hapus"><i class="ace-icon fa fa-trash-o bigger-120 orange"></i>'; $viewjurnal = '<a href="javascript:void(0);" onclick="' . $del . '" title="View"><i class="ace-icon fa fa-book bigger-120 orange"></i>'; $edit = '<a href="#master_finance/editTipeJurnal?id=' . $row->tipeid . '" title="Edit"><i class="ace-icon glyphicon glyphicon-pencil bigger-100"></i>'; $setjurnal = '<a href="#master_finance/setTipeJurnal?id=' . $row->tipeid . '" title="Setting"><i class="ace-icon glyphicon glyphicon-list bigger-100"></i>'; $responce->rows[$i]['id'] = $row->tipeid; $responce->rows[$i]['cell'] = array($row->tipeid, $row->tipe_postcode, $row->tipe_deskripsi, $viewjurnal, $setjurnal, $edit); $i++; } } echo json_encode($responce); }
/** * */ function loadFakturSparepart() { $page = isset($_POST['page']) ? $_POST['page'] : 1; $limit = isset($_POST['rows']) ? $_POST['rows'] : 10; $sidx = isset($_POST['sidx']) ? $_POST['sidx'] : 'not_nomer'; $sord = isset($_POST['sord']) ? $_POST['sord'] : ''; $start = $limit * $page - $limit; $start = $start < 0 ? 0 : $start; $where = whereLoad(); $count = $this->model_util_sparepart->getTotalFaktur($where); if ($count > 0) { $total_pages = ceil($count / $limit); } else { $total_pages = 0; } if ($page > $total_pages) { $page = $total_pages; } $query = $this->model_util_sparepart->getAllFaktur($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) { $print = '<a href="javascript:;" onclick="print(\'' . $row->notid . '\',' . $i . ')" title="Print"><i class="ace-icon glyphicon glyphicon-print bigger-120"></i>'; $responce->rows[$i]['id'] = $row->notid; $responce->rows[$i]['cell'] = array($row->not_nomer, $row->spp_noslip, date('d-m-Y', strtotime($row->not_tgl)), $row->pel_nama, number_format($row->not_total), $print); $i++; } } echo json_encode($responce); }
function loadDataWo() { $page = isset($_POST['page']) ? $_POST['page'] : 1; $limit = isset($_POST['rows']) ? $_POST['rows'] : 10; $sidx = isset($_POST['sidx']) ? $_POST['sidx'] : 'wo_nomer'; $sord = isset($_POST['sord']) ? $_POST['sord'] : ''; $start = $limit * $page - $limit; $start = $start < 0 ? 0 : $start; $where = whereLoad(); $count = $this->model_trservice->getTotalWo($where); if ($count > 0) { $total_pages = ceil($count / $limit); } else { $total_pages = 0; } if ($page > $total_pages) { $page = $total_pages; } $query = $this->model_trservice->getAllWo($start, $limit, $sidx, $sord, $where); $mekanik = $this->model_trservice->getDataMekanik(); $mek = "<option value=''>Pilih Mekanik</option>"; if (count($mekanik) > 0) { foreach ($mekanik as $list) { $mek .= "<option value='" . $list['krid'] . "' >" . $list['kr_nama'] . "</option>"; } } $responce = new stdClass(); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $i = 0; if (count($query) > 0) { foreach ($query as $row) { $mknk = ''; $pending = '-'; $clock = "<label><input class='ace ace-switch btn-rotate' id='cek{$i}' onclick='clocking(\"" . $i . "\",\"" . $row['cloid'] . "\")' type='checkbox' name='cek[]'><span class='lbl'></span></label>"; if ($row['clo_status'] == '0') { $status = 'BELUM CLOCK ON'; $mknk = "<select id='krid{$i}' name='krid' class='ace col-xs-10 col-sm-10' style='width: 100%'>" . $mek . "</select>"; } else { if ($row['clo_status'] == '1') { $status = 'PROSES PENGERJAAN'; $clock = "<label><input checked class='ace ace-switch btn-rotate' id='cek{$i}' onclick='clocking(\"" . $i . "\",\"" . $row['cloid'] . "\")' type='checkbox' name='cek[]'><span class='lbl'></span></label>"; $pending = "<a href='javascript:;' title='Pending' onclick='pending(\"" . $i . "\",\"" . $row['cloid'] . "\")'><i class='green ace-icon glyphicon glyphicon-off'></i></a>"; $mknk = $row['kr_nama']; } else { if ($row['clo_status'] == '2') { $status = 'PENDING'; $mknk = "<select id='krid{$i}' name='krid' class='ace col-xs-10 col-sm-10' style='width: 100%'>" . $mek . "</select>"; } else { $status = 'SELESAI'; $clock = 'PROSES NOTA'; $mknk = $row['kr_nama']; } } } $responce->rows[$i]['id'] = $row['woid']; $responce->rows[$i]['cell'] = array($row['wo_nomer'], $row['msc_nopol'], $row['pel_nama'], $status, $mknk, $clock, $pending); $i++; } } echo json_encode($responce); }
/** * */ function loadFakturService() { $page = isset($_POST['page']) ? $_POST['page'] : 1; $limit = isset($_POST['rows']) ? $_POST['rows'] : 10; $sidx = isset($_POST['sidx']) ? $_POST['sidx'] : 'wo_nomer'; $sord = isset($_POST['sord']) ? $_POST['sord'] : ''; $start = $limit * $page - $limit; $start = $start < 0 ? 0 : $start; $where = whereLoad(); $count = $this->model_util_service->getTotalFakturService($where); if ($count > 0) { $total_pages = ceil($count / $limit); } else { $total_pages = 0; } if ($page > $total_pages) { $page = $total_pages; } $query = $this->model_util_service->getAllFakturService($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) { $batal = '-'; if ($row->inv_status == 0) { $batal = '<a href="javascript:;" onclick="batal(\'' . $row->invid . '\',\'' . $row->woid . '\')" title="Hapus"><i class="ace-icon fa fa-trash-o bigger-120 orange"></i>'; } $print = '<a href="javascript:;" onclick="print(\'' . $row->invid . '\')" title="Print"><i class="ace-icon glyphicon glyphicon-print bigger-120"></i>'; $responce->rows[$i]['id'] = $row->invid; $responce->rows[$i]['cell'] = array($row->wo_nomer, $row->pel_nama, date('d-m-Y', strtotime($row->inv_tgl)), $row->msc_nopol, $row->msc_nomesin, '<input type="text" autocomplete="off" id="alasan' . $row->invid . '" name="alasan' . $row->invid . '" class="col-xs-10 col-sm-10 upper" style="width:100%" />', $batal, $print); $i++; } } echo json_encode($responce); }
public function loadBisnis() { $page = isset($_POST['page']) ? $_POST['page'] : 1; $limit = isset($_POST['rows']) ? $_POST['rows'] : 10; $sidx = isset($_POST['sidx']) ? $_POST['sidx'] : 'areaid'; $sord = isset($_POST['sord']) ? $_POST['sord'] : ''; $start = $limit * $page - $limit; $start = $start < 0 ? 0 : $start; $where = whereLoad(); $count = $this->model_prospect->getTotalBisnis($where); if ($count > 0) { $total_pages = ceil($count / $limit); } else { $total_pages = 0; } if ($page > $total_pages) { $page = $total_pages; } $query = $this->model_prospect->getDataBisnis($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) { $del = "hapusData('" . $row->bisnisid . "', '" . $row->bisnis_nama . "')"; $hapus = '<a href="javascript:void(0);" onclick="' . $del . '" title="Hapus"><i class="ace-icon fa fa-trash-o bigger-120 orange"></i>'; $edit = '<a href="#master_prospect/editBisnis?id=' . $row->bisnisid . '" title="Edit"><i class="ace-icon glyphicon glyphicon-pencil bigger-100"></i>'; $responce->rows[$i]['id'] = $row->bisnisid; $responce->rows[$i]['cell'] = array($row->bisnis_nama, $row->bisnis_deskripsi, $edit, $hapus); $i++; } } echo json_encode($responce); }
public function loadFpk() { $page = isset($_POST['page']) ? $_POST['page'] : 1; $limit = isset($_POST['rows']) ? $_POST['rows'] : 10; $sidx = isset($_POST['sidx']) ? $_POST['sidx'] : 'fpkid'; $sord = isset($_POST['sord']) ? $_POST['sord'] : ''; $start = $limit * $page - $limit; $start = $start < 0 ? 0 : $start; $where = whereLoad(); $count = $this->model_trsales->getTotalFpk($where); if ($count > 0) { $total_pages = ceil($count / $limit); } else { $total_pages = 0; } if ($page > $total_pages) { $page = $total_pages; } $query = $this->model_trsales->getAllFpk($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) { $del = "hapus('" . $row->fpkid . "')"; $hapus = '<a href="javascript:void(0);" onclick="' . $del . '" title="Hapus"><i class="ace-icon fa fa-trash bigger-120 red"></i>'; $print = '<a href="javascript:void(0);" onclick="print(\'' . $row->fpkid . '\')" title="Print"><i class="ace-icon fa fa-print bigger-120 green"></i>'; $edit = '<a href="#transaksi_sales/editPoLeasing?id=' . $row->fpkid . '" title="View"><i class="ace-icon glyphicon glyphicon-pencil bigger-100"></i>'; $responce->rows[$i]['id'] = $row->fpkid; $responce->rows[$i]['cell'] = array($row->fpk_no, date('d-m-Y', strtotime($row->fpk_tgl)), $row->spk_no, $row->spk_nokontrak, $row->leas_nama, $edit, $print, $hapus); $i++; } } echo json_encode($responce); }