public function get_clonejho()
{
$checkouts = Checkin::all();
foreach ($checkouts as $a) {
$chk = Checkin::where('fleet_id', '=', $a->fleet_id)->where('operasi_time', '=', $a->operasi_time)->first();
$chk->jho_id = $a->jho_id;
}
}
/**
* Check-in a new device and add it to the user.
*
* @param string $device_type
* The device type name as in /devices (ex. galaxy-nexus).
*
* @param string $device_name
* A human readable name of the device, so that the user can identify his device.
*
* @param string $device_local
* The value to set local to.
*
* @throws DeviceManagerException
* If inserting a record for the new device fails.
*/
public function checkinNewDevice($device_type, $device_name, $device_local)
{
// Check-in new device.
$checkin = new Checkin($this->login);
$checkin->changeDevice($device_type);
$checkin->local = $device_local;
$deviceid = $checkin->checkin();
$sql = <<<'EOF'
INSERT INTO devices(owner, name, deviceid)
VALUES(:uid, :name, :deviceid)
EOF;
$db = DB::getInstance()->db;
$sth = $db->prepare($sql);
$sth->bindValue(':uid', $this->user->uid, SQLITE3_INTEGER);
$sth->bindValue(':name', $device_name, SQLITE3_TEXT);
$sth->bindValue(':deviceid', $deviceid, SQLITE3_TEXT);
if ($status = $sth->execute() === FALSE) {
throw new DeviceManagerException(_('Could not create a record for the new device in the DB.'));
}
}
public function post_reporthutang()
{
$msg = null;
$pool_id = Auth::user()->pool_id;
$date = Input::get('dateops', date('Y-m-d'));
$shift_id = Input::get('shift_id');
$page = Input::get('page');
$limit = Input::get('rows');
$sidx = Input::get('sidx', 'operasi_time');
$sord = Input::get('sord', 'asc');
if ($shift_id == 'all') {
$count = Checkin::join('ksos', 'ksos.id', '=', 'kso_id')->where('checkins.operasi_time', '<=', $date)->where('ksos.pool_id', '=', Auth::user()->pool_id)->where('ksos.actived', '=', 1)->group_by('kso_id')->count();
} else {
$count = Checkin::join('ksos', 'ksos.id', '=', 'kso_id')->where('checkins.operasi_time', '<=', $date)->where('checkins.shift_id', '=', $shift_id)->where('ksos.pool_id', '=', Auth::user()->pool_id)->where('ksos.actived', '=', 1)->group_by('kso_id')->count();
}
if ($count > 0) {
$total_pages = ceil($count / $limit);
} else {
$total_pages = 0;
}
if ($page > $total_pages) {
$page = $total_pages;
}
$start = $limit * $page - $limit;
if ($start < 0) {
$start = 0;
}
$saldohutangbymonth = $this->sqlData($date, $pool_id, $shift_id, $start, $limit);
$responce['page'] = $page;
$responce['total'] = $total_pages;
$responce['records'] = $count;
if ($saldohutangbymonth) {
$no = $start + 1;
$ksavr = 0;
$selisiavr = 0;
$setoranopsavr = 0;
$totalavr = 0;
$cicilanksavr = 0;
$dendaavr = 0;
$cicilan_dp_ksoavr = 0;
foreach ($saldohutangbymonth as $finan) {
$saldosp = $finan->tabungan_sparepart + $finan->hutang_dp_sparepart + $finan->cicilan_sparepart - $finan->pemakaian_part;
$responce['rows'][] = array('no' => $no++, 'taxi_number' => ($c = Fleet::find($finan->fleet_id)) ? $c->taxi_number : 'Body Error', 'bravo' => ($b = Driver::find($finan->bravo_driver_id)) ? $b->name : 'Bravo Error', 'shift_id' => Shift::find($finan->shift_id)->shift, 'pemakaian_sp' => $finan->pemakaian_part, 'tabungan_sp' => $finan->tabungan_sparepart, 'bayar_sp' => $finan->hutang_dp_sparepart + $finan->cicilan_sparepart, 'saldo_sp' => $saldosp, 'ks' => $finan->ks, 'bayar_ks' => $finan->cicilan_ks, 'selisi_ks' => $finan->selisi_ks, 'saldo_armada' => $saldosp + $finan->selisi_ks);
}
}
return json_encode($responce);
}
public function post_toolspj()
{
$date = Input::get('tanggal', date('Y-m-d'));
ini_set('max_execution_time', 120);
$timestamp = strtotime($date);
//list armada on schedule
$arrayschedule = array();
$schedule = Schedule::where('month', '=', date('n', $timestamp))->where('year', '=', date('Y', $timestamp))->get(array('id', 'fleet_id'));
foreach ($schedule as $sc) {
$arrayschedule[] = $sc->id;
}
$fleets = array();
if (is_array($arrayschedule) && !empty($arrayschedule)) {
$fleets = Scheduledate::join('schedules', 'schedules.id', '=', 'schedule_dates.schedule_id')->join('fleets', 'fleets.id', '=', 'schedules.fleet_id')->join('ksos', 'ksos.fleet_id', '=', 'schedules.fleet_id')->where_in('schedule_dates.schedule_id', $arrayschedule)->where('schedules.pool_id', '=', Auth::user()->pool_id)->where('schedule_dates.date', '=', date('j', $timestamp))->where('schedules.month', '=', date('n', $timestamp))->where('schedule_dates.shift_id', '=', 1)->where('ksos.actived', '=', 1)->order_by('fleets.taxi_number', 'asc')->get(array('schedule_dates.id as id', 'schedule_dates.driver_id', 'schedules.fleet_id', 'fleets.taxi_number'));
}
if ($fleets) {
foreach ($fleets as $f) {
$scheduledate = Scheduledate::find($f->id);
$scheduledate->fg_check = 1;
$scheduledate->save();
$schedule = Schedule::find($scheduledate->schedule_id);
//$driverinfo = Driver::find($scheduledate->driver_id);
//$fleetinfo = Fleet::find($schedule->fleet_id);
$ksoinfo = Kso::where_fleet_id($schedule->fleet_id)->where_actived(1)->first();
$dateopertion = mktime(0, 0, 0, $schedule->month, $scheduledate->date, $schedule->year);
$checkouts = Checkout::where_fleet_id($schedule->fleet_id)->where_operasi_time(date('Y-m-d', $dateopertion))->first();
//delete checkouts
if ($checkouts) {
$checkouts->delete();
}
$codeops = 1;
$status = 7;
$keterangan = 'Print SPJ melalui Tools';
if (!$checkouts) {
//insert into to checkouts step
$checkouts = new Checkout();
$checkouts->kso_id = $ksoinfo->id;
$checkouts->operasi_time = date('Y-m-d', $dateopertion);
$checkouts->fleet_id = $schedule->fleet_id;
$checkouts->driver_id = $scheduledate->driver_id;
$checkouts->checkout_step_id = $status;
$checkouts->shift_id = $scheduledate->shift_id;
$checkouts->user_id = Auth::user()->id;
$checkouts->pool_id = Auth::user()->pool_id;
$checkouts->printspj_time = date('Y-m-d H:i:s', Myfungsi::sysdate());
$checkouts->operasi_status_id = $codeops;
$checkouts->keterangan = $keterangan;
$checkouts->save();
$cinada = Checkin::where('operasi_time', '=', date('Y-m-d', $dateopertion))->where('fleet_id', '=', $schedule->fleet_id)->first();
if ($cinada) {
$cinada->delete();
}
if (!$cinada) {
$cin = Checkin::create(array('kso_id' => $ksoinfo->id, 'fleet_id' => $schedule->fleet_id, 'driver_id' => $scheduledate->driver_id, 'checkin_time' => date('Y-m-d H:i:s', Myfungsi::sysdate()), 'shift_id' => $scheduledate->shift_id, 'km_fleet' => 0, 'rit' => 0, 'incomekm' => 0, 'operasi_time' => date('Y-m-d', $dateopertion), 'pool_id' => Auth::user()->pool_id, 'operasi_status_id' => $codeops, 'fg_late' => '', 'checkin_step_id' => 2, 'document_check_user_id' => Auth::user()->id, 'physic_check_user_id' => '', 'bengkel_check_user_id' => '', 'finance_check_user_id' => '', 'keterangan' => $keterangan));
if ($cin) {
$docs = new Checkindocument();
$docs->checkin_id = $cin->id;
$docs->save();
//return Redirect::to('schedule');
}
//
}
}
}
return Redirect::to('schedule');
}
}
<?php
require_once 'DrSlump/Protobuf.php';
\DrSlump\Protobuf::autoload();
require_once __DIR__ . '/../inc/functions.php';
require_once __DIR__ . '/../classes/GoogleAccount.class.php';
require_once __DIR__ . '/../classes/Checkin.class.php';
$google_account = new GoogleAccount('USER_EMAIL', 'USER_PASSWORD');
$checkin = new Checkin($google_account);
$checkin->changeDevice('nexus-5');
echo 'AID: ' . $checkin->checkin() . "\n";
$fleet = Fleet::find($out->fleet_id);
?>
<?php
$driver = Driver::find($out->driver_id);
?>
<tr>
<td>{{ $no }}</td>
<td>@if($fleet) {{ $fleet->taxi_number }} @endif</td>
<td>@if($driver) {{ $driver->nip }} @endif</td>
<td>@if($driver) {{ $driver->name }} @endif</td>
<td>{{ $out->printspj_time }}</td>
<td>{{ $out->checkout_time }}</td>
<td>
<?php
$last_operasi = date('Y-m-d', strtotime($out->operasi_time . ' -1 days'));
$last_checkin = Checkin::where_fleet_id($out->fleet_id)->where_operasi_time($last_operasi)->first();
if ($last_checkin) {
echo $last_checkin->km_fleet;
}
?>
</td>
<td>{{ $out->checkin_time }}</td>
<td>{{ $out->km_fleet }}</td>
<td>{{ Shift::find($out->shift_id)->shift }}</td>
<td>{{ Statusoperasi::find($out->operasi_status_id)->kode }}</td>
<td>Lihat Data Cheklist</td>
</tr>
<?php
$no++;
?>
@endforeach
public function post_afterpaysave()
{
Log::write('info', Request::ip() . ' User : '******' Event: Save Edit Setoran', true);
$jsondata = Input::json();
//lihat KS
$tabungan_pengemudi = 0;
$ks_pengemudi = 0;
if ((int) $jsondata->ks > 0) {
$tabungan_pengemudi = (int) $jsondata->ks;
} else {
$ks_pengemudi = abs((int) $jsondata->ks);
}
$setoran = array();
$setoran['1'] = (int) $jsondata->setoran_wajib;
$setoran['2'] = (int) $jsondata->tab_sp;
$setoran['3'] = (int) $jsondata->denda;
$setoran['4'] = (int) $jsondata->pot;
$setoran['5'] = (int) $jsondata->tag_spart;
$setoran['6'] = (int) $jsondata->tag_ks;
$setoran['7'] = (int) $jsondata->biaya_tc;
$setoran['8'] = (int) $jsondata->iuran_laka;
$setoran['9'] = (int) $jsondata->tag_cicilan_dp;
$setoran['10'] = (int) $jsondata->tag_hut_lama;
$setoran['11'] = (int) $ks_pengemudi;
$setoran['12'] = (int) $jsondata->tag_other;
$setoran['13'] = (int) $jsondata->tag_dp_spart;
$setoran['20'] = (int) $jsondata->setoran_cash;
$setoran['21'] = (int) $tabungan_pengemudi;
//Edit Status Operasi
//End Status Operasi
try {
foreach ($setoran as $key => $value) {
/*
$payment = Checkinfinancial::create(array(
'checkin_id'=>$jsondata->checkin_id,
'financial_type_id'=> $key,
'amount'=> $value));
*/
$payment = Checkinfinancial::where_checkin_id($jsondata->checkin_id)->where_financial_type_id($key)->first();
if ($payment) {
$payment->amount = $value;
$payment->save();
} else {
$payment = Checkinfinancial::create(array('checkin_id' => $jsondata->checkin_id, 'financial_type_id' => $key, 'amount' => $value));
}
}
$checkin = Checkin::find($jsondata->checkin_id);
$checkin->checkin_step_id = 3;
$checkin->operasi_status_id = $jsondata->operasi_status_id;
$checkin->shift_id = $jsondata->shift_id;
$checkin->save();
/*
if($setoran['11'] > 0)
{
Blocked::create(array(
'driver_id'=> $checkin->driver_id,
'fleet_id' => $checkin->fleet_id ,
'blocked_status_id' => 1,
'checkin_id' => $checkin->id,
'date'=> date('Y-m-d H:i:s') ));
$block = Driver::find($checkin->driver_id);
$block->fg_blocked = 1;
$block->save();
}*/
//update status checkin
/*
$pothutanglama = Driverfinancial::where_driver_id($checkin->driver_id)->where_financial_type_id(18)->first();
if($pothutanglama){
$pothutanglama->amount = $pothutanglama->amount - $jsondata->tag_hut_lama;
}
$tabunganpengemudi = Driverfinancial::where_driver_id($checkin->driver_id)->where_financial_type_id(21)->first();
if($tabunganpengemudi){
$tabunganpengemudi->amount = $tabunganpengemudi->amount + $tabungan_pengemudi;
}else{
Driverfinancial::create(array(
'driver_id'=> $checkin->driver_id,
'financial_type_id' => 21,
'amount' => $tabungan_pengemudi,
));
}
$ks = Kewajiban::where_fleet_id($checkin->fleet_id)
->where_driver_id($checkin->driver_id)
->where_financial_type_id(6)->first();
if($ks){
$ks->total_amount = ($ks->total_amount + $setoran['11']) - $setoran['6'];
}else{
Kewajiban::create(array(
'fleet_id' => $checkin->fleet_id,
'driver_id' => $checkin->driver_id,
'financial_type_id' => 6,
'amount' => 0,
'total_amount' => $setoran['11'],
));
}
if((int)$jsondata->denda > 10000)
{
Blocked::create(array(
'driver_id'=>$checkin->driver_id,
'fleet_id' => $checkin->fleet_id ,
'blocked_status_id' => 6,
'checkin_id' => $checkin->id,
'date'=> date('Y-m-d H:i:s') ));
$block = Driver::find($checkin->driver_id);
$block->fg_blocked = 1;
$block->save();
}
*/
return json_encode(array('msg' => 'Setoran berhasil di ubah'));
} catch (Exception $e) {
return json_encode(array('msg' => 'Edit Setoran Gagal'));
}
}
public function post_deleteops()
{
Log::write('info', Request::ip() . ' User : '******' Event: Mengapus histori setoran', true);
$data = Input::json();
$checkin = Checkin::find($data->checkin_id);
Checkout::where('operasi_time', '=', $checkin->operasi_time)->where('fleet_id', '=', $checkin->fleet_id)->first()->delete();
$checkin->delete();
return json_encode(array('status' => 1));
}
public function execute(CommandContext $context)
{
// Check permissions
if (!Current_User::allow('hms', 'checkin')) {
PHPWS_Core::initModClass('hms', 'exception/PermissionException.php');
throw new PermissionException('You do not have permission to checkin students.');
}
$bannerId = $context->get('bannerId');
$hallId = $context->get('hallId');
// Check for key code
$keyCode = $context->get('key_code');
if (!isset($keyCode) || $keyCode == '') {
NQ::simple('hms', hms\NotificationView::ERROR, 'Please enter a key code.');
$errorCmd = CommandFactory::getCommand('ShowCheckinForm');
$errorCmd->setBannerId($bannerId);
$errorCmd->setHallId($hallId);
$errorCmd->redirect();
}
$term = Term::getSelectedTerm();
// Lookup the student
$student = StudentFactory::getStudentByBannerId($bannerId, $term);
// Get the student's current assignment
$assignment = HMS_Assignment::getAssignmentByBannerId($bannerId, $term);
$bed = $assignment->get_parent();
// Get the currently logged in user
$currUser = Current_User::getUsername();
// Check for an existing Check-in
$checkin = CheckinFactory::getCheckinByBed($student, $bed);
// If there's not already a checkin for this bed, create a new one
if (is_null($checkin)) {
$checkin = new Checkin($student, $bed, $term, $currUser, $keyCode);
} else {
if ($checkin->getBedId() == $bed->getId() && time() - $checkin->getCheckinDate() < Checkin::CHECKIN_TIMEOUT) {
// Check-in already exists, and it's within the timout window, so we'll overwrite the existing checkin
$updatedCheckin = new Checkin($student, $bed, $term, $currUser, $keyCode);
$updatedCheckin->substitueForExistingCheckin($checkin);
// Use the old checkin to replace this one
$checkin = $updatedCheckin;
} else {
// There's an existing checkin, but it's after the timeout, so we need to make a new checkin
$checkin = new Checkin($student, $bed, $term, $currUser, $keyCode);
}
}
$checkin->save();
// Add this to the activity log
HMS_Activity_Log::log_activity($student->getUsername(), ACTIVITY_CHECK_IN, UserStatus::getUsername(), $assignment->where_am_i());
// Generate the RIC
PHPWS_Core::initModClass('hms', 'InfoCard.php');
PHPWS_Core::initModClass('hms', 'InfoCardPdfView.php');
$infoCard = new InfoCard($checkin);
$infoCardView = new InfoCardPdfView();
$infoCardView->addInfoCard($infoCard);
// Send confirmation Email with the RIC form to the student
PHPWS_Core::initModClass('hms', 'HMS_Email.php');
HMS_Email::sendCheckinConfirmation($student, $infoCard, $infoCardView);
NQ::simple('hms', hms\NotificationView::SUCCESS, 'Checkin successful.');
// Redirect to success page with option to print check-in document.
$cmd = CommandFactory::getCommand('ShowCheckinDocument');
$cmd->setBannerId($student->getBannerId());
$cmd->setCheckinId($checkin->getId());
$cmd->redirect();
}
public function get_fleetsonbeforepay()
{
$date = Input::get('date', date('Y-m-d'));
$pool_id = Auth::user()->pool_id;
$fleets_on_before_pay = Checkin::join('fleets as f', 'f.id', '=', 'checkins.fleet_id')->where_operasi_time($date)->where('checkins.pool_id', '=', $pool_id)->where('checkins.checkin_step_id', '=', 11)->where('checkins.operasi_status_id', '=', 1)->order_by('f.taxi_number', 'asc')->get(array('f.taxi_number', 'checkins.id'));
$datas = array_map(function ($object) {
return $object->to_array();
}, $fleets_on_before_pay);
return Response::json($datas);
}
public function post_saveCheckFisik()
{
Log::write('info', Request::ip() . ' User : '******' Event: Save Checkin', true);
$data = Input::json();
$id = $data->id;
$docs_ket = $data->std_docs;
$neats = $data->std_neats;
$equips = $data->std_equips;
$sp_kets = $data->ket_sp;
$checkin = Checkin::find($id);
//$checkin->operasi_status_id = $data->status_ops;
$checkin->save();
$docs = array();
foreach (Stddoc::all() as $doc) {
array_push($docs, $doc->id);
}
$sps = array();
foreach (Stdfleet::all() as $sp) {
array_push($sps, $sp->id);
}
$fg_bengkel = $data->hasilcheckfisik == 2 ? 1 : 0;
$cin = Checkindocument::where_checkin_id($id)->first();
$cpy = Checkinphysic::where_checkin_id($id)->first();
if (!$cpy) {
$cpy = Checkinphysic::create(array('checkin_id' => $id));
}
if ($cin->operasi_time > date('Y-m-d', Myfungsi::sysdate())) {
$datax['message'] = 'invalide time';
} else {
$cin->std_neats_id = implode(",", $neats);
$cin->std_document_id = implode(",", $docs);
$cin->ket = implode(",", $docs_ket);
$cin->std_equip_id = implode(",", $equips);
$cin->save();
//save pysicly
$cpy->sparepart_id = implode(",", $sps);
$cpy->ket = implode(",", $sp_kets);
$cpy->save();
//update jika perlu berbaikan
$fl = Fleet::find($checkin->fleet_id);
$fl->fg_bengkel = $fg_bengkel;
$fl->save();
$datax['message'] = 'Data Saved';
}
return json_encode($datax);
}
public function getReason()
{
static $reasons = null;
if (empty($reasons)) {
$reasons = Checkin::getReasons();
}
if (isset($reasons[$this->reason])) {
return $reasons[$this->reason];
} else {
return dgettext('checkin', 'Reason unknown');
}
}
$smartyType = "www";
include_once "../includes/default.inc.php";
$auth->is_authenticated();
include_once 'bookingclass.inc.php';
include_once 'calendarclass.inc.php';
include_once 'roomclass.inc.php';
include_once 'bookingcategoryclass.inc.php';
include_once 'guestclass.inc.php';
include_once 'checkinclass.inc.php';
include_once 'checkoutclass.inc.php';
$cal = new Calendar();
$room = new Room();
$bcat = new BookingCategory();
$guest = new Guest();
$booking = new Booking();
$checkin = new Checkin();
$checkout = new Checkout();
$firstpage = false;
// select Countries
$smarty->assign("tpl_countries", $guest->GetCountries());
$smarty->assign('tpl_children0_field', $request->GetVar('children0', 'session'));
$smarty->assign('tpl_children1_field', $request->GetVar('children1', 'session'));
$smarty->assign('tpl_children2_field', $request->GetVar('children2', 'session'));
$smarty->assign('tpl_children3_field', $request->GetVar('children3', 'session'));
$navmonth = $request->GetVar('month', 'get');
$navyear = $request->GetVar('year', 'get');
$navstep = $request->GetVar('navstep', 'get');
$bookid = $request->GetVar('bookid', 'get');
$bookingdetailid = $request->GetVar('bookingdetailid', 'get');
if ($request->GetVar('checkin', 'get') !== $request->undefined) {
$smarty->assign('tpl_checkin', $request->GetVar('checkin', 'get'));
private function summaryReport()
{
javascript('datepicker');
$form = new PHPWS_Form('report-date');
$form->setMethod('get');
$form->addHidden('module', 'checkin');
$form->addHidden('aop', 'report');
$form->addHidden('summary_report', 1);
$form->addText('start_date', $_GET['start_date']);
$form->setLabel('start_date', 'Start date');
$form->setSize('start_date', 10);
$form->setExtra('start_date', 'class="datepicker"');
$form->addText('end_date', $_GET['end_date']);
$form->setLabel('end_date', 'End date');
$form->setSize('end_date', 10);
$form->setExtra('end_date', 'class="datepicker"');
if (!empty($_GET['visitor_name'])) {
$name = trim(strip_tags($_GET['visitor_name']));
} else {
$name = null;
}
$form->addText('visitor_name', $name);
$form->setLabel('visitor_name', 'Visitor name');
$form->addSubmit(dgettext('checkin', 'Summary report'));
$db = new PHPWS_DB('checkin_staff');
$db->addColumn('checkin_staff.id');
$db->addColumn('users.display_name');
$db->addWhere('checkin_staff.user_id', 'users.id');
$db->setIndexBy('id');
$db->addOrder('users.display_name desc');
$assigned = $db->select('col');
$assigned[0] = dgettext('checkin', 'Show all');
$assigned = array_reverse($assigned, true);
$form->addSelect('assigned', $assigned);
$form->setLabel('assigned', 'By staff');
if (isset($_GET['assigned'])) {
$staff_id = (int) $_GET['assigned'];
$form->setMatch('assigned', $staff_id);
} else {
$staff_id = 0;
}
$tpl = $form->getTemplate();
$start_date = strtotime($_GET['start_date']);
$end_date = strtotime($_GET['end_date']);
if (empty($start_date) || empty($end_date) || $start_date > $end_date) {
$tpl['EMPTY'] = 'Please enter your date range again.';
} else {
$this->title = 'Visitors from ' . $_GET['start_date'] . ' to ' . $_GET['end_date'];
$db = new PHPWS_DB('checkin_visitor');
$db->addWhere('arrival_time', $start_date, '>=');
$db->addWhere('arrival_time', $end_date, '<=');
$db->addColumn('id');
$db->addColumn('arrival_time');
$db->addColumn('firstname');
$db->addColumn('lastname');
$db->addColumn('start_meeting');
$db->addColumn('end_meeting');
if ($staff_id) {
$db->addWhere('assigned', $staff_id);
}
if (!empty($name)) {
$name = strtolower($name);
if (strlen($name) == 1) {
$db->addWhere('firstname', "{$name}%", 'like', 'and', 'name');
$db->addWhere('lastname', "{$name}%", 'like', 'or', 'name');
} else {
$db->addWhere('firstname', "%{$name}%", 'like', 'and', 'name');
$db->addWhere('lastname', "%{$name}%", 'like', 'or', 'name');
}
}
$result = $db->select();
$total_visits = 0;
$total_wait = 0;
$total_meeting = 0;
$total_days = 0;
$incomplete_visits = 0;
$current_day = null;
foreach ($result as $visit) {
extract($visit);
$arrival_day = date('MdY', $arrival_time);
if ($current_day != $arrival_day) {
$current_day = $arrival_day;
$total_days++;
}
$row = array();
if (!$start_meeting || !$end_meeting) {
$incomplete_visits++;
continue;
}
$total_visits++;
$twaited = $start_meeting - $arrival_time;
$waited = Checkin::timeWaiting($twaited);
if ($end_meeting) {
$tmeeting = $end_meeting - $start_meeting;
}
$meeting = Checkin::timeWaiting($tmeeting);
$row['VISIT'] = $total_visits;
$row['VISITOR'] = "{$firstname} {$lastname}";
$row['DATE'] = date('g:ia m.d.Y', $arrival_time);
$row['WAITED'] = $waited;
$row['MEETING'] = $meeting;
$tpl['rows'][] = $row;
$total_wait += $twaited;
$total_meeting += $tmeeting;
}
if ($total_visits) {
$tpl['TOTAL_DAYS'] = $total_days;
$tpl['TOTAL_VISITS'] = $total_visits;
$tpl['AVG_VISITS'] = round($total_visits / $total_days, 1);
$tpl['TOTAL_WAIT'] = Checkin::timeWaiting($total_wait);
$tpl['TOTAL_MEETING'] = Checkin::timeWaiting($total_meeting);
$tpl['AVG_WAIT'] = Checkin::timeWaiting(round($total_wait / $total_visits));
$tpl['AVG_MEETING'] = Checkin::timeWaiting(round($total_meeting / $total_visits));
$tpl['INCOMPLETE_MEETINGS'] = $incomplete_visits;
} else {
$tpl['EMPTY'] = 'No visits made in this date range.';
}
}
$this->content = PHPWS_Template::process($tpl, 'checkin', 'summary_report.tpl');
}
* The GNU General Public License can be found at
* http://www.gnu.org/copyleft/gpl.html.
* A copy is found in the textfile GPL.txt and important notices to the license
* from the author is found in LICENSE.txt distributed with these scripts.
*
*
* This script is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* This copyright notice MUST APPEAR in all copies of the script!
***************************************************************/
/**
* List of checked in guests
*
* calendar
*
* @since 2004-09-02
* @author Christian Ehret <*****@*****.**>
*/
$smartyType = "www";
include_once "../includes/default.inc.php";
$auth->is_authenticated();
include_once 'checkinclass.inc.php';
$smarty->assign("tpl_title", "Checkin");
$smarty->assign('tpl_nav', 'calendar');
$smarty->assign('tpl_subnav', 'checkin');
$checkin = new Checkin();
$smarty->assign('tpl_guests', $checkin->get());
$smarty->display('checkinlist.tpl');
/**
* Causes this check-in to take the ID of the passed-in checkin.
* When saved,
* this will effectively overwrite the passed in checkin.
*
* @param Checkin $checkin
*/
public function substitueForExistingCheckin(Checkin $checkin)
{
$this->setId($checkin->getId());
}
Route::get('/', 'SessionsController@create');
Route::post('store', 'SessionsController@store');
Route::get('logout', 'SessionsController@destroy');
Route::get('assistance', function () {
return View::make('assistance.index');
})->before('auth');
Route::get('crear', function () {
$user = new User();
$user->user = "******";
$user->password = Hash::make('Fernando2014');
$user->save();
return "Usuario Creado";
});
Route::get('test', function () {
$checkin = new Checkin();
$checkin->user_id = 1;
$checkin->fecha = date('1994-04-26');
$checkin->save();
});
Route::get('test2', function () {
$user = User::find(1);
$checkins = $user->checkins;
$checkouts = $user->checkouts;
$lista = '<div style="display:inline-block"><h2>Checkins</h2><ul>';
foreach ($checkins as $item) {
$lista .= '<li>';
$lista .= '<h2 style="display:inline-block;">' . $item['fecha'] . '</h2>' . "-----";
$lista .= '</li>';
}
$lista .= '</ul></div>';
public function post_qzotorisasicetak()
{
$data = Input::json();
$username = $data->username;
$password = $data->password;
$ver2 = User::where('username', '=', $username)->first();
if ($ver2) {
if (Hash::check($password, $ver2->password)) {
Log::write('info', Request::ip() . ' User : '******' Event: Print SPJ otoritas', true);
$scheduledate = Scheduledate::find($data->id);
$schedule = Schedule::find($scheduledate->schedule_id);
$scheduledate->fg_check = 1;
$scheduledate->save();
$driverinfo = Driver::find($scheduledate->driver_id);
$fleetinfo = Fleet::find($schedule->fleet_id);
$ksoinfo = Kso::where_fleet_id($schedule->fleet_id)->where_actived(1)->first();
$this->data['driverinfo'] = $driverinfo;
$this->data['fleetinfo'] = $fleetinfo;
$this->data['pool'] = Pool::find($schedule->pool_id);
$codeops = $data->statusops;
$keterangan = $data->keterangan;
if ((int) $codeops == 1) {
if ($driverinfo->fg_blocked == 1) {
$status = 5;
$codeops = 7;
} else {
if ($driverinfo->fg_super_blocked == 1) {
$status = 5;
$codeops = 7;
} else {
if ($fleetinfo->fg_blocked == 1) {
$status = 5;
$codeops = 7;
} else {
if ($fleetinfo->fg_bengkel == 1) {
$status = 6;
$codeops = 4;
} else {
if ($fleetinfo->fg_super_blocked == 1) {
$status = 5;
$codeops = 7;
} else {
$status = 3;
$codeops = $codeops;
}
}
}
}
}
} else {
$status = 3;
}
$dateopertion = mktime(0, 0, 0, $schedule->month, $scheduledate->date, $schedule->year);
$checkouts = Checkout::where_fleet_id($schedule->fleet_id)->where_operasi_time(date('Y-m-d', $dateopertion))->first();
if (!$checkouts) {
//insert into to checkouts step
$checkouts = new Checkout();
$checkouts->kso_id = $ksoinfo->id;
$checkouts->operasi_time = date('Y-m-d', $dateopertion);
$checkouts->fleet_id = $fleetinfo->id;
$checkouts->driver_id = $driverinfo->id;
$checkouts->checkout_step_id = $status;
$checkouts->shift_id = $scheduledate->shift_id;
$checkouts->user_id = Auth::user()->id;
$checkouts->pool_id = Auth::user()->pool_id;
$checkouts->printspj_time = date('Y-m-d H:i:s', Myfungsi::sysdate());
$checkouts->operasi_status_id = $codeops;
$checkouts->keterangan = $keterangan;
$checkouts->print_out_time = 1;
$checkouts->otorisasi_user_id = $ver2->id;
$checkouts->save();
if ((int) $codeops == 1) {
$scheduledate->fg_check = 1;
$scheduledate->save();
}
if ((int) $codeops !== 1) {
$cin = Checkin::create(array('kso_id' => $ksoinfo->id, 'fleet_id' => $fleetinfo->id, 'driver_id' => $driverinfo->id, 'checkin_time' => date('Y-m-d H:i:s', Myfungsi::sysdate()), 'shift_id' => $scheduledate->shift_id, 'km_fleet' => 0, 'rit' => 0, 'incomekm' => 0, 'operasi_time' => date('Y-m-d', $dateopertion), 'pool_id' => Auth::user()->pool_id, 'operasi_status_id' => $codeops, 'fg_late' => '', 'checkin_step_id' => 12, 'document_check_user_id' => Auth::user()->id, 'physic_check_user_id' => '', 'bengkel_check_user_id' => '', 'finance_check_user_id' => '', 'keterangan' => $keterangan));
if ($cin) {
$docs = new Checkindocument();
$docs->checkin_id = $cin->id;
$docs->save();
}
//make can't print before setoran
$setor = Fleet::find($fleetinfo->id);
$setor->fg_setor = 1;
$setor->save();
}
} else {
if ((int) $codeops !== 1) {
$checkinstatus = Checkin::where_fleet_id($schedule->fleet_id)->where_operasi_time(date('Y-m-d', $dateopertion))->first();
if (!$checkinstatus) {
$cin = Checkin::create(array('kso_id' => $ksoinfo->id, 'fleet_id' => $fleetinfo->id, 'driver_id' => $driverinfo->id, 'checkin_time' => date('Y-m-d H:i:s', Myfungsi::sysdate()), 'shift_id' => $scheduledate->shift_id, 'km_fleet' => 0, 'rit' => 0, 'incomekm' => 0, 'operasi_time' => date('Y-m-d', $dateopertion), 'pool_id' => Auth::user()->pool_id, 'operasi_status_id' => $codeops, 'fg_late' => '', 'checkin_step_id' => 12, 'document_check_user_id' => Auth::user()->id, 'physic_check_user_id' => '', 'bengkel_check_user_id' => '', 'finance_check_user_id' => '', 'keterangan' => $keterangan));
if ($cin) {
$docs = new Checkindocument();
$docs->checkin_id = $cin->id;
$docs->save();
}
}
}
//reprint after open blocking
if ((int) $codeops == 1) {
$checkinremove = Checkin::where_fleet_id($schedule->fleet_id)->where_operasi_time(date('Y-m-d', $dateopertion))->where_in('operasi_status_id', array(2, 3, 4, 5, 6, 7))->first();
if ($checkinremove) {
$checkinremove->delete();
//make can print before setoran becouse update set on checkout step
$setor = Fleet::find($schedule->fleet_id);
$setor->fg_setor = 0;
$setor->save();
}
}
if ((int) $codeops == 1) {
$scheduledate->fg_check = 1;
$scheduledate->save();
}
$checkouts->kso_id = $ksoinfo->id;
$checkouts->operasi_time = date('Y-m-d', $dateopertion);
$checkouts->fleet_id = $fleetinfo->id;
$checkouts->driver_id = $driverinfo->id;
$checkouts->checkout_step_id = $status;
$checkouts->shift_id = $scheduledate->shift_id;
$checkouts->user_id = Auth::user()->id;
$checkouts->pool_id = Auth::user()->pool_id;
$checkouts->operasi_status_id = $codeops;
$checkouts->printspj_time = date('Y-m-d H:i:s', Myfungsi::sysdate());
$checkouts->keterangan = $keterangan;
$checkouts->print_out_time = 1;
$checkouts->otorisasi_user_id = $ver2->id;
$checkouts->save();
}
$content = "";
if ($checkouts->operasi_status_id == 1) {
$kopsurat = 'SURAT PERINTAH JALAN';
$content .= "Nama dan kendaraan yang tercantum diatas";
$content .= "DI IZINKAN untuk mengoprasikan kendaraan";
$content .= "PT.DIAN TAKSI sesuai dengan tanggal yang";
$content .= "tercantum diatas\r\n";
$content .= "--------------------------------------- \r\n";
$content .= "a";
// 1 SET CENTER PAGE
$content .= "Tanda Tangan \r\n";
$content .= "a";
// 1 SET LEFT PAGE
$content .= "--------------------------------------- \r\n";
$content .= " Bag. Operasi Security \r\n";
$content .= "\r\n \r\n \r\n";
} else {
$kopsurat = 'SURAT PENGANTAR PROSES BAP';
$content .= "Nama dan kendaraan yang tercantum diatas";
$content .= "TIDAK DI IZINKAN mengoprasikan kendaraan";
$content .= "PT.DIAN TAKSI sesuai dengan tanggal yang";
$content .= "tercantum diatas\r\n";
}
$headerPrint = "";
for ($j = 1; $j < 2; $j++) {
$headerPrint .= "@";
$headerPrint .= "a";
// 1 SET CENTER PAGE
$headerPrint .= "!";
$headerPrint .= $kopsurat . " \r\n";
$headerPrint .= "!";
$headerPrint .= "@";
// 1 RESET
$headerPrint .= "a";
// 1 SET CENTER PAGE
$headerPrint .= "PT. DHARMA INDAH AGUNG METROPOLITAN \r\n";
$headerPrint .= "POOL " . Pool::find($checkouts->pool_id)->pool_name . " \r\n";
$headerPrint .= "======================================= \r\n";
$headerPrint .= "a";
// 1 SET LEFT PAGE
//content printer
$headerPrint .= "Nama : " . substr($driverinfo->name, 0, 25) . " \r\n";
$headerPrint .= "Nip : " . $driverinfo->nip . " \r\n";
$headerPrint .= "Body : " . $fleetinfo->taxi_number . " \r\n";
$headerPrint .= "Tgl Operasi : " . date('d/m/Y', strtotime($checkouts->operasi_time)) . " \r\n";
$headerPrint .= "--------------------------------------- \r\n";
$headerPrint .= $content;
$headerPrint .= "======================================= \r\n";
$headerPrint .= "Tanggal Cetak " . date('d/m/Y H:i:s', MyFungsi::sysdate(date('Y-m-d H:i:s'))) . " \r\n";
$headerPrint .= "Lembar ke - " . $j . " \r\n";
$headerPrint .= "\f";
// 5 FF
$headerPrint .= " VA";
// 4 motong kertas
$headerPrint .= "@";
// 5 END
}
//create temp file
$file = 'dataprintspj' . $checkouts->pool_id . '.txt';
$myFile = path('public') . '/qzprint/templatedata/' . $file;
$fh = fopen($myFile, 'w') or die("can't open file");
$resetPrint = "";
fwrite($fh, $resetPrint);
$dataPrint = $headerPrint;
fwrite($fh, $dataPrint);
fclose($fh);
return json_encode(array('status' => 1, 'urlfile' => $file));
}
}
}
