S
Asked
Hi, i need a little hint please!
in code i can find for example:
```php
$this->datatables
->select('image, code, name, wp.quantity, alert_quantity')
->from('products')
->join("( SELECT * from {$this->db->dbprefix('warehouses_products')} WHERE warehouse_id = {$warehouse_id}) wp", 'products.id=wp.product_id', 'left')
->where('alert_quantity > wp.quantity', NULL)
->or_where('wp.quantity', NULL)
->where('track_quantity', 1)
->group_by('products.id');
echo $this->datatables->generate();
```
If i'd like to use a full query like for example:
```php
$this->datatables
->query("SELECT a.* FROM ... ORDER BY ...");
echo $this->datatables->generate();
```
But i think i use a wrong syntax... Can you help my with a hint? or what kind of framework i have to check?
Thank you in advance
in code i can find for example:
```php
$this->datatables
->select('image, code, name, wp.quantity, alert_quantity')
->from('products')
->join("( SELECT * from {$this->db->dbprefix('warehouses_products')} WHERE warehouse_id = {$warehouse_id}) wp", 'products.id=wp.product_id', 'left')
->where('alert_quantity > wp.quantity', NULL)
->or_where('wp.quantity', NULL)
->where('track_quantity', 1)
->group_by('products.id');
echo $this->datatables->generate();
```
If i'd like to use a full query like for example:
```php
$this->datatables
->query("SELECT a.* FROM ... ORDER BY ...");
echo $this->datatables->generate();
```
But i think i use a wrong syntax... Can you help my with a hint? or what kind of framework i have to check?
Thank you in advance
- EGAnswered**[Ste](/u/iojedi)** Check `header.php` in `themes\default\admin\view` , `MY_Controller.php` in `app\core` and Site.php in `app\models`
See attached screenshots - SAnswered**[Enyinnaya Gift](/u/giftedhands4real)** I accepted your answer with the code...
Now i need to edit the "alert quantity in the top bar" and the search script in the Report page.
I'd like to know only where is the files that contains the scripts for the alert anf for the search in the report page...
Thank you so much!!! - Login to Reply