public function __construct($id) { parent::__construct($id); $this->view = 'programs_oug.index'; $this->icon = 'admin/img/icons/dt/settings.png'; $this->caption = 'Lista '; $this->toolbar = 'programs_oug.toolbar'; $this->name = 'dt'; $this->display_start = 0; $this->display_length = 10; $this->default_order = "1,'asc'"; $this->form = 'App\\Http\\Controllers\\Programoug\\ProgramougForm'; $this->css = 'packages/datatables/css/1.10.4/datatable.css, packages/datatables/css/1.10.4/dataTables.bootstrap.css, admin/css/dt/dt.css, admin/css/dt/dtform.css, packages/daterangepicker/css/daterangepicker-bs3.css, packages/datepicker/css/bootstrap-datepicker3.css '; $this->js = 'admin/js/libraries/form/dtform.js, packages/daterangepicker/js/daterangepicker.js, packages/datepicker/js/bootstrap-datepicker.js '; $this->row_source = 'programoug_index_row_source'; $this->rows_source_sql = 'SELECT * FROM programs_oug :where: :order:'; $this->count_filtered_records_sql = 'SELECT COUNT(*) as cnt FROM programs_oug :where:'; $this->count_total_records_sql = 'SELECT COUNT(*) AS cnt FROM programs_oug'; $this->columns = ['1' => ['id' => '#', 'orderable' => 'no', 'class' => 'td-record-count td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Nr', 'style' => 'width:3%'], 'type' => 'row-number', 'source' => 'row-number'], '2' => ['id' => 'address', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Adresa', 'style' => 'width:20%'], 'type' => 'field', 'source' => 'address'], '3' => ['id' => 'locality', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Localitatea', 'style' => 'width:20%'], 'type' => 'field', 'source' => 'locality'], '4' => ['id' => 'county', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Judetul', 'style' => 'width:20%'], 'type' => 'field', 'source' => 'county'], '5' => ['id' => 'owner', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Proiectant', 'style' => 'width:20%'], 'type' => 'field', 'source' => 'owner'], '6' => ['id' => 'realization_year', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Anul Realizarii', 'style' => 'width:10%'], 'type' => 'field', 'source' => 'realization_year'], '7' => ['id' => 'action', 'orderable' => 'no', 'class' => 'td-align-center td-actions', 'visible' => 'yes', 'header' => ['caption' => 'Acțiuni', 'style' => 'width:7%'], 'type' => 'view', 'source' => 'programs_dmi.~actions']]; $this->fields = ['fields' => '', 'searchables' => 'id, address', 'orderables' => [1 => 'id', 2 => 'address']]; $this->filters = ['deleted' => 'deleted_at is null']; }
public function __construct($id) { parent::__construct($id); $this->view = 'statistical_indicators.index'; $this->icon = 'admin/img/icons/dt/settings.png'; $this->caption = 'Lista Indicatori Statistici'; $this->toolbar = 'statistical_indicators.toolbar'; $this->name = 'dt'; $this->display_start = 0; $this->display_length = 10; $this->default_order = "1,'asc'"; $this->form = 'App\\Http\\Controllers\\Indicators\\IndicatorsForm'; $this->css = 'packages/datatables/css/1.10.4/datatable.css, packages/datatables/css/1.10.4/dataTables.bootstrap.css, admin/css/dt/dt.css, admin/css/dt/dtform.css, '; $this->js = 'admin/js/libraries/form/dtform.js, '; $this->row_source = 'indicators_index_row_source'; $this->rows_source_sql = 'SELECT * FROM statistical_indicators :where: :order:'; $this->count_filtered_records_sql = 'SELECT COUNT(*) as cnt FROM statistical_indicators :where:'; $this->count_total_records_sql = 'SELECT COUNT(*) AS cnt FROM statistical_indicators'; $this->columns = ['1' => ['id' => '#', 'orderable' => 'no', 'class' => 'td-record-count td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Nr', 'style' => 'width:3%'], 'type' => 'row-number', 'source' => 'row-number'], '2' => ['id' => 'nr_indicator', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Indicator', 'style' => 'width:10%'], 'type' => 'field', 'source' => 'nr_indicator'], '3' => ['id' => 'name', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Denumire Indicator', 'style' => 'width:80%'], 'type' => 'field', 'source' => 'name'], '4' => ['id' => 'action', 'orderable' => 'no', 'class' => 'td-align-center td-actions', 'visible' => 'yes', 'header' => ['caption' => 'Acțiuni', 'style' => 'width:7%'], 'type' => 'view', 'source' => 'statistical_indicators.~actions']]; $this->fields = ['fields' => '', 'searchables' => 'name', 'orderables' => [1 => 'name']]; $this->filters = ['deleted' => 'deleted_at is null']; }
public function __construct($id) { parent::__construct($id); $this->view = 'suppliers_list.index'; $this->icon = 'admin/img/icons/dt/settings.png'; $this->caption = 'Lista Furnizori'; $this->toolbar = 'suppliers_list.toolbar'; $this->name = 'dt'; $this->display_start = 0; $this->display_length = 10; $this->default_order = "1,'asc'"; $this->form = 'App\\Http\\Controllers\\Suppliers\\SuppliersForm'; $this->css = 'packages/datatables/css/1.10.4/datatable.css, packages/datatables/css/1.10.4/dataTables.bootstrap.css, admin/css/dt/dt.css, admin/css/dt/dtform.css, '; $this->js = 'admin/js/libraries/form/dtform.js, '; $this->row_source = 'suppliers_index_row_source'; $this->rows_source_sql = 'SELECT * FROM suppliers_list :where: :order:'; $this->count_filtered_records_sql = 'SELECT COUNT(*) as cnt FROM suppliers_list :where:'; $this->count_total_records_sql = 'SELECT COUNT(*) AS cnt FROM suppliers_list'; $this->columns = ['1' => ['id' => '#', 'orderable' => 'no', 'class' => 'td-record-count td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Nr', 'style' => 'width:3%'], 'type' => 'row-number', 'source' => 'row-number'], '2' => ['id' => 'name', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Denumire Furnizor', 'style' => 'width:28%'], 'type' => 'field', 'source' => 'name'], '3' => ['id' => 'type', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Tip Factura', 'style' => 'width:18%'], 'type' => 'view', 'source' => 'suppliers_list.~type_utility'], '4' => ['id' => 'unit_measurement', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'U.M.', 'style' => 'width:8%'], 'type' => 'field', 'source' => 'unit_measurement'], '5' => ['id' => 'address', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Adresa', 'style' => 'width:18%'], 'type' => 'field', 'source' => 'address'], '6' => ['id' => 'test', 'orderable' => 'no', 'class' => 'td-align-center td-actions', 'visible' => 'yes', 'header' => ['caption' => 'Localizare', 'style' => 'width:7%'], 'type' => 'view', 'source' => 'suppliers_list.~locating'], '7' => ['id' => 'action', 'orderable' => 'no', 'class' => 'td-align-center td-actions', 'visible' => 'yes', 'header' => ['caption' => 'Acțiuni', 'style' => 'width:7%'], 'type' => 'view', 'source' => 'suppliers_list.~actions']]; $this->fields = ['fields' => '', 'searchables' => 'name', 'orderables' => [1 => 'name']]; $this->filters = ['deleted' => 'deleted_at is null']; }
public function __construct($id) { parent::__construct($id); $this->view = 'measuring_points.index'; $this->icon = 'admin/img/icons/dt/settings.png'; $this->caption = 'Puncte de masurare a iluminatului public'; $this->toolbar = 'measuring_points.toolbar'; $this->name = 'dt'; $this->display_start = 0; $this->display_length = 10; $this->default_order = "1,'asc'"; $this->form = 'App\\Http\\Controllers\\Measuringpoints\\MeasuringpointsForm'; $this->css = 'packages/datatables/css/1.10.4/datatable.css, packages/datatables/css/1.10.4/dataTables.bootstrap.css, admin/css/dt/dt.css, admin/css/dt/dtform.css, '; $this->js = 'admin/js/libraries/form/dtform.js, '; $this->row_source = 'points_index_row_source'; $this->rows_source_sql = 'SELECT * FROM measuring_points :where: :order:'; $this->count_filtered_records_sql = 'SELECT COUNT(*) as cnt FROM measuring_points :where:'; $this->count_total_records_sql = 'SELECT COUNT(*) AS cnt FROM measuring_points'; $this->columns = ['1' => ['id' => '#', 'orderable' => 'no', 'class' => 'td-record-count td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Nr', 'style' => 'width:3%'], 'type' => 'row-number', 'source' => 'row-number'], '2' => ['id' => 'address', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Adresa Punct De Masurare', 'style' => 'width:30%'], 'type' => 'field', 'source' => 'address'], '3' => ['id' => 'locality', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Localitate', 'style' => 'width:20%'], 'type' => 'field', 'source' => 'locality'], '4' => ['id' => 'county', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Judet', 'style' => 'width:20%'], 'type' => 'field', 'source' => 'county'], '5' => ['id' => 'nlc', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'NLC', 'style' => 'width:20%'], 'type' => 'field', 'source' => 'nlc'], '6' => ['id' => 'action', 'orderable' => 'no', 'class' => 'td-align-center td-actions', 'visible' => 'yes', 'header' => ['caption' => 'Acțiuni', 'style' => 'width:7%'], 'type' => 'view', 'source' => 'measuring_points.~actions']]; $this->fields = ['fields' => '', 'searchables' => 'address', 'orderables' => [1 => 'address']]; $this->filters = ['deleted' => 'deleted_at is null']; }
public function __construct($id) { parent::__construct($id); $this->view = 'bills.index'; $this->icon = 'admin/img/icons/dt/settings.png'; $this->caption = 'Lista Facturi'; $this->toolbar = 'bills.toolbar'; $this->name = 'dt'; $this->display_start = 0; $this->display_length = 10; $this->default_order = "1,'asc'"; $this->form = 'App\\Http\\Controllers\\Bills\\BillsForm'; $this->css = 'packages/datatables/css/1.10.4/datatable.css, packages/datatables/css/1.10.4/dataTables.bootstrap.css, admin/css/dt/dt.css, admin/css/dt/dtform.css, packages/daterangepicker/css/daterangepicker-bs3.css, packages/datepicker/css/bootstrap-datepicker3.css '; $this->js = 'admin/js/libraries/form/dtform.js, packages/daterangepicker/js/daterangepicker.js, packages/datepicker/js/bootstrap-datepicker.js '; $this->row_source = 'bills_index_row_source'; $this->rows_source_sql = 'SELECT * FROM bills :where: :order:'; $this->count_filtered_records_sql = 'SELECT COUNT(*) as cnt FROM bills :where:'; $this->count_total_records_sql = 'SELECT COUNT(*) AS cnt FROM bills'; $this->columns = ['1' => ['id' => '#', 'orderable' => 'no', 'class' => 'td-record-count td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Nr', 'style' => 'width:3%'], 'type' => 'row-number', 'source' => 'row-number'], '2' => ['id' => 'nr_bill', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Nr Factura', 'style' => 'width:18%'], 'type' => 'field', 'source' => 'nr_bill'], '3' => ['id' => 'type_bill', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Tip Factura', 'style' => 'width:18%'], 'type' => 'view', 'source' => 'bills.~type_bill'], '4' => ['id' => 'consumption_billed', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Consum Facturat', 'style' => 'width:18%'], 'type' => 'field', 'source' => 'consumption_billed'], '5' => ['id' => 'value_witch_tva', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Val Tot cu T.V.A.', 'style' => 'width:18%'], 'type' => 'field', 'source' => 'value_witch_tva'], '6' => ['id' => 'date_bill', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Data Facturii', 'style' => 'width:18%'], 'type' => 'field', 'source' => 'date_bill'], '7' => ['id' => 'action', 'orderable' => 'no', 'class' => 'td-align-center td-actions', 'visible' => 'yes', 'header' => ['caption' => 'Acțiuni', 'style' => 'width:7%'], 'type' => 'view', 'source' => 'bills.~actions']]; $this->fields = ['fields' => '', 'searchables' => 'id', 'orderables' => [1 => 'id']]; $this->filters = ['deleted' => 'deleted_at is null']; }
public function __construct($id) { parent::__construct($id); $this->view = 'public_enlightments.index'; $this->icon = 'admin/img/icons/dt/settings.png'; $this->caption = 'Lista Facturi'; $this->toolbar = 'public_enlightments.toolbar'; $this->name = 'dt'; $this->display_start = 0; $this->display_length = 10; $this->default_order = "1,'asc'"; $this->form = 'App\\Http\\Controllers\\Publiclighting\\PubliclightingForm'; $this->css = 'packages/datatables/css/1.10.4/datatable.css, packages/datatables/css/1.10.4/dataTables.bootstrap.css, admin/css/dt/dt.css, admin/css/dt/dtform.css, packages/daterangepicker/css/daterangepicker-bs3.css, packages/datepicker/css/bootstrap-datepicker3.css '; $this->js = 'admin/js/libraries/form/dtform.js, packages/daterangepicker/js/daterangepicker.js, packages/datepicker/js/bootstrap-datepicker.js '; $this->row_source = 'publiclighting_index_row_source'; $this->rows_source_sql = 'SELECT * FROM public_enlightments :where: :order:'; $this->count_filtered_records_sql = 'SELECT COUNT(*) as cnt FROM public_enlightments :where:'; $this->count_total_records_sql = 'SELECT COUNT(*) AS cnt FROM public_enlightments'; $this->columns = ['1' => ['id' => '#', 'orderable' => 'no', 'class' => 'td-record-count td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Nr', 'style' => 'width:3%'], 'type' => 'row-number', 'source' => 'row-number'], '2' => ['id' => 'provider_id', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Denumire Furnizor', 'style' => 'width:18%'], 'type' => 'view', 'source' => 'public_enlightments.~type_utility'], '3' => ['id' => 'measuring_point', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Punct De Masurare', 'style' => 'width:18%'], 'type' => 'view', 'source' => 'public_enlightments.~type_point'], '4' => ['id' => 'nr_bill', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Numar Factura', 'style' => 'width:18%'], 'type' => 'field', 'source' => 'nr_bill'], '5' => ['id' => 'date_of_issue', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Data Emitetii Facturii', 'style' => 'width:18%'], 'type' => 'field', 'source' => 'date_of_issue'], '6' => ['id' => 'action', 'orderable' => 'no', 'class' => 'td-align-center td-actions', 'visible' => 'yes', 'header' => ['caption' => 'Acțiuni', 'style' => 'width:7%'], 'type' => 'view', 'source' => 'public_enlightments.~actions']]; $this->fields = ['fields' => '', 'searchables' => 'provider_id', 'orderables' => [1 => 'provider_id']]; $this->filters = ['deleted' => 'deleted_at is null']; }
public function __construct($id) { parent::__construct($id); $this->view = 'vehicles.index'; $this->icon = 'admin/img/icons/dt/settings.png'; $this->caption = 'Lista Vehicole'; $this->toolbar = 'vehicles.toolbar'; $this->name = 'dt'; $this->display_start = 0; $this->display_length = 10; $this->default_order = "1,'asc'"; $this->form = 'App\\Http\\Controllers\\Vehicles\\VehiclesForm'; $this->css = 'packages/datatables/css/1.10.4/datatable.css, packages/datatables/css/1.10.4/dataTables.bootstrap.css, admin/css/dt/dt.css, admin/css/dt/dtform.css, '; $this->js = 'admin/js/libraries/form/dtform.js, '; $this->row_source = 'vehicles_index_row_source'; $this->rows_source_sql = 'SELECT * FROM vehicles :where: :order:'; $this->count_filtered_records_sql = 'SELECT COUNT(*) as cnt FROM vehicles :where:'; $this->count_total_records_sql = 'SELECT COUNT(*) AS cnt FROM vehicles'; $this->columns = ['1' => ['id' => '#', 'orderable' => 'no', 'class' => 'td-record-count td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Nr', 'style' => 'width:3%'], 'type' => 'row-number', 'source' => 'row-number'], '2' => ['id' => 'fleet_type', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Tip Flota Auto', 'style' => 'width:18%'], 'type' => 'field', 'source' => 'fleet_type'], '3' => ['id' => 'vehicle_type', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Tip Vehicol', 'style' => 'width:18%'], 'type' => 'field', 'source' => 'vehicle_type'], '4' => ['id' => 'license_plate_number', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Numar De Inmatriculare', 'style' => 'width:18%'], 'type' => 'field', 'source' => 'license_plate_number'], '5' => ['id' => 'fuel_type', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Tip Combustibil Utilizat', 'style' => 'width:18%'], 'type' => 'field', 'source' => 'fuel_type'], '6' => ['id' => 'year_of_manufacture', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'An Fabricatie', 'style' => 'width:18%'], 'type' => 'field', 'source' => 'year_of_manufacture'], '7' => ['id' => 'action', 'orderable' => 'no', 'class' => 'td-align-center td-actions', 'visible' => 'yes', 'header' => ['caption' => 'Acțiuni', 'style' => 'width:7%'], 'type' => 'view', 'source' => 'vehicles.~actions']]; $this->fields = ['fields' => '', 'searchables' => 'id', 'fleet_type', 'orderables' => [1 => 'id', 2 => 'fleet_type']]; $this->filters = ['deleted' => 'deleted_at is null']; }
public function __construct($id) { parent::__construct($id); $this->view = 'consumptions.index'; $this->icon = 'admin/img/icons/dt/settings.png'; $this->caption = 'Lista Consumuri'; $this->toolbar = 'consumptions.toolbar'; $this->name = 'dt'; $this->display_start = 0; $this->display_length = 10; $this->default_order = "1,'asc'"; $this->form = 'App\\Http\\Controllers\\Consumptions\\ConsumptionsForm'; $this->css = 'packages/datatables/css/1.10.4/datatable.css, packages/datatables/css/1.10.4/dataTables.bootstrap.css, admin/css/dt/dt.css, admin/css/dt/dtform.css, '; $this->js = 'admin/js/libraries/form/dtform.js'; $this->row_source = 'consumptions_index_row_source'; $this->rows_source_sql = 'SELECT * FROM consumptions :where: :order:'; $this->count_filtered_records_sql = 'SELECT COUNT(*) as cnt FROM consumptions :where:'; $this->count_total_records_sql = 'SELECT COUNT(*) AS cnt FROM consumptions'; $this->columns = ['1' => ['id' => '#', 'orderable' => 'no', 'class' => 'td-record-count td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Nr', 'style' => 'width:3%'], 'type' => 'row-number', 'source' => 'row-number'], '2' => ['id' => 'year_faz', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'An Faz', 'style' => 'width:18%'], 'type' => 'field', 'source' => 'year_faz'], '3' => ['id' => 'month_faz', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Luna Faz', 'style' => 'width:18%'], 'type' => 'field', 'source' => 'month_faz'], '4' => ['id' => 'month_distance', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Distanta Lunara Parcursa In Km', 'style' => 'width:18%'], 'type' => 'field', 'source' => 'month_distance'], '5' => ['id' => 'monthly_consumption', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Consumul Total Pe Luna In Litri', 'style' => 'width:18%'], 'type' => 'field', 'source' => 'monthly_consumption'], '6' => ['id' => 'action', 'orderable' => 'no', 'class' => 'td-align-center td-actions', 'visible' => 'yes', 'header' => ['caption' => 'Acțiuni', 'style' => 'width:7%'], 'type' => 'view', 'source' => 'vehicles.~actions']]; $this->fields = ['fields' => '', 'searchables' => 'id', 'fleet_type', 'orderables' => [1 => 'id', 2 => 'fleet_type']]; $this->filters = ['deleted' => 'deleted_at is null']; }
public function __construct($id) { parent::__construct($id); $this->view = 'consum.cladiri.index'; $this->ngCtrl = ''; $this->icon = 'admin/img/icons/dt/settings.png'; $this->caption = 'Lista Clădiri'; $this->toolbar = 'consum.cladiri.toolbar'; $this->name = 'dt'; $this->display_start = 0; $this->display_length = 10; $this->default_order = "1,'asc'"; $this->form = null; $this->css = 'packages/datatables/css/1.10.4/datatable.css, packages/datatables/css/1.10.4/dataTables.bootstrap.css, admin/css/dt/dt.css, admin/css/dt/toolbar.css, admin/css/dt/dtform.css, '; $this->js = 'admin/js/libraries/form/dtform.js, custom/js/angular/controllers/buildCtrl.js, custom/js/angular/services/Count.js'; $this->row_source = 'consum_institutie_buildings_index_row_source'; $this->rows_source_sql = 'SELECT * FROM buildings :where: :order:'; $this->count_filtered_records_sql = 'SELECT COUNT(*) as cnt FROM buildings :where:'; $this->count_total_records_sql = 'SELECT COUNT(*) AS cnt FROM buildings'; $this->columns = ['1' => ['id' => '#', 'orderable' => 'no', 'class' => 'td-record-count td-align-center', 'visible' => 'yes', 'header' => ['caption' => '#', 'style' => 'width:3%'], 'type' => 'row-number', 'source' => 'row-number'], '2' => ['id' => 'name', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Nume cladire', 'style' => 'width:50%'], 'type' => 'field', 'source' => 'name'], '3' => ['id' => 'locality', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Localitatea', 'style' => 'width:20%'], 'type' => 'field', 'source' => 'locality'], '4' => ['id' => 'action', 'orderable' => 'no', 'class' => 'td-align-center td-actions', 'visible' => 'yes', 'header' => ['caption' => 'Acțiuni', 'style' => 'width:7%'], 'type' => 'view', 'source' => 'consum.cladiri.~actions']]; $this->fields = ['fields' => '', 'searchables' => 'id, name', 'orderables' => [1 => 'id', 2 => 'name']]; $this->filters = ['deleted' => 'deleted_at is null']; }