/** * Datasource for the joincompetition Data Grid. * * @return \Cartalyst\DataGrid\DataGrid */ public function grid() { $data = $this->joincompetitions->grid(); $columns = ['id', 'team_name', 'team_type', 'competition_type', 'message_box', 'created_at']; $settings = ['sort' => 'created_at', 'direction' => 'desc']; $transformer = function ($element) { $element->edit_uri = route('admin.ocs.standardforms.joincompetitions.edit', $element->id); return $element; }; return datagrid($data, $columns, $settings, $transformer); }
/** * Processes displaying the data to the grid * * @return DataGrid * @throws \Stevebauman\LogReader\Exceptions\UnableToRetrieveLogFilesException */ public function grid() { $columns = ['id', 'level', 'date', 'header']; $settings = ['sort' => 'date', 'direction' => 'desc', 'pdf_view' => 'pdf']; $transformer = function ($element) { $element['level'] = $this->levelToLabel($element['level']); $element['show_url'] = route('admin.logs.show', array($element['id'])); $element['header'] = str_limit($element['header']); return $element; }; $reader = $this->reader; $filters = request()->input('filters'); if (is_array($filters)) { /* * If an include_read filter is toggled, make sure * we toggle it on the log reader */ foreach ($filters as $filter) { if (array_key_exists('include_read', $filter)) { $reader->includeRead(); } } } return datagrid($reader->get(), $columns, $settings, $transformer); }
/** * Datasource for the bookreferees Data Grid. * * @return \Cartalyst\DataGrid\DataGrid */ public function grid() { $data = $this->bookreferees->grid(); $columns = ['id', 'team_name', 'team_type', 'opponent_first_name', 'opponent_last_name', 'opponent_work_phone', 'opponent_mobile', 'opponent_email_address', 'opponent_team_name', 'match_gender', 'referees', 'assistant_refrees', 'fixture', 'fixture_type', 'competition_name', 'match_duration', 'match_start', 'match_end', 'fixture_date', 'pitch_surface', 'venue', 'message', 'created_at']; $settings = ['sort' => 'created_at', 'direction' => 'desc']; $transformer = function ($element) { $element->edit_uri = route('admin.ocs.standardforms.bookreferees.edit', $element->id); return $element; }; return datagrid($data, $columns, $settings, $transformer); }
/** * Datasource for the delivery Data Grid. * * @return \Cartalyst\DataGrid\DataGrid */ public function grid() { $data = $this->deliveries->grid(); $columns = ['id', 'delivery_status_id', 'delivery_type_id', 'delivery_money_id', 'created_at']; $settings = ['sort' => 'created_at', 'direction' => 'desc']; $transformer = function ($element) { $element->edit_uri = route('admin.sanatorium.shoporders.deliveries.edit', $element->id); return $element; }; return datagrid($data, $columns, $settings, $transformer); }
/** * Datasource for the product Data Grid. * * @return \Cartalyst\DataGrid\DataGrid */ public function grid() { $data = $this->products->grid(); $columns = ['id', 'slug', 'code', 'ean', 'weight', 'stock', 'created_at']; $settings = ['sort' => 'created_at', 'direction' => 'desc']; $transformer = function ($element) { $element->edit_uri = route('admin.sanatorium.shop.products.edit', $element->id); return $element; }; return datagrid($data, $columns, $settings, $transformer); }
/** * Datasource for the statement Data Grid. * * @return \Cartalyst\DataGrid\DataGrid */ public function grid() { $data = $this->statements->grid(); $columns = ['id', 'Date', 'Description', 'Money_in', 'Money_out ', 'Balance', 'created_at']; $settings = ['sort' => 'created_at', 'direction' => 'desc']; $transformer = function ($element) { $element->edit_uri = route('admin.ocs.finance.statements.edit', $element->id); return $element; }; return datagrid($data, $columns, $settings, $transformer); }
/** * Datasource for the contactusform Data Grid. * * @return \Cartalyst\DataGrid\DataGrid */ public function grid() { $data = $this->contactusforms->grid(); $columns = ['id', 'first_name', 'last_name', 'gender', 'work_phone', 'mobile', 'created_at']; $settings = ['sort' => 'created_at', 'direction' => 'desc']; $transformer = function ($element) { $element->edit_uri = route('admin.ocs.standardforms.contactusforms.edit', $element->id); return $element; }; return datagrid($data, $columns, $settings, $transformer); }
/** * Datasource for the money Data Grid. * * @return \Cartalyst\DataGrid\DataGrid */ public function grid() { $data = $this->money->grid(); $columns = ['id', 'amount', 'type', 'currency_id', 'created_at']; $settings = ['sort' => 'created_at', 'direction' => 'desc']; $transformer = function ($element) { $element->edit_uri = route('admin.sanatorium.shoppricing.money.edit', $element->id); return $element; }; return datagrid($data, $columns, $settings, $transformer); }
/** * Datasource for the paymenttype Data Grid. * * @return \Cartalyst\DataGrid\DataGrid */ public function grid() { $data = $this->paymenttypes->grid(); $columns = ['id', 'code', 'money_min', 'money_max', 'payment_service', 'created_at']; $settings = ['sort' => 'created_at', 'direction' => 'desc']; $transformer = function ($element) { $element->edit_uri = route('admin.sanatorium.shoporders.paymenttypes.edit', $element->id); return $element; }; return datagrid($data, $columns, $settings, $transformer); }
/** * Datasource for the products Data Grid. * * @return \Cartalyst\DataGrid\DataGrid */ public function grid() { $data = $this->products->grid(); $columns = ['id', 'name', 'image', 'price', 'desc', 'created_at']; $settings = ['sort' => 'created_at', 'direction' => 'desc']; $transformer = function ($element) { $element->edit_uri = route('admin.ocs.test.products.edit', $element->id); return $element; }; return datagrid($data, $columns, $settings, $transformer); }
/** * Datasource for the currency Data Grid. * * @return \Cartalyst\DataGrid\DataGrid */ public function grid() { $data = $this->currencies->grid(); $columns = ['id', 'name', 'code', 'unit', 'symbol', 'format', 'short_format', 'locale', 'created_at']; $settings = ['sort' => 'created_at', 'direction' => 'desc']; $transformer = function ($element) { $element->edit_uri = route('admin.sanatorium.shoppricing.currencies.edit', $element->id); return $element; }; return datagrid($data, $columns, $settings, $transformer); }
/** * Datasource for the transaction Data Grid. * * @return \Cartalyst\DataGrid\DataGrid */ public function grid() { $data = $this->transactions->grid(); $columns = ['id', 'Company', 'Calendar', 'Amount', 'Type', 'Paid_By', 'created_at']; $settings = ['sort' => 'created_at', 'direction' => 'desc']; $transformer = function ($element) { $element->edit_uri = route('admin.ocs.finance.transactions.edit', $element->id); return $element; }; return datagrid($data, $columns, $settings, $transformer); }
public static function table_list_grid($request, $table, $field, $condition, $order = '', $bilrow = 10, $dbg = 'N') { $error = ''; $x = 0; $cari = chk($request['cari']); $all = chk($request['fw_all']); $sql = "SELECT {$field} FROM {$table} WHERE {$condition}"; list($data, $sts) = Db::query($sql); if ($sts != '1') { echo $sts; } else { if ($order == '') { $order = Db::field_name($data, 0); } if ($cari != '') { $cari = str_replace("'", "''", $cari); $bil_field = Db::num_fields($data); $carian = ''; $array_field = explode(",", $field); //echo '<pre>'; print_r($array_field); echo '</pre>'; $bil_field = count($array_field); for ($a = 0; $a < $bil_field; $a++) { $nama_field = Db::field_name($data, $a); // $nama_field_all = $array_field[$a]; // // $pos = strpos($nama_field_all, '*'); // // if ($pos === false) { // $nama_field = $nama_field_all; // switch (Db::$db) // { // case 'Pg': // $carian = "$carian CAST($nama_field AS TEXT) ILIKE '%$cari%' OR"; // break; // case 'Mysql': // $carian = "$carian $nama_field LIKE '%$cari%' OR"; // break; // case 'Oci': // $carian = "$carian lower($nama_field) LIKE lower('%$cari%') OR"; // break; // } // } $type_field = Db::field_type($data, $a); $array_type = array("timestamp", "float8", "int4"); foreach ($array_field as $fieldselect) { if (strpos($fieldselect, $nama_field) !== false) { $nama_field = $fieldselect; } $position = strpos($nama_field, ' as '); if ($position != '') { $nama_field = substr($nama_field, '0', $position); } $position = strpos($nama_field, ' AS '); if ($position != '') { $nama_field = substr($nama_field, '0', $position); } $nama_field = str_replace('DISTINCT ', '', $nama_field); } if (!in_array($type_field, $array_type)) { switch (Db::$db) { case 'Pg': $carian = "{$carian} CAST({$nama_field} AS TEXT) ILIKE '%{$cari}%' OR"; break; case 'Mysql': $carian = "{$carian} {$nama_field} LIKE '%{$cari}%' OR"; break; case 'Oci': $carian = "{$carian} lower({$nama_field}) LIKE lower('%{$cari}%') OR"; break; } } } $carian = "(" . substr($carian, 1, -3) . ")"; $condition = "{$condition} AND {$carian}"; } $totalreturned = Db::num_rows($table, $field, $condition); $request = datagrid($request, $totalreturned, $bilrow); $request['fw_all'] = $all; $page_end = $request['page_end']; $bilrow = $request['bilrow']; $limit = $request['limit']; if ($totalreturned == $page_end) { $page_end = $page_end - $bilrow; } if ($page_end < '0') { $page_end = '0'; } if (Db::$db == 'Oci') { $maxrow = $page_end + $bilrow; $sql = "SELECT * FROM (\n SELECT a.*, ROWNUM fw_bil FROM (\n SELECT {$field}\n FROM {$table}\n WHERE {$condition}\n ORDER BY {$order}\n ) a WHERE rownum <= {$maxrow}\n ) where fw_bil > {$page_end}"; // ORDER BY $order"; } else { $condition = "{$condition} ORDER BY {$order} LIMIT {$bilrow} OFFSET {$page_end} "; $sql = "SELECT {$field} FROM {$table} WHERE {$condition}"; } list($data, $sts) = Db::query($sql); if ($sts != '1') { echo $sts; } else { $datarow = Db::fetch_assoc($data); if (is_array($datarow)) { foreach ($datarow as $row => $value) { $datarow[$row]['fw_bil'] = $row + $page_end; } } } } if ($dbg == 'Y') { echo "<br>DEBUG : " . $sql . "<br>"; } elseif ($dbg == 'D') { echo "<br>DEBUG : " . $sql . "<br>"; echo "<pre>"; print_r($datarow); echo "</pre>"; } return array('totalreturned' => $totalreturned, 'page_end' => $page_end, 'request' => $request, 'fw_senarai' => chk($datarow)); }