��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧�

��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧� - ��֧էѧܧ�ڧ��ӧѧ�� - /home/rickpfrv/clients.dominiquerickard.com/app/Models/General_files_model.php

��ѧ٧ѧ�
<?php namespace App\Models; class General_files_model extends Crud_model { protected $table = null; function __construct() { $this->table = 'general_files'; parent::__construct($this->table); } function get_details($options = array()) { $general_files_table = $this->db->prefixTable('general_files'); $users_table = $this->db->prefixTable('users'); $where = ""; $id = get_array_value($options, "id"); if ($id) { $where = " AND $general_files_table.id=$id"; } $client_id = get_array_value($options, "client_id"); if ($client_id) { $where = " AND $general_files_table.client_id=$client_id"; } $user_id = get_array_value($options, "user_id"); if ($user_id) { $where = " AND $general_files_table.user_id = $user_id"; } $sql = "SELECT $general_files_table.*, CONCAT($users_table.first_name, ' ', $users_table.last_name) AS uploaded_by_user_name, $users_table.image AS uploaded_by_user_image, $users_table.user_type AS uploaded_by_user_type FROM $general_files_table LEFT JOIN $users_table ON $users_table.id= $general_files_table.uploaded_by WHERE $general_files_table.deleted=0 $where"; return $this->db->query($sql); } }

| ver. 1.4 | Github | . | PHP 7.4.33 | ��֧ߧ֧�ѧ�ڧ� ��ѧߧڧ��: 0.1 | proxy | phpinfo | ��ѧ��ۧܧ