Exemplo n.º 1
0
 /**
  * Get Faq By Id
  * @param  string $id
  * @return Hexcores\Api\Facades\Response
  */
 public function getFaq($id)
 {
     $faq = $this->model->find($id);
     if (!$faq) {
         return response_missing();
     }
     return response_ok($this->transform($faq, new FaqTransformer()));
 }
 /**
  * get Single data of UpperHouse geo location by mongo id
  * @param  string $id
  * @return Hexcores\Api\Facades\Response
  */
 public function getById($id)
 {
     $geo = $this->model->find($id);
     if (!$geo) {
         return response_missing();
     }
     return response_ok($this->transform($geo, new GeoTransformer()));
 }
 /**
  * Attempt to use this token to login.
  * 
  * @param  string $token
  * @throws InvalidTokenStringException If token is not found or expired
  * 
  * @return Definitely246\LoginToken\Models\LoginToken
  */
 public function attempt($tokenString)
 {
     if (!$tokenString) {
         throw new EmptyTokenException("Cannot look up a token from empty token string.");
     }
     $token = $this->token->find($tokenString);
     if (!$token) {
         throw new InvalidTokenException("This token string could not be found!");
     }
     if ($token->isExpired()) {
         throw new ExpiredTokenException("This token string has expired!", $token);
     }
     return $token;
 }
Exemplo n.º 4
0
 /**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function index($id, Request $request)
 {
     $date = $request->get('date', date('Y-m-d'));
     $ksos = $this->ksos->join('fleets', 'ksos.fleet_id', '=', 'fleets.id')->where('ksos.pool_id', Auth::user()->pool_id)->where('ksos.actived', 1)->orderBy('fleets.taxi_number')->get(['ksos.*', 'fleets.taxi_number']);
     $total = DB::table('checkins')->select(DB::raw('sum(if((checkin_financials.financial_type_id = 1),checkin_financials.amount,0)) AS setoran_wajib,sum(if((checkin_financials.financial_type_id = 2),checkin_financials.amount,0)) AS tabungan_sparepart,sum(if((checkin_financials.financial_type_id = 3),checkin_financials.amount,0)) AS denda,sum(if((checkin_financials.financial_type_id = 4),checkin_financials.amount,0)) AS potongan,sum(if((checkin_financials.financial_type_id = 5),checkin_financials.amount,0)) AS cicilan_sparepart,sum(if((checkin_financials.financial_type_id = 6),checkin_financials.amount,0)) AS cicilan_ks,sum(if((checkin_financials.financial_type_id = 7),checkin_financials.amount,0)) AS biaya_cuci,sum(if((checkin_financials.financial_type_id = 8),checkin_financials.amount,0)) AS iuran_laka,sum(if((checkin_financials.financial_type_id = 9),checkin_financials.amount,0)) AS cicilan_dp_kso,sum(if((checkin_financials.financial_type_id = 10),checkin_financials.amount,0)) AS cicilan_hutang_lama,sum(if((checkin_financials.financial_type_id = 11),checkin_financials.amount,0)) AS ks,sum(if((checkin_financials.financial_type_id = 12),checkin_financials.amount,0)) AS cicilan_lain,sum(if((checkin_financials.financial_type_id = 13),checkin_financials.amount,0)) AS hutang_dp_sparepart,sum(if((checkin_financials.financial_type_id = 20),checkin_financials.amount,0)) AS setoran_cash,sum(if((checkin_financials.financial_type_id = 21),checkin_financials.amount,0)) AS tabungan,(sum(if((checkin_financials.financial_type_id = 11),checkin_financials.amount,0)) - sum(if((checkin_financials.financial_type_id = 6),checkin_financials.amount,0))) AS selisi_ks '))->addSelect(DB::raw('checkins.id, checkins.operasi_time , checkins.pool_id, checkins.shift_id'))->leftJoin('checkin_financials', 'checkins.id', '=', 'checkin_financials.checkin_id')->where('checkins.kso_id', $id)->where('checkins.operasi_time', '<=', $date)->groupBy('checkins.kso_id')->first();
     $sparepart = DB::table('work_orders')->select(DB::raw('work_orders.id AS id,work_orders.kso_id AS kso_id,work_orders.wo_number AS wo_number,work_orders.fleet_id AS fleet_id,work_orders.driver_id AS driver_id,work_orders.pool_id AS pool_id,work_orders.km AS km,work_orders.complaint AS complaint,work_orders.information_complaint AS information_complaint,work_orders.status AS status,work_orders.beban AS beban,work_orders.mechanic_id AS mechanic_id,work_orders.mechanic AS mechanic,work_orders.dp_sparepart AS dp_sparepart,work_orders.user_id AS user_id,work_orders.inserted_date_set AS inserted_date_set,work_orders.finished_date_set AS finished_date_set,work_orders.fg_part_approved AS fg_part_approved,work_orders.user_approved AS user_approved,sum((wo_part_items.qty * wo_part_items.price)) AS pemakaian_part'))->leftJoin('wo_part_items', 'work_orders.id', '=', 'wo_part_items.wo_id')->where('work_orders.status', 3)->where('wo_part_items.telah_dikeluarkan', 1)->where('work_orders.beban', 0)->where('work_orders.kso_id', $id)->where('work_orders.finished_date_set', '<=', $date)->groupBy('work_orders.kso_id')->first();
     $total_pemakaian_part = 0;
     if ($sparepart) {
         $total_pemakaian_part = $sparepart->pemakaian_part;
     }
     $kso = $this->ksos->find($id);
     $fleet = $kso->fleet;
     return view('armada.dashboard', compact('ksos', 'kso', 'fleet', 'total', 'total_pemakaian_part', 'date'));
 }
Exemplo n.º 5
0
 /**
  * Safely remove the image entity and all its presets
  * The physical image files are only removed after making sure that the same file is not used in other records
  * @param  \Cake\ORM\Entity $imageEntity [description]
  * @return bool
  */
 public function deleteImageEntity($imageEntity)
 {
     $shared = $this->_imagesTable->find()->where(['id !=' => $imageEntity->id, 'field_index !=' => $imageEntity->field_index, 'model' => $imageEntity->model, 'filename' => $imageEntity->filename]);
     if (!$shared->count()) {
         $basePath = $this->basePath();
         (new File($basePath . DS . $imageEntity->filename))->delete();
         foreach ($this->config('presets') as $preset => $options) {
             (new File($basePath . DS . $preset . '_' . $imageEntity->filename))->delete();
         }
     }
     return $this->_imagesTable->delete($imageEntity);
 }
