/**
* 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));
}
