|
1
|
|
|
<?php namespace crocodicstudio\crudbooster\controllers; |
|
2
|
|
|
|
|
3
|
|
|
error_reporting(E_ALL ^ E_NOTICE); |
|
4
|
|
|
|
|
5
|
|
|
|
|
6
|
|
|
use CB; |
|
7
|
|
|
use CRUDBooster; |
|
|
|
|
|
|
8
|
|
|
use Illuminate\Support\Facades\App; |
|
9
|
|
|
use Illuminate\Support\Facades\Cache; |
|
10
|
|
|
use Illuminate\Support\Facades\DB; |
|
11
|
|
|
use Illuminate\Support\Facades\Hash; |
|
12
|
|
|
use Illuminate\Support\Facades\PDF; |
|
|
|
|
|
|
13
|
|
|
use Illuminate\Support\Facades\Request; |
|
14
|
|
|
use Illuminate\Support\Facades\Route; |
|
15
|
|
|
use Illuminate\Support\Facades\Session; |
|
16
|
|
|
use Illuminate\Support\Facades\Storage; |
|
17
|
|
|
use Illuminate\Support\Facades\Validator; |
|
18
|
|
|
use Maatwebsite\Excel\Facades\Excel; |
|
19
|
|
|
use Schema; |
|
20
|
|
|
|
|
21
|
|
|
class CBController extends Controller |
|
22
|
|
|
{ |
|
23
|
|
|
public $data_inputan; |
|
24
|
|
|
|
|
25
|
|
|
public $columns_table; |
|
26
|
|
|
|
|
27
|
|
|
public $module_name; |
|
28
|
|
|
|
|
29
|
|
|
public $table; |
|
30
|
|
|
|
|
31
|
|
|
public $title_field; |
|
32
|
|
|
|
|
33
|
|
|
public $primary_key = 'id'; |
|
34
|
|
|
|
|
35
|
|
|
public $arr = []; |
|
36
|
|
|
|
|
37
|
|
|
public $col = []; |
|
38
|
|
|
|
|
39
|
|
|
public $form = []; |
|
40
|
|
|
|
|
41
|
|
|
public $data = []; |
|
42
|
|
|
|
|
43
|
|
|
public $addaction = []; |
|
44
|
|
|
|
|
45
|
|
|
public $orderby = null; |
|
46
|
|
|
|
|
47
|
|
|
public $password_candidate = null; |
|
48
|
|
|
|
|
49
|
|
|
public $date_candidate = null; |
|
50
|
|
|
|
|
51
|
|
|
public $limit = 20; |
|
52
|
|
|
|
|
53
|
|
|
public $global_privilege = false; |
|
54
|
|
|
|
|
55
|
|
|
public $show_numbering = false; |
|
56
|
|
|
|
|
57
|
|
|
public $alert = []; |
|
58
|
|
|
|
|
59
|
|
|
public $index_button = []; |
|
60
|
|
|
|
|
61
|
|
|
public $button_filter = true; |
|
62
|
|
|
|
|
63
|
|
|
public $button_export = true; |
|
64
|
|
|
|
|
65
|
|
|
public $button_import = true; |
|
66
|
|
|
|
|
67
|
|
|
public $button_show = true; |
|
68
|
|
|
|
|
69
|
|
|
public $button_addmore = true; |
|
70
|
|
|
|
|
71
|
|
|
public $button_table_action = true; |
|
72
|
|
|
|
|
73
|
|
|
public $button_bulk_action = true; |
|
74
|
|
|
|
|
75
|
|
|
public $button_add = true; |
|
76
|
|
|
|
|
77
|
|
|
public $button_delete = true; |
|
78
|
|
|
|
|
79
|
|
|
public $button_cancel = true; |
|
80
|
|
|
|
|
81
|
|
|
public $button_save = true; |
|
82
|
|
|
|
|
83
|
|
|
public $button_edit = true; |
|
84
|
|
|
|
|
85
|
|
|
public $button_detail = true; |
|
86
|
|
|
|
|
87
|
|
|
public $button_action_style = 'button_icon'; |
|
88
|
|
|
|
|
89
|
|
|
public $button_action_width = null; |
|
90
|
|
|
|
|
91
|
|
|
public $index_statistic = []; |
|
92
|
|
|
|
|
93
|
|
|
public $index_additional_view = []; |
|
94
|
|
|
|
|
95
|
|
|
public $pre_index_html = null; |
|
96
|
|
|
|
|
97
|
|
|
public $post_index_html = null; |
|
98
|
|
|
|
|
99
|
|
|
public $load_js = []; |
|
100
|
|
|
|
|
101
|
|
|
public $load_css = []; |
|
102
|
|
|
|
|
103
|
|
|
public $script_js = null; |
|
104
|
|
|
|
|
105
|
|
|
public $style_css = null; |
|
106
|
|
|
|
|
107
|
|
|
public $sub_module = []; |
|
108
|
|
|
|
|
109
|
|
|
public $show_addaction = true; |
|
110
|
|
|
|
|
111
|
|
|
public $table_row_color = []; |
|
112
|
|
|
|
|
113
|
|
|
public $button_selected = []; |
|
114
|
|
|
|
|
115
|
|
|
public $return_url = null; |
|
116
|
|
|
|
|
117
|
|
|
public $parent_field = null; |
|
118
|
|
|
|
|
119
|
|
|
public $parent_id = null; |
|
120
|
|
|
|
|
121
|
|
|
public $hide_form = []; |
|
122
|
|
|
|
|
123
|
|
|
public $index_return = false; //for export |
|
124
|
|
|
|
|
125
|
|
|
public $sidebar_mode = 'normal'; |
|
126
|
|
|
|
|
127
|
|
|
public function cbLoader() |
|
128
|
|
|
{ |
|
129
|
|
|
$this->cbInit(); |
|
|
|
|
|
|
130
|
|
|
|
|
131
|
|
|
$this->checkHideForm(); |
|
132
|
|
|
|
|
133
|
|
|
$this->primary_key = CB::pk($this->table); |
|
134
|
|
|
$this->columns_table = $this->col; |
|
135
|
|
|
$this->data_inputan = $this->form; |
|
136
|
|
|
$this->data['pk'] = $this->primary_key; |
|
137
|
|
|
$this->data['forms'] = $this->data_inputan; |
|
138
|
|
|
$this->data['hide_form'] = $this->hide_form; |
|
139
|
|
|
$this->data['addaction'] = ($this->show_addaction) ? $this->addaction : null; |
|
140
|
|
|
$this->data['table'] = $this->table; |
|
141
|
|
|
$this->data['title_field'] = $this->title_field; |
|
142
|
|
|
$this->data['appname'] = CRUDBooster::getSetting('appname'); |
|
143
|
|
|
$this->data['alerts'] = $this->alert; |
|
144
|
|
|
$this->data['index_button'] = $this->index_button; |
|
145
|
|
|
$this->data['show_numbering'] = $this->show_numbering; |
|
146
|
|
|
$this->data['button_detail'] = $this->button_detail; |
|
147
|
|
|
$this->data['button_edit'] = $this->button_edit; |
|
148
|
|
|
$this->data['button_show'] = $this->button_show; |
|
149
|
|
|
$this->data['button_add'] = $this->button_add; |
|
150
|
|
|
$this->data['button_delete'] = $this->button_delete; |
|
151
|
|
|
$this->data['button_filter'] = $this->button_filter; |
|
152
|
|
|
$this->data['button_export'] = $this->button_export; |
|
153
|
|
|
$this->data['button_addmore'] = $this->button_addmore; |
|
154
|
|
|
$this->data['button_cancel'] = $this->button_cancel; |
|
155
|
|
|
$this->data['button_save'] = $this->button_save; |
|
156
|
|
|
$this->data['button_table_action'] = $this->button_table_action; |
|
157
|
|
|
$this->data['button_bulk_action'] = $this->button_bulk_action; |
|
158
|
|
|
$this->data['button_import'] = $this->button_import; |
|
159
|
|
|
$this->data['button_action_width'] = $this->button_action_width; |
|
160
|
|
|
$this->data['button_selected'] = $this->button_selected; |
|
161
|
|
|
$this->data['index_statistic'] = $this->index_statistic; |
|
162
|
|
|
$this->data['index_additional_view'] = $this->index_additional_view; |
|
163
|
|
|
$this->data['table_row_color'] = $this->table_row_color; |
|
164
|
|
|
$this->data['pre_index_html'] = $this->pre_index_html; |
|
165
|
|
|
$this->data['post_index_html'] = $this->post_index_html; |
|
166
|
|
|
$this->data['load_js'] = $this->load_js; |
|
167
|
|
|
$this->data['load_css'] = $this->load_css; |
|
168
|
|
|
$this->data['script_js'] = $this->script_js; |
|
169
|
|
|
$this->data['style_css'] = $this->style_css; |
|
170
|
|
|
$this->data['sub_module'] = $this->sub_module; |
|
171
|
|
|
$this->data['parent_field'] = (g('parent_field')) ?: $this->parent_field; |
|
172
|
|
|
$this->data['parent_id'] = (g('parent_id')) ?: $this->parent_id; |
|
173
|
|
|
|
|
174
|
|
|
if ($this->sidebar_mode == 'mini') { |
|
175
|
|
|
$this->data['sidebar_mode'] = 'sidebar-mini'; |
|
176
|
|
|
} elseif ($this->sidebar_mode == 'collapse') { |
|
177
|
|
|
$this->data['sidebar_mode'] = 'sidebar-collapse'; |
|
178
|
|
|
} elseif ($this->sidebar_mode == 'collapse-mini') { |
|
179
|
|
|
$this->data['sidebar_mode'] = 'sidebar-collapse sidebar-mini'; |
|
180
|
|
|
} else { |
|
181
|
|
|
$this->data['sidebar_mode'] = ''; |
|
182
|
|
|
} |
|
183
|
|
|
|
|
184
|
|
|
if (CRUDBooster::getCurrentMethod() == 'getProfile') { |
|
185
|
|
|
Session::put('current_row_id', CRUDBooster::myId()); |
|
186
|
|
|
$this->data['return_url'] = Request::fullUrl(); |
|
187
|
|
|
} |
|
188
|
|
|
|
|
189
|
|
|
view()->share($this->data); |
|
190
|
|
|
} |
|
191
|
|
|
|
|
192
|
|
|
public function cbView($template, $data) |
|
193
|
|
|
{ |
|
194
|
|
|
header("Content-Type: text/html"); |
|
195
|
|
|
$this->cbLoader(); |
|
196
|
|
|
echo view($template, $data); |
|
197
|
|
|
} |
|
198
|
|
|
|
|
199
|
|
|
private function checkHideForm() |
|
200
|
|
|
{ |
|
201
|
|
|
if ($this->hide_form && count($this->hide_form)) { |
|
|
|
|
|
|
202
|
|
|
foreach ($this->form as $i => $f) { |
|
203
|
|
|
if (in_array($f['name'], $this->hide_form)) { |
|
204
|
|
|
unset($this->form[$i]); |
|
205
|
|
|
} |
|
206
|
|
|
} |
|
207
|
|
|
} |
|
208
|
|
|
} |
|
209
|
|
|
|
|
210
|
|
|
public function getIndex() |
|
211
|
|
|
{ |
|
212
|
|
|
$this->cbLoader(); |
|
213
|
|
|
|
|
214
|
|
|
$module = CRUDBooster::getCurrentModule(); |
|
215
|
|
|
|
|
216
|
|
|
if (! CRUDBooster::isView() && $this->global_privilege == false) { |
|
217
|
|
|
CRUDBooster::insertLog(trans('crudbooster.log_try_view', ['module' => $module->name])); |
|
218
|
|
|
CRUDBooster::redirect(CRUDBooster::adminPath(), trans('crudbooster.denied_access')); |
|
219
|
|
|
} |
|
220
|
|
|
|
|
221
|
|
|
if (Request::get('parent_table')) { |
|
222
|
|
|
$parentTablePK = CB::pk(g('parent_table')); |
|
223
|
|
|
$data['parent_table'] = DB::table(Request::get('parent_table'))->where($parentTablePK, Request::get('parent_id'))->first(); |
|
|
|
|
|
|
224
|
|
|
if (Request::get('foreign_key')) { |
|
225
|
|
|
$data['parent_field'] = Request::get('foreign_key'); |
|
226
|
|
|
} else { |
|
227
|
|
|
$data['parent_field'] = CB::getTableForeignKey(g('parent_table'), $this->table); |
|
228
|
|
|
} |
|
229
|
|
|
|
|
230
|
|
|
if ($parent_field) { |
|
|
|
|
|
|
231
|
|
|
foreach ($this->columns_table as $i => $col) { |
|
232
|
|
|
if ($col['name'] == $parent_field) { |
|
233
|
|
|
unset($this->columns_table[$i]); |
|
234
|
|
|
} |
|
235
|
|
|
} |
|
236
|
|
|
} |
|
237
|
|
|
} |
|
238
|
|
|
|
|
239
|
|
|
$data['table'] = $this->table; |
|
240
|
|
|
$data['table_pk'] = CB::pk($this->table); |
|
241
|
|
|
$data['page_title'] = $module->name; |
|
242
|
|
|
$data['page_description'] = trans('crudbooster.default_module_description'); |
|
243
|
|
|
$data['date_candidate'] = $this->date_candidate; |
|
244
|
|
|
$data['limit'] = $limit = (Request::get('limit')) ? Request::get('limit') : $this->limit; |
|
245
|
|
|
|
|
246
|
|
|
$tablePK = $data['table_pk']; |
|
247
|
|
|
$table_columns = CB::getTableColumns($this->table); |
|
248
|
|
|
$result = DB::table($this->table)->select(DB::raw($this->table.".".$this->primary_key)); |
|
249
|
|
|
|
|
250
|
|
|
if (Request::get('parent_id')) { |
|
251
|
|
|
$table_parent = $this->table; |
|
252
|
|
|
$table_parent = CRUDBooster::parseSqlTable($table_parent)['table']; |
|
253
|
|
|
$result->where($table_parent.'.'.Request::get('foreign_key'), Request::get('parent_id')); |
|
254
|
|
|
} |
|
255
|
|
|
|
|
256
|
|
|
$this->hook_query_index($result); |
|
257
|
|
|
|
|
258
|
|
|
if (in_array('deleted_at', $table_columns)) { |
|
259
|
|
|
$result->where($this->table.'.deleted_at', null); |
|
260
|
|
|
} |
|
261
|
|
|
|
|
262
|
|
|
$alias = []; |
|
263
|
|
|
$join_alias_count = 0; |
|
264
|
|
|
$join_table_temp = []; |
|
265
|
|
|
$table = $this->table; |
|
266
|
|
|
$columns_table = $this->columns_table; |
|
267
|
|
|
foreach ($columns_table as $index => $coltab) { |
|
268
|
|
|
|
|
269
|
|
|
$join = @$coltab['join']; |
|
270
|
|
|
$join_where = @$coltab['join_where']; |
|
271
|
|
|
$join_id = @$coltab['join_id']; |
|
272
|
|
|
$field = @$coltab['name']; |
|
273
|
|
|
$join_table_temp[] = $table; |
|
274
|
|
|
|
|
275
|
|
|
if (! $field) { |
|
276
|
|
|
continue; |
|
277
|
|
|
} |
|
278
|
|
|
|
|
279
|
|
|
if (strpos($field, ' as ') !== false) { |
|
280
|
|
|
$field = substr($field, strpos($field, ' as ') + 4); |
|
281
|
|
|
$field_with = (array_key_exists('join', $coltab)) ? str_replace(",", ".", $coltab['join']) : $field; |
|
282
|
|
|
$result->addselect(DB::raw($coltab['name'])); |
|
283
|
|
|
$columns_table[$index]['type_data'] = 'varchar'; |
|
284
|
|
|
$columns_table[$index]['field'] = $field; |
|
285
|
|
|
$columns_table[$index]['field_raw'] = $field; |
|
286
|
|
|
$columns_table[$index]['field_with'] = $field_with; |
|
287
|
|
|
$columns_table[$index]['is_subquery'] = true; |
|
288
|
|
|
continue; |
|
289
|
|
|
} |
|
290
|
|
|
|
|
291
|
|
|
if (strpos($field, '.') !== false) { |
|
292
|
|
|
$result->addselect($field); |
|
293
|
|
|
} else { |
|
294
|
|
|
$result->addselect($table.'.'.$field); |
|
295
|
|
|
} |
|
296
|
|
|
|
|
297
|
|
|
$field_array = explode('.', $field); |
|
298
|
|
|
|
|
299
|
|
|
if (isset($field_array[1])) { |
|
300
|
|
|
$field = $field_array[1]; |
|
301
|
|
|
$table = $field_array[0]; |
|
302
|
|
|
} else { |
|
303
|
|
|
$table = $this->table; |
|
304
|
|
|
} |
|
305
|
|
|
|
|
306
|
|
|
if ($join) { |
|
307
|
|
|
|
|
308
|
|
|
$join_exp = explode(',', $join); |
|
309
|
|
|
|
|
310
|
|
|
$join_table = $join_exp[0]; |
|
311
|
|
|
$joinTablePK = CB::pk($join_table); |
|
312
|
|
|
$join_column = $join_exp[1]; |
|
313
|
|
|
$join_alias = str_replace(".", "_", $join_table); |
|
314
|
|
|
|
|
315
|
|
|
if (in_array($join_table, $join_table_temp)) { |
|
316
|
|
|
$join_alias_count += 1; |
|
317
|
|
|
$join_alias = $join_table.$join_alias_count; |
|
318
|
|
|
} |
|
319
|
|
|
$join_table_temp[] = $join_table; |
|
320
|
|
|
|
|
321
|
|
|
$result->leftjoin($join_table.' as '.$join_alias, $join_alias.(($join_id) ? '.'.$join_id : '.'.$joinTablePK), '=', DB::raw($table.'.'.$field.(($join_where) ? ' AND '.$join_where.' ' : ''))); |
|
322
|
|
|
$result->addselect($join_alias.'.'.$join_column.' as '.$join_alias.'_'.$join_column); |
|
323
|
|
|
|
|
324
|
|
|
$join_table_columns = CRUDBooster::getTableColumns($join_table); |
|
325
|
|
|
if ($join_table_columns) { |
|
326
|
|
|
foreach ($join_table_columns as $jtc) { |
|
327
|
|
|
$result->addselect($join_alias.'.'.$jtc.' as '.$join_alias.'_'.$jtc); |
|
328
|
|
|
} |
|
329
|
|
|
} |
|
330
|
|
|
|
|
331
|
|
|
$alias[] = $join_alias; |
|
332
|
|
|
$columns_table[$index]['type_data'] = CRUDBooster::getFieldType($join_table, $join_column); |
|
333
|
|
|
$columns_table[$index]['field'] = $join_alias.'_'.$join_column; |
|
334
|
|
|
$columns_table[$index]['field_with'] = $join_alias.'.'.$join_column; |
|
335
|
|
|
$columns_table[$index]['field_raw'] = $join_column; |
|
336
|
|
|
|
|
337
|
|
|
@$join_table1 = $join_exp[2]; |
|
338
|
|
|
@$joinTable1PK = CB::pk($join_table1); |
|
339
|
|
|
@$join_column1 = $join_exp[3]; |
|
340
|
|
|
@$join_alias1 = $join_table1; |
|
341
|
|
|
|
|
342
|
|
|
if ($join_table1 && $join_column1) { |
|
343
|
|
|
|
|
344
|
|
|
if (in_array($join_table1, $join_table_temp)) { |
|
345
|
|
|
$join_alias_count += 1; |
|
346
|
|
|
$join_alias1 = $join_table1.$join_alias_count; |
|
347
|
|
|
} |
|
348
|
|
|
|
|
349
|
|
|
$join_table_temp[] = $join_table1; |
|
350
|
|
|
|
|
351
|
|
|
$result->leftjoin($join_table1.' as '.$join_alias1, $join_alias1.'.'.$joinTable1PK, '=', $join_alias.'.'.$join_column); |
|
352
|
|
|
$result->addselect($join_alias1.'.'.$join_column1.' as '.$join_column1.'_'.$join_alias1); |
|
353
|
|
|
$alias[] = $join_alias1; |
|
354
|
|
|
$columns_table[$index]['type_data'] = CRUDBooster::getFieldType($join_table1, $join_column1); |
|
355
|
|
|
$columns_table[$index]['field'] = $join_column1.'_'.$join_alias1; |
|
356
|
|
|
$columns_table[$index]['field_with'] = $join_alias1.'.'.$join_column1; |
|
357
|
|
|
$columns_table[$index]['field_raw'] = $join_column1; |
|
358
|
|
|
} |
|
359
|
|
|
} else { |
|
360
|
|
|
|
|
361
|
|
|
if(isset($field_array[1])) { |
|
362
|
|
|
$result->addselect($table.'.'.$field.' as '.$table.'_'.$field); |
|
363
|
|
|
$columns_table[$index]['type_data'] = CRUDBooster::getFieldType($table, $field); |
|
364
|
|
|
$columns_table[$index]['field'] = $table.'_'.$field; |
|
365
|
|
|
$columns_table[$index]['field_raw'] = $table.'.'.$field; |
|
366
|
|
|
}else{ |
|
367
|
|
|
$result->addselect($table.'.'.$field); |
|
368
|
|
|
$columns_table[$index]['type_data'] = CRUDBooster::getFieldType($table, $field); |
|
369
|
|
|
$columns_table[$index]['field'] = $field; |
|
370
|
|
|
$columns_table[$index]['field_raw'] = $field; |
|
371
|
|
|
} |
|
372
|
|
|
|
|
373
|
|
|
$columns_table[$index]['field_with'] = $table.'.'.$field; |
|
374
|
|
|
} |
|
375
|
|
|
} |
|
376
|
|
|
|
|
377
|
|
|
if (Request::get('q')) { |
|
378
|
|
|
$result->where(function ($w) use ($columns_table, $request) { |
|
|
|
|
|
|
379
|
|
|
foreach ($columns_table as $col) { |
|
380
|
|
|
if (! $col['field_with']) { |
|
381
|
|
|
continue; |
|
382
|
|
|
} |
|
383
|
|
|
if ($col['is_subquery']) { |
|
384
|
|
|
continue; |
|
385
|
|
|
} |
|
386
|
|
|
$w->orwhere($col['field_with'], "like", "%".Request::get("q")."%"); |
|
387
|
|
|
} |
|
388
|
|
|
}); |
|
389
|
|
|
} |
|
390
|
|
|
|
|
391
|
|
|
if (Request::get('where')) { |
|
392
|
|
|
foreach (Request::get('where') as $k => $v) { |
|
393
|
|
|
$result->where($table.'.'.$k, $v); |
|
394
|
|
|
} |
|
395
|
|
|
} |
|
396
|
|
|
|
|
397
|
|
|
$filter_is_orderby = false; |
|
398
|
|
|
if (Request::get('filter_column')) { |
|
399
|
|
|
|
|
400
|
|
|
$filter_column = Request::get('filter_column'); |
|
401
|
|
|
$result->where(function ($w) use ($filter_column, $fc) { |
|
|
|
|
|
|
402
|
|
|
foreach ($filter_column as $key => $fc) { |
|
403
|
|
|
|
|
404
|
|
|
$value = @$fc['value']; |
|
405
|
|
|
$type = @$fc['type']; |
|
406
|
|
|
|
|
407
|
|
|
if ($type == 'empty') { |
|
408
|
|
|
$w->whereNull($key)->orWhere($key, ''); |
|
409
|
|
|
continue; |
|
410
|
|
|
} |
|
411
|
|
|
|
|
412
|
|
|
if ($value == '' || $type == '') { |
|
413
|
|
|
continue; |
|
414
|
|
|
} |
|
415
|
|
|
|
|
416
|
|
|
if ($type == 'between') { |
|
417
|
|
|
continue; |
|
418
|
|
|
} |
|
419
|
|
|
|
|
420
|
|
|
switch ($type) { |
|
421
|
|
|
default: |
|
422
|
|
|
if ($key && $type && $value) { |
|
423
|
|
|
$w->where($key, $type, $value); |
|
424
|
|
|
} |
|
425
|
|
|
break; |
|
426
|
|
|
case 'like': |
|
427
|
|
|
case 'not like': |
|
428
|
|
|
$value = '%'.$value.'%'; |
|
429
|
|
|
if ($key && $type && $value) { |
|
430
|
|
|
$w->where($key, $type, $value); |
|
431
|
|
|
} |
|
432
|
|
|
break; |
|
433
|
|
|
case 'in': |
|
434
|
|
|
case 'not in': |
|
435
|
|
|
if ($value) { |
|
436
|
|
|
$value = explode(',', $value); |
|
437
|
|
|
if ($key && $value) { |
|
|
|
|
|
|
438
|
|
|
$w->whereIn($key, $value); |
|
439
|
|
|
} |
|
440
|
|
|
} |
|
441
|
|
|
break; |
|
442
|
|
|
} |
|
443
|
|
|
} |
|
444
|
|
|
}); |
|
445
|
|
|
|
|
446
|
|
|
foreach ($filter_column as $key => $fc) { |
|
447
|
|
|
$value = @$fc['value']; |
|
448
|
|
|
$type = @$fc['type']; |
|
449
|
|
|
$sorting = @$fc['sorting']; |
|
450
|
|
|
|
|
451
|
|
|
if ($sorting != '') { |
|
452
|
|
|
if ($key) { |
|
453
|
|
|
$result->orderby($key, $sorting); |
|
454
|
|
|
$filter_is_orderby = true; |
|
455
|
|
|
} |
|
456
|
|
|
} |
|
457
|
|
|
|
|
458
|
|
|
if ($type == 'between') { |
|
459
|
|
|
if ($key && $value) { |
|
460
|
|
|
$result->whereBetween($key, $value); |
|
461
|
|
|
} |
|
462
|
|
|
} else { |
|
463
|
|
|
continue; |
|
464
|
|
|
} |
|
465
|
|
|
} |
|
466
|
|
|
} |
|
467
|
|
|
|
|
468
|
|
|
if ($filter_is_orderby == true) { |
|
469
|
|
|
$data['result'] = $result->paginate($limit); |
|
470
|
|
|
} else { |
|
471
|
|
|
if ($this->orderby) { |
|
472
|
|
|
if (is_array($this->orderby)) { |
|
473
|
|
|
foreach ($this->orderby as $k => $v) { |
|
474
|
|
|
if (strpos($k, '.') !== false) { |
|
475
|
|
|
$orderby_table = explode(".", $k)[0]; |
|
476
|
|
|
$k = explode(".", $k)[1]; |
|
477
|
|
|
} else { |
|
478
|
|
|
$orderby_table = $this->table; |
|
479
|
|
|
} |
|
480
|
|
|
$result->orderby($orderby_table.'.'.$k, $v); |
|
481
|
|
|
} |
|
482
|
|
|
} else { |
|
483
|
|
|
$this->orderby = explode(";", $this->orderby); |
|
484
|
|
|
foreach ($this->orderby as $o) { |
|
485
|
|
|
$o = explode(",", $o); |
|
486
|
|
|
$k = $o[0]; |
|
487
|
|
|
$v = $o[1]; |
|
488
|
|
|
if (strpos($k, '.') !== false) { |
|
489
|
|
|
$orderby_table = explode(".", $k)[0]; |
|
490
|
|
|
} else { |
|
491
|
|
|
$orderby_table = $this->table; |
|
492
|
|
|
} |
|
493
|
|
|
$result->orderby($orderby_table.'.'.$k, $v); |
|
494
|
|
|
} |
|
495
|
|
|
} |
|
496
|
|
|
$data['result'] = $result->paginate($limit); |
|
497
|
|
|
} else { |
|
498
|
|
|
$data['result'] = $result->orderby($this->table.'.'.$this->primary_key, 'desc')->paginate($limit); |
|
499
|
|
|
} |
|
500
|
|
|
} |
|
501
|
|
|
|
|
502
|
|
|
$data['columns'] = $columns_table; |
|
503
|
|
|
|
|
504
|
|
|
if ($this->index_return) { |
|
505
|
|
|
return $data; |
|
506
|
|
|
} |
|
507
|
|
|
|
|
508
|
|
|
//LISTING INDEX HTML |
|
509
|
|
|
$addaction = $this->data['addaction']; |
|
510
|
|
|
|
|
511
|
|
|
if ($this->sub_module) { |
|
512
|
|
|
foreach ($this->sub_module as $s) { |
|
513
|
|
|
$table_parent = CRUDBooster::parseSqlTable($this->table)['table']; |
|
514
|
|
|
$addaction[] = [ |
|
515
|
|
|
'label' => $s['label'], |
|
516
|
|
|
'icon' => $s['button_icon'], |
|
517
|
|
|
'url' => CRUDBooster::adminPath($s['path']).'?return_url='.urlencode(Request::fullUrl()).'&parent_table='.$table_parent.'&parent_columns='.$s['parent_columns'].'&parent_columns_alias='.$s['parent_columns_alias'].'&parent_id=['.(! isset($s['custom_parent_id']) ? "id" : $s['custom_parent_id']).']&foreign_key='.$s['foreign_key'].'&label='.urlencode($s['label']), |
|
518
|
|
|
'color' => $s['button_color'], |
|
519
|
|
|
'showIf' => $s['showIf'], |
|
520
|
|
|
]; |
|
521
|
|
|
} |
|
522
|
|
|
} |
|
523
|
|
|
|
|
524
|
|
|
$mainpath = CRUDBooster::mainpath(); |
|
|
|
|
|
|
525
|
|
|
$orig_mainpath = $this->data['mainpath']; |
|
|
|
|
|
|
526
|
|
|
$title_field = $this->title_field; |
|
|
|
|
|
|
527
|
|
|
$html_contents = []; |
|
528
|
|
|
$page = (Request::get('page')) ? Request::get('page') : 1; |
|
529
|
|
|
$number = ($page - 1) * $limit + 1; |
|
530
|
|
|
foreach ($data['result'] as $row) { |
|
531
|
|
|
$html_content = []; |
|
532
|
|
|
|
|
533
|
|
|
if ($this->button_bulk_action) { |
|
534
|
|
|
|
|
535
|
|
|
$html_content[] = "<input type='checkbox' class='checkbox' name='checkbox[]' value='".$row->{$tablePK}."'/>"; |
|
536
|
|
|
} |
|
537
|
|
|
|
|
538
|
|
|
if ($this->show_numbering) { |
|
539
|
|
|
$html_content[] = $number.'. '; |
|
540
|
|
|
$number++; |
|
541
|
|
|
} |
|
542
|
|
|
|
|
543
|
|
|
foreach ($columns_table as $col) { |
|
544
|
|
|
if ($col['visible'] === false) { |
|
545
|
|
|
continue; |
|
546
|
|
|
} |
|
547
|
|
|
|
|
548
|
|
|
$value = @$row->{$col['field']}; |
|
549
|
|
|
$title = @$row->{$this->title_field}; |
|
550
|
|
|
$label = $col['label']; |
|
551
|
|
|
|
|
552
|
|
|
if (isset($col['image'])) { |
|
553
|
|
|
if ($value == '') { |
|
554
|
|
|
$value = "<a data-lightbox='roadtrip' rel='group_{{$table}}' title='$label: $title' href='".asset('vendor/crudbooster/avatar.jpg')."'><img width='40px' height='40px' src='".asset('vendor/crudbooster/avatar.jpg')."'/></a>"; |
|
555
|
|
|
} else { |
|
556
|
|
|
$pic = (strpos($value, 'http://') !== false) ? $value : asset($value); |
|
557
|
|
|
$value = "<a data-lightbox='roadtrip' rel='group_{{$table}}' title='$label: $title' href='".$pic."'><img width='40px' height='40px' src='".$pic."'/></a>"; |
|
558
|
|
|
} |
|
559
|
|
|
} |
|
560
|
|
|
|
|
561
|
|
|
if (@$col['download']) { |
|
562
|
|
|
$url = (strpos($value, 'http://') !== false) ? $value : asset($value).'?download=1'; |
|
563
|
|
|
if ($value) { |
|
564
|
|
|
$value = "<a class='btn btn-xs btn-primary' href='$url' target='_blank' title='Download File'><i class='fa fa-download'></i> Download</a>"; |
|
565
|
|
|
} else { |
|
566
|
|
|
$value = " - "; |
|
567
|
|
|
} |
|
568
|
|
|
} |
|
569
|
|
|
|
|
570
|
|
|
if ($col['str_limit']) { |
|
571
|
|
|
$value = trim(strip_tags($value)); |
|
572
|
|
|
$value = str_limit($value, $col['str_limit']); |
|
|
|
|
|
|
573
|
|
|
} |
|
574
|
|
|
|
|
575
|
|
|
if ($col['nl2br']) { |
|
576
|
|
|
$value = nl2br($value); |
|
577
|
|
|
} |
|
578
|
|
|
|
|
579
|
|
|
if ($col['callback_php']) { |
|
580
|
|
|
foreach ($row as $k => $v) { |
|
581
|
|
|
$col['callback_php'] = str_replace("[".$k."]", $v, $col['callback_php']); |
|
582
|
|
|
} |
|
583
|
|
|
@eval("\$value = ".$col['callback_php'].";"); |
|
|
|
|
|
|
584
|
|
|
} |
|
585
|
|
|
|
|
586
|
|
|
//New method for callback |
|
587
|
|
|
if (isset($col['callback'])) { |
|
588
|
|
|
$value = call_user_func($col['callback'], $row); |
|
589
|
|
|
} |
|
590
|
|
|
|
|
591
|
|
|
$datavalue = @unserialize($value); |
|
592
|
|
|
if ($datavalue !== false) { |
|
593
|
|
|
if ($datavalue) { |
|
594
|
|
|
$prevalue = []; |
|
595
|
|
|
foreach ($datavalue as $d) { |
|
596
|
|
|
if ($d['label']) { |
|
597
|
|
|
$prevalue[] = $d['label']; |
|
598
|
|
|
} |
|
599
|
|
|
} |
|
600
|
|
|
if ($prevalue && count($prevalue)) { |
|
601
|
|
|
$value = implode(", ", $prevalue); |
|
602
|
|
|
} |
|
603
|
|
|
} |
|
604
|
|
|
} |
|
605
|
|
|
|
|
606
|
|
|
$html_content[] = $value; |
|
607
|
|
|
} //end foreach columns_table |
|
608
|
|
|
|
|
609
|
|
|
if ($this->button_table_action): |
|
610
|
|
|
|
|
611
|
|
|
$button_action_style = $this->button_action_style; |
|
612
|
|
|
$html_content[] = "<div class='button_action' style='text-align:right'>".view('crudbooster::components.action', compact('addaction', 'row', 'button_action_style', 'parent_field'))->render()."</div>"; |
|
613
|
|
|
|
|
614
|
|
|
endif;//button_table_action |
|
615
|
|
|
|
|
616
|
|
|
foreach ($html_content as $i => $v) { |
|
617
|
|
|
$this->hook_row_index($i, $v); |
|
618
|
|
|
$html_content[$i] = $v; |
|
619
|
|
|
} |
|
620
|
|
|
|
|
621
|
|
|
$html_contents[] = $html_content; |
|
622
|
|
|
} //end foreach data[result] |
|
623
|
|
|
|
|
624
|
|
|
$html_contents = ['html' => $html_contents, 'data' => $data['result']]; |
|
625
|
|
|
|
|
626
|
|
|
$data['html_contents'] = $html_contents; |
|
627
|
|
|
|
|
628
|
|
|
return view("crudbooster::default.index", $data); |
|
629
|
|
|
} |
|
630
|
|
|
|
|
631
|
|
|
public function getExportData() |
|
632
|
|
|
{ |
|
633
|
|
|
|
|
634
|
|
|
return redirect(CRUDBooster::mainpath()); |
|
635
|
|
|
} |
|
636
|
|
|
|
|
637
|
|
|
public function postExportData() |
|
638
|
|
|
{ |
|
639
|
|
|
ini_set('memory_limit', '1024M'); |
|
640
|
|
|
set_time_limit(180); |
|
641
|
|
|
|
|
642
|
|
|
$this->limit = Request::input('limit'); |
|
643
|
|
|
$this->index_return = true; |
|
644
|
|
|
$filetype = Request::input('fileformat'); |
|
645
|
|
|
$filename = Request::input('filename'); |
|
646
|
|
|
$papersize = Request::input('page_size'); |
|
647
|
|
|
$paperorientation = Request::input('page_orientation'); |
|
648
|
|
|
$response = $this->getIndex(); |
|
649
|
|
|
|
|
650
|
|
|
if (Request::input('default_paper_size')) { |
|
651
|
|
|
DB::table('cms_settings')->where('name', 'default_paper_size')->update(['content' => $papersize]); |
|
652
|
|
|
} |
|
653
|
|
|
|
|
654
|
|
|
switch ($filetype) { |
|
655
|
|
|
case "pdf": |
|
656
|
|
|
$view = view('crudbooster::export', $response)->render(); |
|
657
|
|
|
$pdf = App::make('dompdf.wrapper'); |
|
658
|
|
|
$pdf->loadHTML($view); |
|
659
|
|
|
$pdf->setPaper($papersize, $paperorientation); |
|
660
|
|
|
|
|
661
|
|
|
return $pdf->stream($filename.'.pdf'); |
|
662
|
|
|
break; |
|
|
|
|
|
|
663
|
|
|
case 'xls': |
|
664
|
|
|
Excel::create($filename, function ($excel) use ($response) { |
|
665
|
|
|
$excel->setTitle($filename)->setCreator("crudbooster.com")->setCompany(CRUDBooster::getSetting('appname')); |
|
|
|
|
|
|
666
|
|
|
$excel->sheet($filename, function ($sheet) use ($response) { |
|
667
|
|
|
$sheet->setOrientation($paperorientation); |
|
|
|
|
|
|
668
|
|
|
$sheet->loadview('crudbooster::export', $response); |
|
669
|
|
|
}); |
|
670
|
|
|
})->export('xls'); |
|
671
|
|
|
break; |
|
672
|
|
|
case 'csv': |
|
673
|
|
|
Excel::create($filename, function ($excel) use ($response) { |
|
674
|
|
|
$excel->setTitle($filename)->setCreator("crudbooster.com")->setCompany(CRUDBooster::getSetting('appname')); |
|
|
|
|
|
|
675
|
|
|
$excel->sheet($filename, function ($sheet) use ($response) { |
|
676
|
|
|
$sheet->setOrientation($paperorientation); |
|
|
|
|
|
|
677
|
|
|
$sheet->loadview('crudbooster::export', $response); |
|
678
|
|
|
}); |
|
679
|
|
|
})->export('csv'); |
|
680
|
|
|
break; |
|
681
|
|
|
} |
|
682
|
|
|
} |
|
683
|
|
|
|
|
684
|
|
|
public function postDataQuery() |
|
685
|
|
|
{ |
|
686
|
|
|
$query = Request::get('query'); |
|
687
|
|
|
$query = DB::select(DB::raw($query)); |
|
688
|
|
|
|
|
689
|
|
|
return response()->json($query); |
|
690
|
|
|
} |
|
691
|
|
|
|
|
692
|
|
|
public function getDataTable() |
|
693
|
|
|
{ |
|
694
|
|
|
$table = Request::get('table'); |
|
695
|
|
|
$label = Request::get('label'); |
|
696
|
|
|
$datatableWhere = urldecode(Request::get('datatable_where')); |
|
697
|
|
|
$foreign_key_name = Request::get('fk_name'); |
|
698
|
|
|
$foreign_key_value = Request::get('fk_value'); |
|
699
|
|
|
if ($table && $label && $foreign_key_name && $foreign_key_value) { |
|
700
|
|
|
$query = DB::table($table); |
|
701
|
|
|
if ($datatableWhere) { |
|
702
|
|
|
$query->whereRaw($datatableWhere); |
|
703
|
|
|
} |
|
704
|
|
|
$query->select('id as select_value', $label.' as select_label'); |
|
705
|
|
|
$query->where($foreign_key_name, $foreign_key_value); |
|
706
|
|
|
$query->orderby($label, 'asc'); |
|
707
|
|
|
|
|
708
|
|
|
return response()->json($query->get()); |
|
709
|
|
|
} else { |
|
710
|
|
|
return response()->json([]); |
|
711
|
|
|
} |
|
712
|
|
|
} |
|
713
|
|
|
|
|
714
|
|
|
public function getModalData() |
|
715
|
|
|
{ |
|
716
|
|
|
$table = Request::get('table'); |
|
717
|
|
|
$where = Request::get('where'); |
|
718
|
|
|
$where = urldecode($where); |
|
719
|
|
|
$columns = Request::get('columns'); |
|
720
|
|
|
$columns = explode(",", $columns); |
|
721
|
|
|
|
|
722
|
|
|
$table = CRUDBooster::parseSqlTable($table)['table']; |
|
723
|
|
|
$tablePK = CB::pk($table); |
|
724
|
|
|
$result = DB::table($table); |
|
725
|
|
|
|
|
726
|
|
|
if (Request::get('q')) { |
|
727
|
|
|
$result->where(function ($where) use ($columns) { |
|
728
|
|
|
foreach ($columns as $c => $col) { |
|
729
|
|
|
if ($c == 0) { |
|
730
|
|
|
$where->where($col, 'like', '%'.Request::get('q').'%'); |
|
731
|
|
|
} else { |
|
732
|
|
|
$where->orWhere($col, 'like', '%'.Request::get('q').'%'); |
|
733
|
|
|
} |
|
734
|
|
|
} |
|
735
|
|
|
}); |
|
736
|
|
|
} |
|
737
|
|
|
|
|
738
|
|
|
if ($where) { |
|
739
|
|
|
$result->whereraw($where); |
|
740
|
|
|
} |
|
741
|
|
|
|
|
742
|
|
|
$result->orderby($tablePK, 'desc'); |
|
743
|
|
|
|
|
744
|
|
|
$data['result'] = $result->paginate(6); |
|
|
|
|
|
|
745
|
|
|
$data['columns'] = $columns; |
|
746
|
|
|
|
|
747
|
|
|
return view('crudbooster::default.type_components.datamodal.browser', $data); |
|
748
|
|
|
} |
|
749
|
|
|
|
|
750
|
|
|
public function getUpdateSingle() |
|
751
|
|
|
{ |
|
752
|
|
|
$table = Request::get('table'); |
|
753
|
|
|
$column = Request::get('column'); |
|
754
|
|
|
$value = Request::get('value'); |
|
755
|
|
|
$id = Request::get('id'); |
|
756
|
|
|
$tablePK = CB::pk($table); |
|
757
|
|
|
DB::table($table)->where($tablePK, $id)->update([$column => $value]); |
|
758
|
|
|
|
|
759
|
|
|
return redirect()->back()->with(['message_type' => 'success', 'message' => trans('crudbooster.alert_delete_data_success')]); |
|
760
|
|
|
} |
|
761
|
|
|
|
|
762
|
|
|
public function getFindData() |
|
763
|
|
|
{ |
|
764
|
|
|
$q = Request::get('q'); |
|
765
|
|
|
$id = Request::get('id'); |
|
766
|
|
|
$limit = Request::get('limit') ?: 10; |
|
767
|
|
|
$format = Request::get('format'); |
|
768
|
|
|
|
|
769
|
|
|
$table1 = (Request::get('table1')) ?: $this->table; |
|
770
|
|
|
$table1PK = CB::pk($table1); |
|
771
|
|
|
$column1 = (Request::get('column1')) ?: $this->title_field; |
|
772
|
|
|
|
|
773
|
|
|
@$table2 = Request::get('table2'); |
|
774
|
|
|
@$column2 = Request::get('column2'); |
|
775
|
|
|
|
|
776
|
|
|
@$table3 = Request::get('table3'); |
|
777
|
|
|
@$column3 = Request::get('column3'); |
|
778
|
|
|
|
|
779
|
|
|
$where = Request::get('where'); |
|
780
|
|
|
|
|
781
|
|
|
$fk = Request::get('fk'); |
|
782
|
|
|
$fk_value = Request::get('fk_value'); |
|
783
|
|
|
|
|
784
|
|
|
if ($q || $id || $table1) { |
|
785
|
|
|
$rows = DB::table($table1); |
|
786
|
|
|
$rows->select($table1.'.*'); |
|
787
|
|
|
$rows->take($limit); |
|
788
|
|
|
|
|
789
|
|
|
if (CRUDBooster::isColumnExists($table1, 'deleted_at')) { |
|
790
|
|
|
$rows->where($table1.'.deleted_at', null); |
|
791
|
|
|
} |
|
792
|
|
|
|
|
793
|
|
|
if ($fk && $fk_value) { |
|
794
|
|
|
$rows->where($table1.'.'.$fk, $fk_value); |
|
795
|
|
|
} |
|
796
|
|
|
|
|
797
|
|
|
if ($table1 && $column1) { |
|
798
|
|
|
|
|
799
|
|
|
$orderby_table = $table1; |
|
800
|
|
|
$orderby_column = $column1; |
|
801
|
|
|
} |
|
802
|
|
|
|
|
803
|
|
|
if ($table2 && $column2) { |
|
804
|
|
|
$table2PK = CB::pk($table2); |
|
805
|
|
|
$rows->join($table2, $table2.'.'.$table2PK, '=', $table1.'.'.$column1); |
|
806
|
|
|
$columns = CRUDBooster::getTableColumns($table2); |
|
807
|
|
|
foreach ($columns as $col) { |
|
808
|
|
|
$rows->addselect($table2.".".$col." as ".$table2."_".$col); |
|
809
|
|
|
} |
|
810
|
|
|
$orderby_table = $table2; |
|
811
|
|
|
$orderby_column = $column2; |
|
812
|
|
|
} |
|
813
|
|
|
|
|
814
|
|
|
if ($table3 && $column3) { |
|
815
|
|
|
$table3PK = CB::pk($table3); |
|
816
|
|
|
$rows->join($table3, $table3.'.'.$table3PK, '=', $table2.'.'.$column2); |
|
817
|
|
|
$columns = CRUDBooster::getTableColumns($table3); |
|
818
|
|
|
foreach ($columns as $col) { |
|
819
|
|
|
$rows->addselect($table3.".".$col." as ".$table3."_".$col); |
|
820
|
|
|
} |
|
821
|
|
|
$orderby_table = $table3; |
|
822
|
|
|
$orderby_column = $column3; |
|
823
|
|
|
} |
|
824
|
|
|
|
|
825
|
|
|
if ($id) { |
|
826
|
|
|
$rows->where($table1.".".$table1PK, $id); |
|
827
|
|
|
} |
|
828
|
|
|
|
|
829
|
|
|
if ($where) { |
|
830
|
|
|
$rows->whereraw($where); |
|
831
|
|
|
} |
|
832
|
|
|
|
|
833
|
|
|
if ($format) { |
|
834
|
|
|
$format = str_replace(''', "'", $format); |
|
835
|
|
|
$rows->addselect(DB::raw("CONCAT($format) as text")); |
|
836
|
|
|
if ($q) { |
|
837
|
|
|
$rows->whereraw("CONCAT($format) like '%".$q."%'"); |
|
838
|
|
|
} |
|
839
|
|
|
} else { |
|
840
|
|
|
$rows->addselect($orderby_table.'.'.$orderby_column.' as text'); |
|
|
|
|
|
|
841
|
|
|
if ($q) { |
|
842
|
|
|
$rows->where($orderby_table.'.'.$orderby_column, 'like', '%'.$q.'%'); |
|
843
|
|
|
} |
|
844
|
|
|
$rows->orderBy($orderby_table.'.'.$orderby_column, 'asc'); |
|
845
|
|
|
} |
|
846
|
|
|
|
|
847
|
|
|
$result = []; |
|
848
|
|
|
$result['items'] = $rows->get(); |
|
849
|
|
|
} else { |
|
850
|
|
|
$result = []; |
|
851
|
|
|
$result['items'] = []; |
|
852
|
|
|
} |
|
853
|
|
|
|
|
854
|
|
|
return response()->json($result); |
|
855
|
|
|
} |
|
856
|
|
|
|
|
857
|
|
|
public function validation($id = null) |
|
858
|
|
|
{ |
|
859
|
|
|
|
|
860
|
|
|
$request_all = Request::all(); |
|
861
|
|
|
$array_input = []; |
|
862
|
|
|
foreach ($this->data_inputan as $di) { |
|
863
|
|
|
$ai = []; |
|
864
|
|
|
$name = $di['name']; |
|
865
|
|
|
|
|
866
|
|
|
if (! isset($request_all[$name])) { |
|
867
|
|
|
continue; |
|
868
|
|
|
} |
|
869
|
|
|
|
|
870
|
|
|
if ($di['type'] != 'upload') { |
|
871
|
|
|
if (@$di['required']) { |
|
872
|
|
|
$ai[] = 'required'; |
|
873
|
|
|
} |
|
874
|
|
|
} |
|
875
|
|
|
|
|
876
|
|
|
if ($di['type'] == 'upload') { |
|
877
|
|
|
if ($id) { |
|
878
|
|
|
$row = DB::table($this->table)->where($this->primary_key, $id)->first(); |
|
879
|
|
|
if ($row->{$di['name']} == '') { |
|
880
|
|
|
$ai[] = 'required'; |
|
881
|
|
|
} |
|
882
|
|
|
} |
|
883
|
|
|
} |
|
884
|
|
|
|
|
885
|
|
|
if (@$di['min']) { |
|
886
|
|
|
$ai[] = 'min:'.$di['min']; |
|
887
|
|
|
} |
|
888
|
|
|
if (@$di['max']) { |
|
889
|
|
|
$ai[] = 'max:'.$di['max']; |
|
890
|
|
|
} |
|
891
|
|
|
if (@$di['image']) { |
|
892
|
|
|
$ai[] = 'image'; |
|
893
|
|
|
} |
|
894
|
|
|
if (@$di['mimes']) { |
|
895
|
|
|
$ai[] = 'mimes:'.$di['mimes']; |
|
896
|
|
|
} |
|
897
|
|
|
$name = $di['name']; |
|
898
|
|
|
if (! $name) { |
|
899
|
|
|
continue; |
|
900
|
|
|
} |
|
901
|
|
|
|
|
902
|
|
|
if ($di['type'] == 'money') { |
|
903
|
|
|
$request_all[$name] = preg_replace('/[^\d-]+/', '', $request_all[$name]); |
|
904
|
|
|
} |
|
905
|
|
|
|
|
906
|
|
|
if ($di['type'] == 'child') { |
|
907
|
|
|
$slug_name = str_slug($di['label'], ''); |
|
|
|
|
|
|
908
|
|
|
foreach ($di['columns'] as $child_col) { |
|
909
|
|
|
if (isset($child_col['validation'])) { |
|
910
|
|
|
//https://laracasts.com/discuss/channels/general-discussion/array-validation-is-not-working/ |
|
911
|
|
|
if (strpos($child_col['validation'], 'required') !== false) { |
|
912
|
|
|
$array_input[$slug_name.'-'.$child_col['name']] = 'required'; |
|
913
|
|
|
|
|
914
|
|
|
str_replace('required', '', $child_col['validation']); |
|
915
|
|
|
} |
|
916
|
|
|
|
|
917
|
|
|
$array_input[$slug_name.'-'.$child_col['name'].'.*'] = $child_col['validation']; |
|
918
|
|
|
} |
|
919
|
|
|
} |
|
920
|
|
|
} |
|
921
|
|
|
|
|
922
|
|
|
if (@$di['validation']) { |
|
923
|
|
|
|
|
924
|
|
|
$exp = explode('|', $di['validation']); |
|
925
|
|
|
if ($exp && count($exp)) { |
|
|
|
|
|
|
926
|
|
|
foreach ($exp as &$validationItem) { |
|
927
|
|
|
if (substr($validationItem, 0, 6) == 'unique') { |
|
928
|
|
|
$parseUnique = explode(',', str_replace('unique:', '', $validationItem)); |
|
929
|
|
|
$uniqueTable = ($parseUnique[0]) ?: $this->table; |
|
930
|
|
|
$uniqueColumn = ($parseUnique[1]) ?: $name; |
|
931
|
|
|
$uniqueIgnoreId = ($parseUnique[2]) ?: (($id) ?: ''); |
|
932
|
|
|
|
|
933
|
|
|
//Make sure table name |
|
934
|
|
|
$uniqueTable = CB::parseSqlTable($uniqueTable)['table']; |
|
935
|
|
|
|
|
936
|
|
|
//Rebuild unique rule |
|
937
|
|
|
$uniqueRebuild = []; |
|
938
|
|
|
$uniqueRebuild[] = $uniqueTable; |
|
939
|
|
|
$uniqueRebuild[] = $uniqueColumn; |
|
940
|
|
|
if ($uniqueIgnoreId) { |
|
941
|
|
|
$uniqueRebuild[] = $uniqueIgnoreId; |
|
942
|
|
|
} else { |
|
943
|
|
|
$uniqueRebuild[] = 'NULL'; |
|
944
|
|
|
} |
|
945
|
|
|
|
|
946
|
|
|
//Check whether deleted_at exists or not |
|
947
|
|
|
if (CB::isColumnExists($uniqueTable, 'deleted_at')) { |
|
948
|
|
|
$uniqueRebuild[] = CB::findPrimaryKey($uniqueTable); |
|
949
|
|
|
$uniqueRebuild[] = 'deleted_at'; |
|
950
|
|
|
$uniqueRebuild[] = 'NULL'; |
|
951
|
|
|
} |
|
952
|
|
|
$uniqueRebuild = array_filter($uniqueRebuild); |
|
953
|
|
|
$validationItem = 'unique:'.implode(',', $uniqueRebuild); |
|
954
|
|
|
} |
|
955
|
|
|
} |
|
956
|
|
|
} else { |
|
957
|
|
|
$exp = []; |
|
958
|
|
|
} |
|
959
|
|
|
|
|
960
|
|
|
$validation = implode('|', $exp); |
|
961
|
|
|
|
|
962
|
|
|
$array_input[$name] = $validation; |
|
963
|
|
|
} else { |
|
964
|
|
|
$array_input[$name] = implode('|', $ai); |
|
965
|
|
|
} |
|
966
|
|
|
} |
|
967
|
|
|
|
|
968
|
|
|
$validator = Validator::make($request_all, $array_input); |
|
969
|
|
|
|
|
970
|
|
|
if ($validator->fails()) { |
|
971
|
|
|
$message = $validator->messages(); |
|
972
|
|
|
$message_all = $message->all(); |
|
973
|
|
|
|
|
974
|
|
|
if (Request::ajax()) { |
|
975
|
|
|
$res = response()->json([ |
|
|
|
|
|
|
976
|
|
|
'message' => trans('crudbooster.alert_validation_error', ['error' => implode(', ', $message_all)]), |
|
977
|
|
|
'message_type' => 'warning', |
|
978
|
|
|
])->send(); |
|
979
|
|
|
exit; |
|
|
|
|
|
|
980
|
|
|
} else { |
|
981
|
|
|
$res = redirect()->back()->with("errors", $message)->with([ |
|
982
|
|
|
'message' => trans('crudbooster.alert_validation_error', ['error' => implode(', ', $message_all)]), |
|
983
|
|
|
'message_type' => 'warning', |
|
984
|
|
|
])->withInput(); |
|
985
|
|
|
\Session::driver()->save(); |
|
986
|
|
|
$res->send(); |
|
987
|
|
|
exit; |
|
|
|
|
|
|
988
|
|
|
} |
|
989
|
|
|
} |
|
990
|
|
|
} |
|
991
|
|
|
|
|
992
|
|
|
public function input_assignment($id = null) |
|
993
|
|
|
{ |
|
994
|
|
|
|
|
995
|
|
|
$hide_form = (Request::get('hide_form')) ? unserialize(Request::get('hide_form')) : []; |
|
996
|
|
|
|
|
997
|
|
|
foreach ($this->data_inputan as $ro) { |
|
998
|
|
|
$name = $ro['name']; |
|
999
|
|
|
|
|
1000
|
|
|
if (! $name) { |
|
1001
|
|
|
continue; |
|
1002
|
|
|
} |
|
1003
|
|
|
|
|
1004
|
|
|
if ($ro['exception']) { |
|
1005
|
|
|
continue; |
|
1006
|
|
|
} |
|
1007
|
|
|
|
|
1008
|
|
|
if ($name == 'hide_form') { |
|
1009
|
|
|
continue; |
|
1010
|
|
|
} |
|
1011
|
|
|
|
|
1012
|
|
|
if ($hide_form && count($hide_form)) { |
|
1013
|
|
|
if (in_array($name, $hide_form)) { |
|
1014
|
|
|
continue; |
|
1015
|
|
|
} |
|
1016
|
|
|
} |
|
1017
|
|
|
|
|
1018
|
|
|
if ($ro['type'] == 'checkbox' && $ro['relationship_table']) { |
|
1019
|
|
|
continue; |
|
1020
|
|
|
} |
|
1021
|
|
|
|
|
1022
|
|
|
if ($ro['type'] == 'select2' && $ro['relationship_table']) { |
|
1023
|
|
|
continue; |
|
1024
|
|
|
} |
|
1025
|
|
|
|
|
1026
|
|
|
$inputdata = Request::get($name); |
|
1027
|
|
|
|
|
1028
|
|
|
if ($ro['type'] == 'money') { |
|
1029
|
|
|
$inputdata = preg_replace('/[^\d-]+/', '', $inputdata); |
|
1030
|
|
|
} |
|
1031
|
|
|
|
|
1032
|
|
|
if ($ro['type'] == 'child') { |
|
1033
|
|
|
continue; |
|
1034
|
|
|
} |
|
1035
|
|
|
|
|
1036
|
|
|
if ($name) { |
|
1037
|
|
|
if ($inputdata != '') { |
|
1038
|
|
|
$this->arr[$name] = $inputdata; |
|
1039
|
|
|
} else { |
|
1040
|
|
|
if (CB::isColumnNULL($this->table, $name) && $ro['type'] != 'upload') { |
|
1041
|
|
|
continue; |
|
1042
|
|
|
} else { |
|
1043
|
|
|
$this->arr[$name] = ""; |
|
1044
|
|
|
} |
|
1045
|
|
|
} |
|
1046
|
|
|
} |
|
1047
|
|
|
|
|
1048
|
|
|
$password_candidate = explode(',', config('crudbooster.PASSWORD_FIELDS_CANDIDATE')); |
|
1049
|
|
|
if (in_array($name, $password_candidate)) { |
|
1050
|
|
|
if (! empty($this->arr[$name])) { |
|
1051
|
|
|
$this->arr[$name] = Hash::make($this->arr[$name]); |
|
1052
|
|
|
} else { |
|
1053
|
|
|
unset($this->arr[$name]); |
|
1054
|
|
|
} |
|
1055
|
|
|
} |
|
1056
|
|
|
|
|
1057
|
|
|
if ($ro['type'] == 'checkbox') { |
|
1058
|
|
|
|
|
1059
|
|
|
if (is_array($inputdata)) { |
|
1060
|
|
|
if ($ro['datatable'] != '') { |
|
1061
|
|
|
$table_checkbox = explode(',', $ro['datatable'])[0]; |
|
1062
|
|
|
$field_checkbox = explode(',', $ro['datatable'])[1]; |
|
1063
|
|
|
$table_checkbox_pk = CB::pk($table_checkbox); |
|
1064
|
|
|
$data_checkbox = DB::table($table_checkbox)->whereIn($table_checkbox_pk, $inputdata)->pluck($field_checkbox)->toArray(); |
|
1065
|
|
|
$this->arr[$name] = implode(";", $data_checkbox); |
|
1066
|
|
|
} else { |
|
1067
|
|
|
$this->arr[$name] = implode(";", $inputdata); |
|
1068
|
|
|
} |
|
1069
|
|
|
} |
|
1070
|
|
|
} |
|
1071
|
|
|
|
|
1072
|
|
|
//multitext colomn |
|
1073
|
|
|
if ($ro['type'] == 'multitext') { |
|
1074
|
|
|
$name = $ro['name']; |
|
1075
|
|
|
$multitext = ""; |
|
1076
|
|
|
$maxI = ($this->arr[$name])?count($this->arr[$name]):0; |
|
1077
|
|
|
for ($i = 0; $i <= $maxI - 1; $i++) { |
|
1078
|
|
|
$multitext .= $this->arr[$name][$i]."|"; |
|
1079
|
|
|
} |
|
1080
|
|
|
$multitext = substr($multitext, 0, strlen($multitext) - 1); |
|
1081
|
|
|
$this->arr[$name] = $multitext; |
|
1082
|
|
|
} |
|
1083
|
|
|
|
|
1084
|
|
|
if ($ro['type'] == 'googlemaps') { |
|
1085
|
|
|
if ($ro['latitude'] && $ro['longitude']) { |
|
1086
|
|
|
$latitude_name = $ro['latitude']; |
|
1087
|
|
|
$longitude_name = $ro['longitude']; |
|
1088
|
|
|
$this->arr[$latitude_name] = Request::get('input-latitude-'.$name); |
|
1089
|
|
|
$this->arr[$longitude_name] = Request::get('input-longitude-'.$name); |
|
1090
|
|
|
} |
|
1091
|
|
|
} |
|
1092
|
|
|
|
|
1093
|
|
|
if ($ro['type'] == 'select' || $ro['type'] == 'select2') { |
|
1094
|
|
|
if ($ro['datatable']) { |
|
1095
|
|
|
if ($inputdata == '') { |
|
1096
|
|
|
$this->arr[$name] = 0; |
|
1097
|
|
|
} |
|
1098
|
|
|
} |
|
1099
|
|
|
} |
|
1100
|
|
|
|
|
1101
|
|
|
if (@$ro['type'] == 'upload') { |
|
1102
|
|
|
|
|
1103
|
|
|
$this->arr[$name] = CRUDBooster::uploadFile($name, $ro['encrypt'] || $ro['upload_encrypt'], $ro['resize_width'], $ro['resize_height'], CB::myId()); |
|
1104
|
|
|
|
|
1105
|
|
|
if (! $this->arr[$name]) { |
|
1106
|
|
|
$this->arr[$name] = Request::get('_'.$name); |
|
1107
|
|
|
} |
|
1108
|
|
|
} |
|
1109
|
|
|
|
|
1110
|
|
|
if (@$ro['type'] == 'filemanager') { |
|
1111
|
|
|
$filename = str_replace('/'.config('lfm.prefix').'/'.config('lfm.files_folder_name').'/', '', $this->arr[$name]); |
|
1112
|
|
|
$url = 'uploads/'.$filename; |
|
1113
|
|
|
$this->arr[$name] = $url; |
|
1114
|
|
|
} |
|
1115
|
|
|
} |
|
1116
|
|
|
} |
|
1117
|
|
|
|
|
1118
|
|
|
public function getAdd() |
|
1119
|
|
|
{ |
|
1120
|
|
|
$this->cbLoader(); |
|
1121
|
|
|
if (! CRUDBooster::isCreate() && $this->global_privilege == false || $this->button_add == false) { |
|
|
|
|
|
|
1122
|
|
|
CRUDBooster::insertLog(trans('crudbooster.log_try_add', ['module' => CRUDBooster::getCurrentModule()->name])); |
|
1123
|
|
|
CRUDBooster::redirect(CRUDBooster::adminPath(), trans("crudbooster.denied_access")); |
|
1124
|
|
|
} |
|
1125
|
|
|
|
|
1126
|
|
|
$page_title = trans("crudbooster.add_data_page_title", ['module' => CRUDBooster::getCurrentModule()->name]); |
|
1127
|
|
|
$page_menu = Route::getCurrentRoute()->getActionName(); |
|
1128
|
|
|
$command = 'add'; |
|
1129
|
|
|
|
|
1130
|
|
|
return view('crudbooster::default.form', compact('page_title', 'page_menu', 'command')); |
|
1131
|
|
|
} |
|
1132
|
|
|
|
|
1133
|
|
|
public function postAddSave() |
|
1134
|
|
|
{ |
|
1135
|
|
|
$this->cbLoader(); |
|
1136
|
|
|
if (! CRUDBooster::isCreate() && $this->global_privilege == false) { |
|
1137
|
|
|
CRUDBooster::insertLog(trans('crudbooster.log_try_add_save', [ |
|
1138
|
|
|
'name' => Request::input($this->title_field), |
|
1139
|
|
|
'module' => CRUDBooster::getCurrentModule()->name, |
|
1140
|
|
|
])); |
|
1141
|
|
|
CRUDBooster::redirect(CRUDBooster::adminPath(), trans("crudbooster.denied_access")); |
|
1142
|
|
|
} |
|
1143
|
|
|
|
|
1144
|
|
|
$this->validation(); |
|
1145
|
|
|
$this->input_assignment(); |
|
1146
|
|
|
|
|
1147
|
|
|
if (Schema::hasColumn($this->table, 'created_at')) { |
|
1148
|
|
|
$this->arr['created_at'] = date('Y-m-d H:i:s'); |
|
1149
|
|
|
} |
|
1150
|
|
|
|
|
1151
|
|
|
$this->hook_before_add($this->arr); |
|
1152
|
|
|
|
|
1153
|
|
|
// $this->arr[$this->primary_key] = $id = CRUDBooster::newId($this->table); //error on sql server |
|
1154
|
|
|
$lastInsertId = $id = DB::table($this->table)->insertGetId($this->arr); |
|
1155
|
|
|
|
|
1156
|
|
|
//fix bug if primary key is uuid |
|
1157
|
|
|
if($this->arr[$this->primary_key]!=$id) |
|
1158
|
|
|
$id = $this->arr[$this->primary_key]; |
|
1159
|
|
|
|
|
1160
|
|
|
//Looping Data Input Again After Insert |
|
1161
|
|
|
foreach ($this->data_inputan as $ro) { |
|
1162
|
|
|
$name = $ro['name']; |
|
1163
|
|
|
if (! $name) { |
|
1164
|
|
|
continue; |
|
1165
|
|
|
} |
|
1166
|
|
|
|
|
1167
|
|
|
$inputdata = Request::get($name); |
|
1168
|
|
|
|
|
1169
|
|
|
//Insert Data Checkbox if Type Datatable |
|
1170
|
|
|
if ($ro['type'] == 'checkbox') { |
|
1171
|
|
|
if ($ro['relationship_table']) { |
|
1172
|
|
|
$datatable = explode(",", $ro['datatable'])[0]; |
|
1173
|
|
|
$foreignKey2 = CRUDBooster::getForeignKey($datatable, $ro['relationship_table']); |
|
1174
|
|
|
$foreignKey = CRUDBooster::getForeignKey($this->table, $ro['relationship_table']); |
|
1175
|
|
|
DB::table($ro['relationship_table'])->where($foreignKey, $id)->delete(); |
|
1176
|
|
|
|
|
1177
|
|
|
if ($inputdata) { |
|
1178
|
|
|
$relationship_table_pk = CB::pk($ro['relationship_table']); |
|
|
|
|
|
|
1179
|
|
|
foreach ($inputdata as $input_id) { |
|
1180
|
|
|
DB::table($ro['relationship_table'])->insert([ |
|
1181
|
|
|
// $relationship_table_pk => CRUDBooster::newId($ro['relationship_table']), |
|
1182
|
|
|
$foreignKey => $id, |
|
1183
|
|
|
$foreignKey2 => $input_id, |
|
1184
|
|
|
]); |
|
1185
|
|
|
} |
|
1186
|
|
|
} |
|
1187
|
|
|
} |
|
1188
|
|
|
} |
|
1189
|
|
|
|
|
1190
|
|
|
if ($ro['type'] == 'select2') { |
|
1191
|
|
|
if ($ro['relationship_table']) { |
|
1192
|
|
|
$datatable = explode(",", $ro['datatable'])[0]; |
|
1193
|
|
|
$foreignKey2 = CRUDBooster::getForeignKey($datatable, $ro['relationship_table']); |
|
1194
|
|
|
$foreignKey = CRUDBooster::getForeignKey($this->table, $ro['relationship_table']); |
|
1195
|
|
|
DB::table($ro['relationship_table'])->where($foreignKey, $id)->delete(); |
|
1196
|
|
|
|
|
1197
|
|
|
if ($inputdata) { |
|
1198
|
|
|
foreach ($inputdata as $input_id) { |
|
1199
|
|
|
$relationship_table_pk = CB::pk($row['relationship_table']); |
|
|
|
|
|
|
1200
|
|
|
DB::table($ro['relationship_table'])->insert([ |
|
1201
|
|
|
// $relationship_table_pk => CRUDBooster::newId($ro['relationship_table']), |
|
1202
|
|
|
$foreignKey => $id, |
|
1203
|
|
|
$foreignKey2 => $input_id, |
|
1204
|
|
|
]); |
|
1205
|
|
|
} |
|
1206
|
|
|
} |
|
1207
|
|
|
} |
|
1208
|
|
|
} |
|
1209
|
|
|
|
|
1210
|
|
|
if ($ro['type'] == 'child') { |
|
1211
|
|
|
$name = str_slug($ro['label'], ''); |
|
|
|
|
|
|
1212
|
|
|
$columns = $ro['columns']; |
|
1213
|
|
|
$getColName = Request::get($name.'-'.$columns[0]['name']); |
|
1214
|
|
|
$count_input_data = ($getColName)?(count($getColName) - 1):0; |
|
1215
|
|
|
$child_array = []; |
|
1216
|
|
|
$fk = $ro['foreign_key']; |
|
1217
|
|
|
|
|
1218
|
|
|
for ($i = 0; $i <= $count_input_data; $i++) { |
|
1219
|
|
|
$column_data = []; |
|
1220
|
|
|
foreach ($columns as $col) { |
|
1221
|
|
|
$colname = $col['name']; |
|
1222
|
|
|
$colvalue = Request::get($name.'-'.$colname)[$i]; |
|
1223
|
|
|
if(isset($colvalue) === TRUE) { |
|
1224
|
|
|
$column_data[$colname] = $colvalue; |
|
1225
|
|
|
} |
|
1226
|
|
|
} |
|
1227
|
|
|
if(isset($column_data) === TRUE) { |
|
1228
|
|
|
$column_data[$fk] = (!empty($id) ? $id : $lastInsertId); |
|
1229
|
|
|
$child_array[] = $column_data; |
|
1230
|
|
|
} |
|
1231
|
|
|
} |
|
1232
|
|
|
|
|
1233
|
|
|
$childtable = CRUDBooster::parseSqlTable($ro['table'])['table']; |
|
1234
|
|
|
DB::table($childtable)->insert($child_array); |
|
1235
|
|
|
} |
|
1236
|
|
|
} |
|
1237
|
|
|
|
|
1238
|
|
|
$this->hook_after_add($lastInsertId); |
|
1239
|
|
|
|
|
1240
|
|
|
$this->return_url = ($this->return_url) ? $this->return_url : Request::get('return_url'); |
|
1241
|
|
|
|
|
1242
|
|
|
//insert log |
|
1243
|
|
|
CRUDBooster::insertLog(trans("crudbooster.log_add", ['name' => $this->arr[$this->title_field], 'module' => CRUDBooster::getCurrentModule()->name])); |
|
1244
|
|
|
|
|
1245
|
|
|
if ($this->return_url) { |
|
1246
|
|
|
if (Request::get('submit') == trans('crudbooster.button_save_more')) { |
|
1247
|
|
|
CRUDBooster::redirect(Request::server('HTTP_REFERER'), trans("crudbooster.alert_add_data_success"), 'success'); |
|
1248
|
|
|
} else { |
|
1249
|
|
|
CRUDBooster::redirect($this->return_url, trans("crudbooster.alert_add_data_success"), 'success'); |
|
1250
|
|
|
} |
|
1251
|
|
|
} else { |
|
1252
|
|
|
if (Request::get('submit') == trans('crudbooster.button_save_more')) { |
|
1253
|
|
|
CRUDBooster::redirect(CRUDBooster::mainpath('add'), trans("crudbooster.alert_add_data_success"), 'success'); |
|
1254
|
|
|
} else { |
|
1255
|
|
|
CRUDBooster::redirect(CRUDBooster::mainpath(), trans("crudbooster.alert_add_data_success"), 'success'); |
|
1256
|
|
|
} |
|
1257
|
|
|
} |
|
1258
|
|
|
} |
|
1259
|
|
|
|
|
1260
|
|
|
public function getEdit($id) |
|
1261
|
|
|
{ |
|
1262
|
|
|
$this->cbLoader(); |
|
1263
|
|
|
$row = DB::table($this->table)->where($this->primary_key, $id)->first(); |
|
1264
|
|
|
|
|
1265
|
|
|
if (! CRUDBooster::isRead() && $this->global_privilege == false || $this->button_edit == false) { |
|
|
|
|
|
|
1266
|
|
|
CRUDBooster::insertLog(trans("crudbooster.log_try_edit", [ |
|
1267
|
|
|
'name' => $row->{$this->title_field}, |
|
1268
|
|
|
'module' => CRUDBooster::getCurrentModule()->name, |
|
1269
|
|
|
])); |
|
1270
|
|
|
CRUDBooster::redirect(CRUDBooster::adminPath(), trans('crudbooster.denied_access')); |
|
1271
|
|
|
} |
|
1272
|
|
|
|
|
1273
|
|
|
$page_menu = Route::getCurrentRoute()->getActionName(); |
|
1274
|
|
|
$page_title = trans("crudbooster.edit_data_page_title", ['module' => CRUDBooster::getCurrentModule()->name, 'name' => $row->{$this->title_field}]); |
|
1275
|
|
|
$command = 'edit'; |
|
1276
|
|
|
Session::put('current_row_id', $id); |
|
1277
|
|
|
|
|
1278
|
|
|
return view('crudbooster::default.form', compact('id', 'row', 'page_menu', 'page_title', 'command')); |
|
1279
|
|
|
} |
|
1280
|
|
|
|
|
1281
|
|
|
public function postEditSave($id) |
|
1282
|
|
|
{ |
|
1283
|
|
|
$this->cbLoader(); |
|
1284
|
|
|
$row = DB::table($this->table)->where($this->primary_key, $id)->first(); |
|
1285
|
|
|
|
|
1286
|
|
|
if (! CRUDBooster::isUpdate() && $this->global_privilege == false) { |
|
1287
|
|
|
CRUDBooster::insertLog(trans("crudbooster.log_try_add", ['name' => $row->{$this->title_field}, 'module' => CRUDBooster::getCurrentModule()->name])); |
|
1288
|
|
|
CRUDBooster::redirect(CRUDBooster::adminPath(), trans('crudbooster.denied_access')); |
|
1289
|
|
|
} |
|
1290
|
|
|
|
|
1291
|
|
|
$this->validation($id); |
|
1292
|
|
|
$this->input_assignment($id); |
|
1293
|
|
|
|
|
1294
|
|
|
if (Schema::hasColumn($this->table, 'updated_at')) { |
|
1295
|
|
|
$this->arr['updated_at'] = date('Y-m-d H:i:s'); |
|
1296
|
|
|
} |
|
1297
|
|
|
|
|
1298
|
|
|
$this->hook_before_edit($this->arr, $id); |
|
1299
|
|
|
DB::table($this->table)->where($this->primary_key, $id)->update($this->arr); |
|
1300
|
|
|
|
|
1301
|
|
|
//Looping Data Input Again After Insert |
|
1302
|
|
|
foreach ($this->data_inputan as $ro) { |
|
1303
|
|
|
$name = $ro['name']; |
|
1304
|
|
|
if (! $name) { |
|
1305
|
|
|
continue; |
|
1306
|
|
|
} |
|
1307
|
|
|
|
|
1308
|
|
|
$inputdata = Request::get($name); |
|
1309
|
|
|
|
|
1310
|
|
|
//Insert Data Checkbox if Type Datatable |
|
1311
|
|
|
if ($ro['type'] == 'checkbox') { |
|
1312
|
|
|
if ($ro['relationship_table']) { |
|
1313
|
|
|
$datatable = explode(",", $ro['datatable'])[0]; |
|
1314
|
|
|
|
|
1315
|
|
|
$foreignKey2 = CRUDBooster::getForeignKey($datatable, $ro['relationship_table']); |
|
1316
|
|
|
$foreignKey = CRUDBooster::getForeignKey($this->table, $ro['relationship_table']); |
|
1317
|
|
|
DB::table($ro['relationship_table'])->where($foreignKey, $id)->delete(); |
|
1318
|
|
|
|
|
1319
|
|
|
if ($inputdata) { |
|
1320
|
|
|
foreach ($inputdata as $input_id) { |
|
1321
|
|
|
$relationship_table_pk = CB::pk($ro['relationship_table']); |
|
|
|
|
|
|
1322
|
|
|
DB::table($ro['relationship_table'])->insert([ |
|
1323
|
|
|
// $relationship_table_pk => CRUDBooster::newId($ro['relationship_table']), |
|
1324
|
|
|
$foreignKey => $id, |
|
1325
|
|
|
$foreignKey2 => $input_id, |
|
1326
|
|
|
]); |
|
1327
|
|
|
} |
|
1328
|
|
|
} |
|
1329
|
|
|
} |
|
1330
|
|
|
} |
|
1331
|
|
|
|
|
1332
|
|
|
if ($ro['type'] == 'select2') { |
|
1333
|
|
|
if ($ro['relationship_table'] && $ro["datatable_orig"] == "") { |
|
1334
|
|
|
$datatable = explode(",", $ro['datatable'])[0]; |
|
1335
|
|
|
|
|
1336
|
|
|
$foreignKey2 = CRUDBooster::getForeignKey($datatable, $ro['relationship_table']); |
|
1337
|
|
|
$foreignKey = CRUDBooster::getForeignKey($this->table, $ro['relationship_table']); |
|
1338
|
|
|
DB::table($ro['relationship_table'])->where($foreignKey, $id)->delete(); |
|
1339
|
|
|
|
|
1340
|
|
|
if ($inputdata) { |
|
1341
|
|
|
foreach ($inputdata as $input_id) { |
|
1342
|
|
|
$relationship_table_pk = CB::pk($ro['relationship_table']); |
|
1343
|
|
|
DB::table($ro['relationship_table'])->insert([ |
|
1344
|
|
|
// $relationship_table_pk => CRUDBooster::newId($ro['relationship_table']), |
|
1345
|
|
|
$foreignKey => $id, |
|
1346
|
|
|
$foreignKey2 => $input_id, |
|
1347
|
|
|
]); |
|
1348
|
|
|
} |
|
1349
|
|
|
} |
|
1350
|
|
|
} |
|
1351
|
|
|
if ($ro['relationship_table'] && $ro["datatable_orig"] != "") { |
|
1352
|
|
|
$params = explode("|", $ro['datatable_orig']); |
|
1353
|
|
|
if(!isset($params[2])) $params[2] = "id"; |
|
1354
|
|
|
DB::table($params[0])->where($params[2], $id)->update([$params[1] => implode(",",$inputdata)]); |
|
1355
|
|
|
} |
|
1356
|
|
|
} |
|
1357
|
|
|
|
|
1358
|
|
|
if ($ro['type'] == 'child') { |
|
1359
|
|
|
$name = str_slug($ro['label'], ''); |
|
|
|
|
|
|
1360
|
|
|
$columns = $ro['columns']; |
|
1361
|
|
|
$getColName = Request::get($name.'-'.$columns[0]['name']); |
|
1362
|
|
|
$count_input_data = ($getColName)?(count($getColName) - 1):0; |
|
1363
|
|
|
$child_array = []; |
|
1364
|
|
|
$childtable = CRUDBooster::parseSqlTable($ro['table'])['table']; |
|
1365
|
|
|
$fk = $ro['foreign_key']; |
|
1366
|
|
|
|
|
1367
|
|
|
DB::table($childtable)->where($fk, $id)->delete(); |
|
1368
|
|
|
$lastId = CRUDBooster::newId($childtable); |
|
1369
|
|
|
$childtablePK = CB::pk($childtable); |
|
1370
|
|
|
|
|
1371
|
|
|
for ($i = 0; $i <= $count_input_data; $i++) { |
|
1372
|
|
|
$column_data = []; |
|
1373
|
|
|
foreach ($columns as $col) { |
|
1374
|
|
|
$colname = $col['name']; |
|
1375
|
|
|
$colvalue = Request::get($name.'-'.$colname)[$i]; |
|
1376
|
|
|
if(isset($colvalue) === TRUE) { |
|
1377
|
|
|
$column_data[$colname] = $colvalue; |
|
1378
|
|
|
} |
|
1379
|
|
|
} |
|
1380
|
|
|
if(isset($column_data) === TRUE){ |
|
1381
|
|
|
$column_data[$childtablePK] = $lastId; |
|
1382
|
|
|
$column_data[$fk] = $id; |
|
1383
|
|
|
$child_array[] = $column_data; |
|
1384
|
|
|
$lastId++; |
|
1385
|
|
|
} |
|
1386
|
|
|
} |
|
1387
|
|
|
$child_array = array_reverse($child_array); |
|
1388
|
|
|
DB::table($childtable)->insert($child_array); |
|
1389
|
|
|
} |
|
1390
|
|
|
} |
|
1391
|
|
|
|
|
1392
|
|
|
$this->hook_after_edit($id); |
|
1393
|
|
|
|
|
1394
|
|
|
$this->return_url = ($this->return_url) ? $this->return_url : Request::get('return_url'); |
|
1395
|
|
|
|
|
1396
|
|
|
//insert log |
|
1397
|
|
|
$old_values = json_decode(json_encode($row), true); |
|
1398
|
|
|
CRUDBooster::insertLog(trans("crudbooster.log_update", [ |
|
1399
|
|
|
'name' => $this->arr[$this->title_field], |
|
1400
|
|
|
'module' => CRUDBooster::getCurrentModule()->name, |
|
1401
|
|
|
]), LogsController::displayDiff($old_values, $this->arr)); |
|
1402
|
|
|
|
|
1403
|
|
|
if ($this->return_url) { |
|
1404
|
|
|
CRUDBooster::redirect($this->return_url, trans("crudbooster.alert_update_data_success"), 'success'); |
|
1405
|
|
|
} else { |
|
1406
|
|
|
if (Request::get('submit') == trans('crudbooster.button_save_more')) { |
|
1407
|
|
|
CRUDBooster::redirect(CRUDBooster::mainpath('add'), trans("crudbooster.alert_update_data_success"), 'success'); |
|
1408
|
|
|
} else { |
|
1409
|
|
|
CRUDBooster::redirect(CRUDBooster::mainpath(), trans("crudbooster.alert_update_data_success"), 'success'); |
|
1410
|
|
|
} |
|
1411
|
|
|
} |
|
1412
|
|
|
} |
|
1413
|
|
|
|
|
1414
|
|
|
public function getDelete($id) |
|
1415
|
|
|
{ |
|
1416
|
|
|
$this->cbLoader(); |
|
1417
|
|
|
$row = DB::table($this->table)->where($this->primary_key, $id)->first(); |
|
1418
|
|
|
|
|
1419
|
|
|
if (! CRUDBooster::isDelete() && $this->global_privilege == false || $this->button_delete == false) { |
|
|
|
|
|
|
1420
|
|
|
CRUDBooster::insertLog(trans("crudbooster.log_try_delete", [ |
|
1421
|
|
|
'name' => $row->{$this->title_field}, |
|
1422
|
|
|
'module' => CRUDBooster::getCurrentModule()->name, |
|
1423
|
|
|
])); |
|
1424
|
|
|
CRUDBooster::redirect(CRUDBooster::adminPath(), trans('crudbooster.denied_access')); |
|
1425
|
|
|
} |
|
1426
|
|
|
|
|
1427
|
|
|
//insert log |
|
1428
|
|
|
CRUDBooster::insertLog(trans("crudbooster.log_delete", ['name' => $row->{$this->title_field}, 'module' => CRUDBooster::getCurrentModule()->name])); |
|
1429
|
|
|
|
|
1430
|
|
|
$this->hook_before_delete($id); |
|
1431
|
|
|
|
|
1432
|
|
|
if (CRUDBooster::isColumnExists($this->table, 'deleted_at')) { |
|
1433
|
|
|
DB::table($this->table)->where($this->primary_key, $id)->update(['deleted_at' => date('Y-m-d H:i:s')]); |
|
1434
|
|
|
} else { |
|
1435
|
|
|
DB::table($this->table)->where($this->primary_key, $id)->delete(); |
|
1436
|
|
|
} |
|
1437
|
|
|
|
|
1438
|
|
|
$this->hook_after_delete($id); |
|
1439
|
|
|
|
|
1440
|
|
|
$url = g('return_url') ?: CRUDBooster::referer(); |
|
1441
|
|
|
|
|
1442
|
|
|
CRUDBooster::redirect($url, trans("crudbooster.alert_delete_data_success"), 'success'); |
|
1443
|
|
|
} |
|
1444
|
|
|
|
|
1445
|
|
|
public function getDetail($id) |
|
1446
|
|
|
{ |
|
1447
|
|
|
$this->cbLoader(); |
|
1448
|
|
|
$row = DB::table($this->table)->where($this->primary_key, $id)->first(); |
|
1449
|
|
|
|
|
1450
|
|
|
if (! CRUDBooster::isRead() && $this->global_privilege == false || $this->button_detail == false) { |
|
|
|
|
|
|
1451
|
|
|
CRUDBooster::insertLog(trans("crudbooster.log_try_view", [ |
|
1452
|
|
|
'name' => $row->{$this->title_field}, |
|
1453
|
|
|
'module' => CRUDBooster::getCurrentModule()->name, |
|
1454
|
|
|
])); |
|
1455
|
|
|
CRUDBooster::redirect(CRUDBooster::adminPath(), trans('crudbooster.denied_access')); |
|
1456
|
|
|
} |
|
1457
|
|
|
|
|
1458
|
|
|
$module = CRUDBooster::getCurrentModule(); |
|
1459
|
|
|
|
|
1460
|
|
|
$page_menu = Route::getCurrentRoute()->getActionName(); |
|
1461
|
|
|
$page_title = trans("crudbooster.detail_data_page_title", ['module' => $module->name, 'name' => $row->{$this->title_field}]); |
|
1462
|
|
|
$command = 'detail'; |
|
1463
|
|
|
|
|
1464
|
|
|
Session::put('current_row_id', $id); |
|
1465
|
|
|
|
|
1466
|
|
|
return view('crudbooster::default.form', compact('row', 'page_menu', 'page_title', 'command', 'id')); |
|
1467
|
|
|
} |
|
1468
|
|
|
|
|
1469
|
|
|
public function getImportData() |
|
1470
|
|
|
{ |
|
1471
|
|
|
$this->cbLoader(); |
|
1472
|
|
|
$data['page_menu'] = Route::getCurrentRoute()->getActionName(); |
|
|
|
|
|
|
1473
|
|
|
$data['page_title'] = 'Import Data '.$module->name; |
|
|
|
|
|
|
1474
|
|
|
|
|
1475
|
|
|
if (Request::get('file') && ! Request::get('import')) { |
|
1476
|
|
|
$file = base64_decode(Request::get('file')); |
|
1477
|
|
|
$file = storage_path('app/'.$file); |
|
1478
|
|
|
$rows = Excel::load($file, function ($reader) { |
|
1479
|
|
|
})->get(); |
|
1480
|
|
|
|
|
1481
|
|
|
$countRows = ($rows)?count($rows):0; |
|
1482
|
|
|
|
|
1483
|
|
|
Session::put('total_data_import', $countRows); |
|
1484
|
|
|
|
|
1485
|
|
|
$data_import_column = []; |
|
1486
|
|
|
foreach ($rows as $value) { |
|
1487
|
|
|
$a = []; |
|
1488
|
|
|
foreach ($value as $k => $v) { |
|
1489
|
|
|
$a[] = $k; |
|
1490
|
|
|
} |
|
1491
|
|
|
if ($a && count($a)) { |
|
1492
|
|
|
$data_import_column = $a; |
|
1493
|
|
|
} |
|
1494
|
|
|
break; |
|
1495
|
|
|
} |
|
1496
|
|
|
|
|
1497
|
|
|
$table_columns = DB::getSchemaBuilder()->getColumnListing($this->table); |
|
1498
|
|
|
|
|
1499
|
|
|
$data['table_columns'] = $table_columns; |
|
1500
|
|
|
$data['data_import_column'] = $data_import_column; |
|
1501
|
|
|
} |
|
1502
|
|
|
|
|
1503
|
|
|
return view('crudbooster::import', $data); |
|
1504
|
|
|
} |
|
1505
|
|
|
|
|
1506
|
|
|
public function postDoneImport() |
|
1507
|
|
|
{ |
|
1508
|
|
|
$this->cbLoader(); |
|
1509
|
|
|
$data['page_menu'] = Route::getCurrentRoute()->getActionName(); |
|
|
|
|
|
|
1510
|
|
|
$data['page_title'] = trans('crudbooster.import_page_title', ['module' => $module->name]); |
|
|
|
|
|
|
1511
|
|
|
Session::put('select_column', Request::get('select_column')); |
|
1512
|
|
|
|
|
1513
|
|
|
return view('crudbooster::import', $data); |
|
1514
|
|
|
} |
|
1515
|
|
|
|
|
1516
|
|
|
public function postDoImportChunk() |
|
1517
|
|
|
{ |
|
1518
|
|
|
$this->cbLoader(); |
|
1519
|
|
|
$file_md5 = md5(Request::get('file')); |
|
1520
|
|
|
|
|
1521
|
|
|
if (Request::get('file') && Request::get('resume') == 1) { |
|
1522
|
|
|
$total = Session::get('total_data_import'); |
|
1523
|
|
|
$prog = intval(Cache::get('success_'.$file_md5)) / $total * 100; |
|
1524
|
|
|
$prog = round($prog, 2); |
|
1525
|
|
|
if ($prog >= 100) { |
|
1526
|
|
|
Cache::forget('success_'.$file_md5); |
|
1527
|
|
|
} |
|
1528
|
|
|
|
|
1529
|
|
|
return response()->json(['progress' => $prog, 'last_error' => Cache::get('error_'.$file_md5)]); |
|
1530
|
|
|
} |
|
1531
|
|
|
|
|
1532
|
|
|
$select_column = Session::get('select_column'); |
|
1533
|
|
|
$select_column = array_filter($select_column); |
|
1534
|
|
|
$table_columns = DB::getSchemaBuilder()->getColumnListing($this->table); |
|
1535
|
|
|
|
|
1536
|
|
|
$file = base64_decode(Request::get('file')); |
|
1537
|
|
|
$file = storage_path('app/'.$file); |
|
1538
|
|
|
|
|
1539
|
|
|
$rows = Excel::load($file, function ($reader) { |
|
1540
|
|
|
})->get(); |
|
1541
|
|
|
|
|
1542
|
|
|
$has_created_at = false; |
|
1543
|
|
|
if (CRUDBooster::isColumnExists($this->table, 'created_at')) { |
|
1544
|
|
|
$has_created_at = true; |
|
1545
|
|
|
} |
|
1546
|
|
|
|
|
1547
|
|
|
$data_import_column = []; |
|
|
|
|
|
|
1548
|
|
|
foreach ($rows as $value) { |
|
1549
|
|
|
$a = []; |
|
1550
|
|
|
foreach ($select_column as $sk => $s) { |
|
1551
|
|
|
$colname = $table_columns[$sk]; |
|
1552
|
|
|
|
|
1553
|
|
|
if (CRUDBooster::isForeignKey($colname)) { |
|
1554
|
|
|
|
|
1555
|
|
|
//Skip if value is empty |
|
1556
|
|
|
if ($value->$s == '') { |
|
1557
|
|
|
continue; |
|
1558
|
|
|
} |
|
1559
|
|
|
|
|
1560
|
|
|
if (intval($value->$s)) { |
|
1561
|
|
|
$a[$colname] = $value->$s; |
|
1562
|
|
|
} else { |
|
1563
|
|
|
$relation_table = CRUDBooster::getTableForeignKey($colname); |
|
1564
|
|
|
$relation_moduls = DB::table('cms_moduls')->where('table_name', $relation_table)->first(); |
|
1565
|
|
|
|
|
1566
|
|
|
$relation_class = __NAMESPACE__.'\\'.$relation_moduls->controller; |
|
1567
|
|
|
if (! class_exists($relation_class)) { |
|
1568
|
|
|
$relation_class = '\App\Http\Controllers\\'.$relation_moduls->controller; |
|
1569
|
|
|
} |
|
1570
|
|
|
$relation_class = new $relation_class; |
|
1571
|
|
|
$relation_class->cbLoader(); |
|
1572
|
|
|
|
|
1573
|
|
|
$title_field = $relation_class->title_field; |
|
1574
|
|
|
|
|
1575
|
|
|
$relation_insert_data = []; |
|
1576
|
|
|
$relation_insert_data[$title_field] = $value->$s; |
|
1577
|
|
|
|
|
1578
|
|
|
if (CRUDBooster::isColumnExists($relation_table, 'created_at')) { |
|
1579
|
|
|
$relation_insert_data['created_at'] = date('Y-m-d H:i:s'); |
|
1580
|
|
|
} |
|
1581
|
|
|
|
|
1582
|
|
|
try { |
|
1583
|
|
|
$relation_exists = DB::table($relation_table)->where($title_field, $value->$s)->first(); |
|
1584
|
|
|
if ($relation_exists) { |
|
1585
|
|
|
$relation_primary_key = $relation_class->primary_key; |
|
1586
|
|
|
$relation_id = $relation_exists->$relation_primary_key; |
|
1587
|
|
|
} else { |
|
1588
|
|
|
$relation_id = DB::table($relation_table)->insertGetId($relation_insert_data); |
|
1589
|
|
|
} |
|
1590
|
|
|
|
|
1591
|
|
|
$a[$colname] = $relation_id; |
|
1592
|
|
|
} catch (\Exception $e) { |
|
1593
|
|
|
exit($e); |
|
|
|
|
|
|
1594
|
|
|
} |
|
1595
|
|
|
} //END IS INT |
|
1596
|
|
|
|
|
1597
|
|
|
} else { |
|
1598
|
|
|
$a[$colname] = $value->$s; |
|
1599
|
|
|
} |
|
1600
|
|
|
} |
|
1601
|
|
|
|
|
1602
|
|
|
$has_title_field = true; |
|
1603
|
|
|
foreach ($a as $k => $v) { |
|
1604
|
|
|
if ($k == $this->title_field && $v == '') { |
|
1605
|
|
|
$has_title_field = false; |
|
1606
|
|
|
break; |
|
1607
|
|
|
} |
|
1608
|
|
|
} |
|
1609
|
|
|
|
|
1610
|
|
|
if ($has_title_field == false) { |
|
1611
|
|
|
continue; |
|
1612
|
|
|
} |
|
1613
|
|
|
|
|
1614
|
|
|
try { |
|
1615
|
|
|
|
|
1616
|
|
|
if ($has_created_at) { |
|
1617
|
|
|
$a['created_at'] = date('Y-m-d H:i:s'); |
|
1618
|
|
|
} |
|
1619
|
|
|
|
|
1620
|
|
|
DB::table($this->table)->insert($a); |
|
1621
|
|
|
Cache::increment('success_'.$file_md5); |
|
1622
|
|
|
} catch (\Exception $e) { |
|
1623
|
|
|
$e = (string) $e; |
|
1624
|
|
|
Cache::put('error_'.$file_md5, $e, 500); |
|
1625
|
|
|
} |
|
1626
|
|
|
} |
|
1627
|
|
|
|
|
1628
|
|
|
return response()->json(['status' => true]); |
|
1629
|
|
|
} |
|
1630
|
|
|
|
|
1631
|
|
|
public function postDoUploadImportData() |
|
1632
|
|
|
{ |
|
1633
|
|
|
$this->cbLoader(); |
|
1634
|
|
|
if (Request::hasFile('userfile')) { |
|
1635
|
|
|
$file = Request::file('userfile'); |
|
1636
|
|
|
$ext = $file->getClientOriginalExtension(); |
|
1637
|
|
|
|
|
1638
|
|
|
$validator = Validator::make([ |
|
1639
|
|
|
'extension' => $ext, |
|
1640
|
|
|
], [ |
|
1641
|
|
|
'extension' => 'in:xls,xlsx,csv', |
|
1642
|
|
|
]); |
|
1643
|
|
|
|
|
1644
|
|
|
if ($validator->fails()) { |
|
1645
|
|
|
$message = $validator->errors()->all(); |
|
1646
|
|
|
|
|
1647
|
|
|
return redirect()->back()->with(['message' => implode('<br/>', $message), 'message_type' => 'warning']); |
|
1648
|
|
|
} |
|
1649
|
|
|
|
|
1650
|
|
|
//Create Directory Monthly |
|
1651
|
|
|
$filePath = 'uploads/'.CB::myId().'/'.date('Y-m'); |
|
1652
|
|
|
Storage::makeDirectory($filePath); |
|
1653
|
|
|
|
|
1654
|
|
|
//Move file to storage |
|
1655
|
|
|
$filename = md5(str_random(5)).'.'.$ext; |
|
|
|
|
|
|
1656
|
|
|
$url_filename = ''; |
|
1657
|
|
|
if (Storage::putFileAs($filePath, $file, $filename)) { |
|
1658
|
|
|
$url_filename = $filePath.'/'.$filename; |
|
1659
|
|
|
} |
|
1660
|
|
|
$url = CRUDBooster::mainpath('import-data').'?file='.base64_encode($url_filename); |
|
1661
|
|
|
|
|
1662
|
|
|
return redirect($url); |
|
1663
|
|
|
} else { |
|
1664
|
|
|
return redirect()->back(); |
|
1665
|
|
|
} |
|
1666
|
|
|
} |
|
1667
|
|
|
|
|
1668
|
|
|
public function postActionSelected() |
|
1669
|
|
|
{ |
|
1670
|
|
|
$this->cbLoader(); |
|
1671
|
|
|
$id_selected = Request::input('checkbox'); |
|
1672
|
|
|
$button_name = Request::input('button_name'); |
|
1673
|
|
|
|
|
1674
|
|
|
if (! $id_selected) { |
|
1675
|
|
|
CRUDBooster::redirect($_SERVER['HTTP_REFERER'], trans("crudbooster.alert_select_a_data"), 'warning'); |
|
1676
|
|
|
} |
|
1677
|
|
|
|
|
1678
|
|
|
if ($button_name == 'delete') { |
|
1679
|
|
|
if (! CRUDBooster::isDelete()) { |
|
1680
|
|
|
CRUDBooster::insertLog(trans("crudbooster.log_try_delete_selected", ['module' => CRUDBooster::getCurrentModule()->name])); |
|
1681
|
|
|
CRUDBooster::redirect(CRUDBooster::adminPath(), trans('crudbooster.denied_access')); |
|
1682
|
|
|
} |
|
1683
|
|
|
|
|
1684
|
|
|
$this->hook_before_delete($id_selected); |
|
1685
|
|
|
$tablePK = CB::pk($this->table); |
|
1686
|
|
|
if (CRUDBooster::isColumnExists($this->table, 'deleted_at')) { |
|
1687
|
|
|
|
|
1688
|
|
|
DB::table($this->table)->whereIn($tablePK, $id_selected)->update(['deleted_at' => date('Y-m-d H:i:s')]); |
|
1689
|
|
|
} else { |
|
1690
|
|
|
DB::table($this->table)->whereIn($tablePK, $id_selected)->delete(); |
|
1691
|
|
|
} |
|
1692
|
|
|
CRUDBooster::insertLog(trans("crudbooster.log_delete", ['name' => implode(',', $id_selected), 'module' => CRUDBooster::getCurrentModule()->name])); |
|
1693
|
|
|
|
|
1694
|
|
|
$this->hook_after_delete($id_selected); |
|
1695
|
|
|
|
|
1696
|
|
|
$message = trans("crudbooster.alert_delete_selected_success"); |
|
1697
|
|
|
|
|
1698
|
|
|
return redirect()->back()->with(['message_type' => 'success', 'message' => $message]); |
|
1699
|
|
|
} |
|
1700
|
|
|
|
|
1701
|
|
|
$action = str_replace(['-', '_'], ' ', $button_name); |
|
1702
|
|
|
$action = ucwords($action); |
|
1703
|
|
|
$type = 'success'; |
|
1704
|
|
|
$message = trans("crudbooster.alert_action", ['action' => $action]); |
|
1705
|
|
|
|
|
1706
|
|
|
if ($this->actionButtonSelected($id_selected, $button_name) === false) { |
|
1707
|
|
|
$message = ! empty($this->alert['message']) ? $this->alert['message'] : 'Error'; |
|
1708
|
|
|
$type = ! empty($this->alert['type']) ? $this->alert['type'] : 'danger'; |
|
1709
|
|
|
} |
|
1710
|
|
|
|
|
1711
|
|
|
return redirect()->back()->with(['message_type' => $type, 'message' => $message]); |
|
1712
|
|
|
} |
|
1713
|
|
|
|
|
1714
|
|
|
public function getDeleteImage() |
|
1715
|
|
|
{ |
|
1716
|
|
|
$this->cbLoader(); |
|
1717
|
|
|
$id = Request::get('id'); |
|
1718
|
|
|
$column = Request::get('column'); |
|
1719
|
|
|
|
|
1720
|
|
|
$row = DB::table($this->table)->where($this->primary_key, $id)->first(); |
|
1721
|
|
|
|
|
1722
|
|
|
if (! CRUDBooster::isDelete() && $this->global_privilege == false) { |
|
1723
|
|
|
CRUDBooster::insertLog(trans("crudbooster.log_try_delete_image", [ |
|
1724
|
|
|
'name' => $row->{$this->title_field}, |
|
1725
|
|
|
'module' => CRUDBooster::getCurrentModule()->name, |
|
1726
|
|
|
])); |
|
1727
|
|
|
CRUDBooster::redirect(CRUDBooster::adminPath(), trans('crudbooster.denied_access')); |
|
1728
|
|
|
} |
|
1729
|
|
|
|
|
1730
|
|
|
$row = DB::table($this->table)->where($this->primary_key, $id)->first(); |
|
1731
|
|
|
|
|
1732
|
|
|
$file = str_replace('uploads/', '', $row->{$column}); |
|
1733
|
|
|
if (Storage::exists($file)) { |
|
1734
|
|
|
Storage::delete($file); |
|
1735
|
|
|
} |
|
1736
|
|
|
|
|
1737
|
|
|
DB::table($this->table)->where($this->primary_key, $id)->update([$column => null]); |
|
1738
|
|
|
|
|
1739
|
|
|
CRUDBooster::insertLog(trans("crudbooster.log_delete_image", [ |
|
1740
|
|
|
'name' => $row->{$this->title_field}, |
|
1741
|
|
|
'module' => CRUDBooster::getCurrentModule()->name, |
|
1742
|
|
|
])); |
|
1743
|
|
|
|
|
1744
|
|
|
CRUDBooster::redirect(Request::server('HTTP_REFERER'), trans('crudbooster.alert_delete_data_success'), 'success'); |
|
1745
|
|
|
} |
|
1746
|
|
|
|
|
1747
|
|
|
public function postUploadSummernote() |
|
1748
|
|
|
{ |
|
1749
|
|
|
$this->cbLoader(); |
|
1750
|
|
|
$name = 'userfile'; |
|
1751
|
|
|
if ($file = CRUDBooster::uploadFile($name, true)) { |
|
1752
|
|
|
echo asset($file); |
|
1753
|
|
|
} |
|
1754
|
|
|
} |
|
1755
|
|
|
|
|
1756
|
|
|
public function postUploadFile() |
|
1757
|
|
|
{ |
|
1758
|
|
|
$this->cbLoader(); |
|
1759
|
|
|
$name = 'userfile'; |
|
1760
|
|
|
if ($file = CRUDBooster::uploadFile($name, true)) { |
|
1761
|
|
|
echo asset($file); |
|
1762
|
|
|
} |
|
1763
|
|
|
} |
|
1764
|
|
|
|
|
1765
|
|
|
public function actionButtonSelected($id_selected, $button_name) |
|
1766
|
|
|
{ |
|
1767
|
|
|
} |
|
1768
|
|
|
|
|
1769
|
|
|
public function hook_query_index(&$query) |
|
1770
|
|
|
{ |
|
1771
|
|
|
} |
|
1772
|
|
|
|
|
1773
|
|
|
public function hook_row_index($index, &$value) |
|
1774
|
|
|
{ |
|
1775
|
|
|
} |
|
1776
|
|
|
|
|
1777
|
|
|
public function hook_before_add(&$arr) |
|
1778
|
|
|
{ |
|
1779
|
|
|
} |
|
1780
|
|
|
|
|
1781
|
|
|
public function hook_after_add($id) |
|
1782
|
|
|
{ |
|
1783
|
|
|
} |
|
1784
|
|
|
|
|
1785
|
|
|
public function hook_before_edit(&$arr, $id) |
|
1786
|
|
|
{ |
|
1787
|
|
|
} |
|
1788
|
|
|
|
|
1789
|
|
|
public function hook_after_edit($id) |
|
1790
|
|
|
{ |
|
1791
|
|
|
} |
|
1792
|
|
|
|
|
1793
|
|
|
public function hook_before_delete($id) |
|
1794
|
|
|
{ |
|
1795
|
|
|
} |
|
1796
|
|
|
|
|
1797
|
|
|
public function hook_after_delete($id) |
|
1798
|
|
|
{ |
|
1799
|
|
|
} |
|
1800
|
|
|
} |
|
1801
|
|
|
|
crocodic-studio /
crudbooster
Loading history...
The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g.
excluded_paths: ["lib/*"], you can move it to the dependency path list as follows:For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths