<?php

/**
 * inoERP
 *
 * @copyright   2014 Nishit R. Das
 * @license     https://www.mozilla.org/MPL/2.0/
 * @link        http://inoideas.org
 * @source code https://github.com/inoerp/inoERP
 */

/**
 * 
 *
 */
class user_dashboard_v extends dbObject {

 public static $table_name = "user";
 public static $primary_column = "user_id";
 public static $key_column = 'item_id_m';
 public static $module = "extensions";
 public static $dont_show_bread_crum = true;
 public static $system_info = [
		 'name' => 'User Dashboard',
		 'number' => '10027',
		 'description' => 'User Dashboard',
		 'version' => '0.1.1',
		 'db_version' => '1001',
		 'mod_version' => '1.1.1',
		 'primary_entity_cb' => '',
		 'module_name' => 'extn',
		 'weight' => 27
 ];
 public $field_a = [
		 'content_id',
		 'content_type_id',
		 'subject',
		 'created_by',
		 'creation_date',
		 'published_cb',
		 'user_id',
		 'username',
		 'first_name',
		 'last_name',
		 'major_category_id',
		 'major_category',
		 'category',
		 'content_type',
 ];
 public $initial_search = [
		 'item_number',
 ];
 public $pageTitle = " User Dashboard "; //page Title
 public $search_functions = [
		 'Organization' => 'search_org_name',
		 'Forecast ' => 'search_forecast_name',
		 'Forecast Group ' => 'search_forecast_group',
 ];
 public $content_id;
 public $content_type_id;
 public $subject;
 public $created_by;
 public $creation_date;
 public $published_cb;
 public $user_id;
 public $username;
 public $first_name;
 public $last_name;
 public $major_category_id;
 public $major_category;
 public $category;
 public $category_id;
 public $content_type;
 public $reference_table;
 public $phone;
 public static $icon_stmt_a = [
		 'inv' => ['div_class' => 'fa-bank', 'description' => 'Inventory'],
		 'sd' => ['div_class' => 'fa-truck', 'description' => 'Sales & Distribution'],
		 'pur' => ['div_class' => 'fa-file-text-o', 'description' => 'Purchasing'],
		 'bom' => ['div_class' => 'fa-sitemap', 'description' => 'Bills Of Material'],
		 'cst' => ['div_class' => 'fa-cubes', 'description' => 'Cost Management'],
		 'wip' => ['div_class' => 'fa-tasks', 'description' => 'WIP & MES'],
		 'pm' => ['div_class' => 'fa-flask', 'description' => 'Process'],
		 'fp' => ['div_class' => 'fa-th-large', 'description' => 'Forecast & Planning'],
		 'am' => ['div_class' => 'fa-wrench', 'description' => 'Asset Maintenance'],
		 'qa' => ['div_class' => 'fa-search', 'description' => 'Quality'],
		 'pos' => ['div_class' => 'fa-shopping-cart', 'description' => 'Point Of Sale'],
		 'ec' => ['div_class' => 'fa-globe', 'description' => 'eCommerce'],
		 'gl' => ['div_class' => 'fa-book', 'description' => 'General Ledger'],
		 'ap' => ['div_class' => 'fa-credit-card', 'description' => 'Payable'],
		 'ar' => ['div_class' => 'fa-dollar', 'description' => 'Receivable'],
		 'cm' => ['div_class' => 'fa-money', 'description' => 'Cash Management'],
		 'fa' => ['div_class' => 'fa-building', 'description' => 'Fixed Asset'],
		 'hr' => ['div_class' => 'fa-users', 'description' => 'Human Resource'],
		 'hd' => ['div_class' => 'fa-support', 'description' => 'Service Help Desk'],
		 'prj' => ['div_class' => 'fa-briefcase', 'description' => 'Projects'],
		 'lms' => ['div_class' => 'fa-graduation-cap', 'description' => 'Learning Management'],
		 'da' => ['div_class' => 'fa-object-group', 'description' => 'Document & Analysis'],
		 'adm' => ['div_class' => 'fa-database', 'description' => 'Admin'],
		 'sys' => ['div_class' => 'fa-cogs', 'description' => 'Global Setup'],
		 'ext' => ['div_class' => 'fa-sliders', 'description' => 'Extensions'],
 ];

 public function user_contents() {

	$sql = " 
   SELECT con.content_id, con.content_type_id, con.subject, con.created_by, con.creation_date, con.published_cb,
   user.ino_user_id, user.username, user.first_name, user.phone,
user.last_name, cr.major_category_id, maj_cat.category as major_category,cat.category, ct.content_type
FROM ino_user as user,
content con LEFT JOIN category_reference cr ON cr.reference_id = con.content_id AND reference_table ='content'
LEFT JOIN category maj_cat ON maj_cat.category_id = cr.major_category_id
LEFT JOIN category cat ON cat.category_id = cr.category_id
LEFT JOIN content_type ct ON ct.content_type_id = con.content_type_id
WHERE  con.created_by = user.ino_user_id
";

	if (!empty($this->user_id)) {
	 $sql .= " AND user.ino_user_id = '{$this->user_id}' ";
	}
	if (!empty($this->username)) {
	 $sql .= " AND user.username = '{$this->username}' ";
	}
	if (!empty($this->category)) {
	 $sql .= " AND cat.category = '{$this->category}' ";
	}
	if (!empty($this->category_id)) {
	 $sql .= " AND cat.category_id = '{$this->category_id}' ";
	}

	$result = $this->findBySql($sql);
	return !empty($result) ? $result : false;
 }

 public function user_comments() {

	$sql = " 
   SELECT com.comment_id, com.reference_table, com.reference_id, com.comment ,com.published_cb, com.creation_date, 
   user.ino_user_id, user.username, user.first_name,
user.last_name, con.content_type_id
FROM ino_user as user,
comment com,
content con 
WHERE  com.created_by = user.ino_user_id
AND com.reference_table = 'content'
AND con.content_id =  com.reference_id
";

	if (!empty($this->user_id)) {
	 $sql .= " AND user.ino_user_id = '{$this->user_id}' ";
	}
	if (!empty($this->username)) {
	 $sql .= " AND user.username = '{$this->username}' ";
	}
	if (!empty($this->reference_table)) {
	 $sql .= " AND com.reference_table = '{$this->reference_table}' ";
	}

	$result = $this->findBySql($sql);
	return !empty($result) ? $result : false;
 }

 public static function staticVar_init($staticvar) {
	foreach (self::${$staticvar} as $key => $value) {
	 self::${$staticvar}[$key]['description'] = gettext($value['description']);
	}
 }

}

user_dashboard_v::staticVar_init('icon_stmt_a');
?>