/** * Counts the project's issues assigned to the given user * * @param int $user_id * @return int */ public function count_assigned_issues($user_id = null) { if (is_null($user_id)) { $user_id = \Auth::user()->id; } $sql = ' SELECT COUNT(id) AS `total` FROM projects_issues WHERE project_id = ? AND assigned_to = ? AND status = 1 '; $result = \DB::first($sql, array($this->id, $user_id)); return !$result ? 0 : $result->total; }
public function infoSaldo($kso_id, $date) { $saldo = DB::first('select cin.id, cin.kso_id, cin.fleet_id, cin.operasi_time, a.pool_id, a.bravo_driver_id, a.charlie_driver_id, f.taxi_number, /* KS */ sum(if( cf.financial_type_id = 11, cf.amount, 0)) as ks, sum(if( cf.financial_type_id = 6, cf.amount, 0)) as cicilan_ks, /* SP */ sum(if( cf.financial_type_id = 2, cf.amount, 0)) as tabungan_sparepart, sum(if( cf.financial_type_id = 5, cf.amount, 0)) as cicilan_sparepart, sum(if( cf.financial_type_id = 13, cf.amount, 0)) as hutang_dp_sparepart, sp.pemakaian_part, /* DP */ sum(if( cf.financial_type_id = 9, cf.amount, 0)) as cicilan_dp_kso, /* saldo saldo */ (sum(if( cf.financial_type_id = 11, cf.amount, 0)) - sum(if( cf.financial_type_id = 6, cf.amount, 0)) ) as saldoks, ((sum(if( cf.financial_type_id = 2, cf.amount, 0)) + sum(if( cf.financial_type_id = 5, cf.amount, 0)) + sum(if( cf.financial_type_id = 13, cf.amount, 0)))) - sp.pemakaian_part as saldosp from checkins cin left join ( select cfx.financial_type_id, cfx.amount, cfx.checkin_id from checkin_financials cfx ) as cf on ( cin.id = cf.checkin_id ) join ( select kso.id, kso.pool_id, kso.bravo_driver_id, kso.charlie_driver_id from ksos kso where kso.actived = 1 ) as a ON a.id = cin.kso_id left join ( select wo.id,wo.kso_id,wo.inserted_date_set, sum((part.qty * part.price)) as pemakaian_part from work_orders wo left join wo_part_items part on ( wo.id = part.wo_id ) where wo.status = 3 and part.telah_dikeluarkan = 1 and wo.beban = 0 and wo.inserted_date_set <= ? group by wo.kso_id ) as sp ON ( sp.kso_id = cin.kso_id) join ( select fleets.taxi_number, fleets.id from fleets ) as f ON (f.id = cin.fleet_id) where cin.operasi_time <= ? and cin.kso_id = ? group by cin.kso_id', array($date, $date, $kso_id)); return $saldo; }
public static function count_issues() { /* Count Open Issues */ $sql = ' SELECT COUNT(i.id) AS total FROM projects_issues i JOIN projects p ON p.id = i.project_id WHERE p.status = 1 AND i.status = 1 GROUP BY i.id '; $count = \DB::first($sql); $open_issues = !$count ? 0 : $count->total; /* Count Closed Issues - If the project is closed, so is the issue */ $sql = ' SELECT COUNT(i.id) AS total FROM projects_issues i JOIN projects p ON p.id = i.project_id WHERE p.status = 1 AND i.status = 0 GROUP BY i.id '; $count = (int) \DB::first($sql); $closed_issues_open_project = !$count ? 0 : $count->total; $sql = ' SELECT COUNT(i.id) AS total FROM projects_issues i JOIN projects p ON p.id = i.project_id WHERE p.status = 0 GROUP BY i.id '; $count = (int) \DB::first($sql); $issues_closed_project = !$count ? 0 : $count->total; $closed_issues = $closed_issues_open_project + $issues_closed_project; return array('open' => $open_issues, 'closed' => $closed_issues); }
/** * Mengambil record data tertentu, berdasarkan column id. * * @param integer $id * @return StdClass Object */ public function find($id) { $this->db->get($this->table, ['id', '=', $id]); return $this->db->first(); }
<input type="text" class="form-control" id="code" name="code" value="<?php echo Input::get('code'); ?> " aria-describedby="sizing-addon2" required> </div> <br> <input class="btn btn-block btn-primary" type="submit" value="Провери"> </form> <?php if (Input::exists()) { $db = new DB(); $db->get('orders', array('code', '=', Input::get('code'))); if ($db->count()) { echo '<br><div class="input-group"> <span class="input-group-addon" id="sizing-addon2">Текуща локация:</span> <input type="text" class="form-control" value="' . $db->first()->current . '" aria-describedby="sizing-addon2" readonly> </div><br>'; echo '<textarea class="form-control" rows="6" readonly>Маршрут: ' . $db->first()->route . '</textarea>'; } else { $db->get('orders_finished', array('code', '=', Input::get('code'))); if ($db->count()) { echo '<br><div class="input-group"> <span class="input-group-addon" id="sizing-addon2">Текуща локация:</span> <input type="text" class="form-control" value="Поръчката вече е притигнала." aria-describedby="sizing-addon2" readonly> </div>'; } else { Session::flash('home', 'danger # Няма поръчка с такъв код.'); Redirect::to('location.php'); } } }
/** * DB::first tests * * @dataProvider people_provider_bulk */ public function test_first($people) { DB::run('delete from people'); $this->assertFalse(DB::first('people')); DB::insert('people', $people)->run(); $this->assertTrue(DB::first('people') !== null); }
public function infoSaldopengemudi($driver_id, $date) { $saldo = DB::first('select cin.id, cin.kso_id, cin.fleet_id, cin.driver_id, cin.operasi_time, f.taxi_number, /* KS */ sum(if( cf.financial_type_id = 11, cf.amount, 0)) as ks, sum(if( cf.financial_type_id = 6, cf.amount, 0)) as cicilan_ks, /* SP */ sum(if( cf.financial_type_id = 2, cf.amount, 0)) as tabungan_sparepart, sum(if( cf.financial_type_id = 5, cf.amount, 0)) as cicilan_sparepart, sum(if( cf.financial_type_id = 13, cf.amount, 0)) as hutang_dp_sparepart, /* sp.pemakaian_part, */ /* DP */ sum(if( cf.financial_type_id = 9, cf.amount, 0)) as cicilan_dp_kso, /* saldo saldo */ (sum(if( cf.financial_type_id = 11, cf.amount, 0)) - sum(if( cf.financial_type_id = 6, cf.amount, 0)) ) as saldoks, ((sum(if( cf.financial_type_id = 2, cf.amount, 0)) + sum(if( cf.financial_type_id = 5, cf.amount, 0)) + sum(if( cf.financial_type_id = 13, cf.amount, 0)))) - sp.pemakaian_part as saldosp from checkins cin left join ( select cfx.financial_type_id, cfx.amount, cfx.checkin_id from checkin_financials cfx ) as cf on ( cin.id = cf.checkin_id ) join ( select fleets.taxi_number, fleets.id from fleets ) as f ON (f.id = cin.fleet_id) */ where cin.operasi_time <= ? and cin.driver_id = ? group by cin.driver_id', array($date, $driver_id)); return $saldo; }
public static function count_issues() { /* Count Open Issues - Project must be open */ $sql = 'SELECT COUNT(i.id) AS `total` FROM projects_issues i JOIN projects p ON p.id = i.project_id WHERE p.status = 1 AND i.status = 1 GROUP BY i.id '; $count = \DB::first($sql); $open_issues = !$count ? 0 : $count->total; /* Count Closed Issues - Open Projects */ $sql = 'SELECT COUNT(i.id) AS `total` FROM projects_issues i JOIN projects p ON p.id = i.project_id WHERE p.status = 1 AND i.status = 0 GROUP BY i.id '; $count = \DB::first($sql); $closed_issues_open_project = !$count ? 0 : $count->total; /* Count Issues - Closed Projects */ $sql = 'SELECT COUNT(i.id) AS `total` FROM projects_issues i JOIN projects p ON p.id = i.project_id WHERE p.status = 0 GROUP BY i.id '; $count = \DB::first($sql); $issues_closed_project = !$count ? 0 : $count->total; $closed_issues = $closed_issues_open_project + $issues_closed_project; return array('open' => $open_issues, 'closed' => $closed_issues); }
<div class="input-group"> <span class="input-group-addon" id="sizing-addon2">Код:</span> <input type="text" class="form-control" id="code" name="code" value="<?php echo Input::get('code'); ?> " aria-describedby="sizing-addon2" required> </div> <br> <input class="btn btn-block btn-primary" type="submit" value="Генерирай"> </form> <?php if (Input::exists()) { $db = new DB(); $db->get('orders', array('code', '=', Input::get('code'))); if ($db->count()) { $result = $db->first(); $fields = array('from' => $result->from_town, 'to_town' => $result->to_town, 'route' => $result->route, 'distance' => $result->distance, 'weight' => $result->weight, 'sum' => $result->sum, 'price' => $result->price, 'code' => $result->code, 'current' => $result->current, 'clerk' => $result->clerk, 'sender_name' => $result->sender_name, 'sender_phone' => $result->sender_phone, 'receiver_name' => $result->receiver_name, 'receiver_phone' => $result->receiver_phone, 'pay' => $result->pay, 'info' => $result->info, 'from_date' => $result->from_date, 'to_date' => $result->to_date); $pdf = new PDF(); $pdf->generate($fields); } else { Session::flash('home', 'danger # Няма поръчка с такъв код.'); Redirect::to('print.php'); } } ?> </div> </div> <div class="panel panel-primary"> <div class="panel-heading">Опции</div> <div class="panel-body"> <a class="btn btn-block btn-primary" href="send.php">Изпрати поръчка</a>