<?php
include('./dbconnect.php');
class api_models extends dbconnect{
	
	public function __construct($db_info) {
		$this->open_db($db_info);
	}

	//GET USER DATA FOR BOTH COLLMAN & CINCO
	public function get_user($fromDb){ 
		$fromDb = strtoupper($fromDb);
		$query  = 'SELECT "'.$fromDb.'" AS fromDb, IF(cw_employees.termination_status = 0, 1, 2) AS status,cw_employees.emp_name AS name,cw_employees.mobile_number AS mobile,cw_employees.user_right AS role,cw_employees.personal_email_id AS email,cw_employees.user_name AS loginCode,cw_employees.password AS password,cw_employees.employee_code AS empCode,cw_employees.role AS category,cw_employees.branch AS branch,cw_employees.portfolio AS protfolio,cw_employees.designation AS designation,cw_employees.date_of_birth AS dateOfBirth,cw_employees.bank_account_number AS bankAccNo,cw_employees.bank_name AS bankName,cw_employees.ifsc_code AS ifsc,cw_employees.date_of_joining AS dateOfJoining,IF(cw_employees.date_of_joining,DATE_FORMAT(cw_employees.date_of_joining,"%m"),"") AS joiningMonth,IF(cw_employees.date_of_joining,DATE_FORMAT(cw_employees.date_of_joining,"%Y"),"") AS joiningYear,cw_employees.resignation_date AS resignationDate,IF(cw_employees.resignation_date,DATE_FORMAT(cw_employees.resignation_date,"%m"),"") AS resignationMonth ,IF(cw_employees.resignation_date,DATE_FORMAT(cw_employees.resignation_date,"%Y"),"") AS resignationYear,level1.designation AS level1ReportingDesignation,cw_employees.tl_report AS level1ReportingUser,level2.designation AS level2ReportingDesignation,cw_employees.manager_report AS level2ReportingUser,cw_employees.trans_status AS transSts FROM cw_employees INNER JOIN cw_employees level1 ON level1.employee_code = cw_employees.tl_report INNER JOIN cw_employees level2 ON level2.employee_code = cw_employees.manager_report';
		$query_info     = $this->runQuery($query);
		$query_result   = $this->result($query_info);

		$sts = false;
		$msg = "No user data found";
		if($query_result){
			$sts = true;
			$msg = $fromDb ." user data";
		}
		return array('sts'=>$sts,'msg'=>$msg,'rslt'=>$query_result,'error'=>[]);
	}

	//GET ROLE DATA FOR BOTH COLLMAN & CINCO
	public function get_role($fromDb){ 
		$fromDb = strtoupper($fromDb);
		$query  = 'SELECT "'.$fromDb.'" AS fromDb, prime_user_role_id as roleId,role_name as role ,trans_status as transSts FROM cw_user_role';
		$query_info     = $this->runQuery($query);
		$query_result   = $this->result($query_info);

		$sts = false;
		$msg = "No role data found";
		if($query_result){
			$sts = true;
			$msg = $fromDb ." role data";
		}
		return array('sts'=>$sts,'msg'=>$msg,'rslt'=>$query_result,'error'=>[]);
	}

	//GET DESIGNATION DATA FOR BOTH COLLMAN & CINCO
	public function get_designation($fromDb){ 
		$fromDb = strtoupper($fromDb);
		$query  = 'SELECT "'.$fromDb.'" AS fromDb, prime_designation_id as designationId,designation,trans_status as transSts FROM cw_designation';
		$query_info     = $this->runQuery($query);
		$query_result   = $this->result($query_info);
		$sts = false;
		$msg = "No designation data found";
		if($query_result){
			$sts = true;
			$msg = $fromDb ." designation data";
		}
		return array('sts'=>$sts,'msg'=>$msg,'rslt'=>$query_result,'error'=>[]);
	}

	//GET CATEGORY DATA FOR BOTH COLLMAN & CINCO
	public function get_category($fromDb){ 
		$fromDb = strtoupper($fromDb);
		$query  = 'SELECT "'.$fromDb.'" AS fromDb, prime_category_id as categoryId ,category_name as category,trans_status as transSts FROM cw_category';
		$query_info     = $this->runQuery($query);
		$query_result   = $this->result($query_info);

		$sts = false;
		$msg = "No category data found";
		if($query_result){
			$sts = true;
			$msg = $fromDb ." category data";
		}
		return array('sts'=>$sts,'msg'=>$msg,'rslt'=>$query_result,'error'=>[]);
	}

	//GET BRANCH DATA FOR BOTH COLLMAN & CINCO
	public function get_branch($fromDb){ 
		$fromDb = strtoupper($fromDb);
		$query  = 'SELECT "'.$fromDb.'" AS fromDb, prime_branch_id as branchId  ,branch ,trans_status as transSts FROM cw_branch';
		$query_info     = $this->runQuery($query);
		$query_result   = $this->result($query_info);

		$sts = false;
		$msg = "No branch data found";
		if($query_result){
			$sts = true;
			$msg = $fromDb ." branch data";
		}
		return array('sts'=>$sts,'msg'=>$msg,'rslt'=>$query_result,'error'=>[]);
	}

	//GET PORTFOLIO DATA FOR BOTH COLLMAN & CINCO
	public function get_portfolio($fromDb){ 
		$fromDb = strtoupper($fromDb);
		$query  = 'SELECT "'.$fromDb.'" AS fromDb, prime_portfolio_id as portfolioId ,portfolio_name as portfolio,trans_status as transSts FROM cw_portfolio';
		$query_info     = $this->runQuery($query);
		$query_result   = $this->result($query_info);
		$sts = false;
		$msg = "No portfolio data found";
		if($query_result){
			$sts = true;
			$msg = $fromDb ." portfolio data";
		}
		return array('sts'=>$sts,'msg'=>$msg,'rslt'=>$query_result,'error'=>[]);
	}

	//GET BANK FOR BOTH COLLMAN & CINCO
	public function get_bank($fromDb){
		$fromDb = strtoupper($fromDb);
		//SELECT prime_bank_name_id AS bankId,bank_name AS bankName FROM cw_bank_name
		
		$query  = 'SELECT "'.$fromDb.'" AS fromDb, prime_bank_name_id AS bankId,bank_name AS bankName,trans_status as transSts FROM cw_bank_name';
		$query_info     = $this->runQuery($query);
		$query_result   = $this->result($query_info);
		$sts = false;
		$msg = "No portfolio data found";
		if($query_result){
			$sts = true;
			$msg = $fromDb ." portfolio data";
		}
		return array('sts'=>$sts,'msg'=>$msg,'rslt'=>$query_result,'error'=>[]);
	}

}
?>