示例#1
0
    /**
     * 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;
    }
示例#2
0
    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;
    }
示例#3
0
    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);
    }
示例#4
0
 /**
  * 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();
 }
示例#5
0
                                    <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');
        }
    }
}
示例#6
0
文件: DB.php 项目: clancats/core
 /**
  * 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);
 }
示例#7
0
    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;
    }
示例#8
0
    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);
    }
示例#9
0
                                <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>