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

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

��ѧ٧ѧ�
<?php namespace App\Models; class Notes_model extends Crud_model { protected $table = null; function __construct() { $this->table = 'notes'; parent::__construct($this->table); } function get_details($options = array()) { $notes_table = $this->db->prefixTable('notes'); $users_table = $this->db->prefixTable('users'); $where = ""; $or_where = ""; $id = get_array_value($options, "id"); if ($id) { $where .= " AND $notes_table.id=$id"; $or_where = " $notes_table.is_public=1 AND $notes_table.deleted=0 AND $notes_table.id=$id"; //check public note } $project_id = get_array_value($options, "project_id"); if ($project_id) { $where .= " AND $notes_table.project_id=$project_id"; $or_where = " $notes_table.is_public=1 AND $notes_table.deleted=0 AND $notes_table.project_id=$project_id "; //include public notes in projects } $client_id = get_array_value($options, "client_id"); if ($client_id) { $where .= " AND $notes_table.client_id=$client_id"; } $user_id = get_array_value($options, "user_id"); if ($user_id) { $where .= " AND $notes_table.user_id=$user_id"; } $created_by = get_array_value($options, "created_by"); if ($created_by) { $where .= " AND $notes_table.created_by=$created_by"; } $my_notes = get_array_value($options, "my_notes"); if ($my_notes) { $where .= " AND $notes_table.user_id=0 AND $notes_table.client_id=0 "; //don't include client's and team member's notes } if($or_where){ $where.=" OR ($or_where)"; } $select_labels_data_query = $this->get_labels_data_query(); $sql = "SELECT $notes_table.*, CONCAT($users_table.first_name, ' ', $users_table.last_name) AS created_by_user_name, $select_labels_data_query FROM $notes_table LEFT JOIN $users_table ON $users_table.id=$notes_table.created_by WHERE $notes_table.deleted=0 $where"; return $this->db->query($sql); } function get_label_suggestions($user_id) { $notes_table = $this->db->prefixTable('notes'); $sql = "SELECT GROUP_CONCAT(labels) as label_groups FROM $notes_table WHERE $notes_table.deleted=0 AND $notes_table.created_by=$user_id"; return $this->db->query($sql)->getRow()->label_groups; } }

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