Exemplo n.º 6
0
/**
 * Das eigentliche Parsen der Tabelle
 * @param  [type] $table [description]
 * @param  [type] $dates [description]
 * @return [type]        [description]
 */
function tableToArr($table, $dates)
{
    foreach ($table->find('tr') as $rowNo => $row) {
        if ($rowNo == 0) {
            continue;
        }
        foreach ($row->find('td') as $clmNo => $clm) {
            if ($clmNo == 0) {
                $categoryPrice = trim(preg_replace('/^\\D*/', '', $clm->plaintext));
                $category = trim(str_replace(array($categoryPrice, "-\r\n ", "\t", "\r", "\n", "           ", "    "), '', $clm->plaintext));
            } else {
                foreach ($clm->find('div.speise_eintrag') as $article) {
                    if (empty($article)) {
                        continue;
                    }
                    $title = $article->plaintext;
                    $allergies = $price = array();
                    preg_match('/\\(([0-9A-Za-z,]+)\\)/', $title, $allergies);
                    // Matcht eingeklammerten Text
                    // Parse Allergiestoffe
                    if (array_key_exists(1, $allergies)) {
                        $title = str_replace($allergies[0], '', $title);
                    }
                    // entferne Allergiestoffe aus Titel
                    $allergies = array_key_exists(1, $allergies) ? explode(",", trim($allergies[0], "()")) : NULL;
                    preg_match('/(\\d{1,2},\\d{2})/', $title, $price);
                    // Matcht Dezimalzahlen
                    // Parse den Preis
                    if (array_key_exists(1, $price)) {
                        $title = str_replace($price[1], '', $title);
                    }
                    // entferne Preis aus Titel
                    $price = empty($price[1]) ? $categoryPrice : $price[1];
                    $title = trim(str_replace("  ", " ", $title));
                    $price = tofloat($price);
                    if (!array_key_exists($clmNo - 1, $dates) || empty($category) || empty($title)) {
                        continue;
                    }
                    $arr[$dates[$clmNo - 1]][$category][] = array('name' => $title, 'price' => $price, 'allergies' => $allergies);
                    unset($title, $price, $allergies);
                }
            }
        }
    }
    return $arr;
}
 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function destroy($id)
 {
     return response()->json($this->repository->find($id)->delete());
 }
Exemplo n.º 8
0
 /**
  * [findInDom description]
  * @param  [type] $selector [description]
  * @return [type]           [description]
  */
 public function findInDom($selector)
 {
     return $this->dom->find($selector);
 }
 /**
  * @Route("/repo/project/{id}/{slug}", name="front.project.show")
  * @Template()
  */
 public function showAction($id)
 {
     $entity = $this->projectRepo->find($id);
     return ['entity' => $entity];
 }