<?php
class Model_MInvestorGlobalSettings
{
	var $output 			= array();

	function getAutomatedTradeStatus(){
		$query				= new Bin_Query();
		$sql 				= "SELECT * FROM organisation_details WHERE ".
							" user_id= '".$_SESSION['user']['userid']."' LIMIT 1";
		$query->executeQuery($sql);
		$trade				= $query->records;
		
		return $trade[0];
	}
	
	function updateTrading($post){
		$query				= new Bin_Query();
		$sql 				= "UPDATE `organisation_details` SET `auto_trade` = '".$post['status']."' ".
							" WHERE user_id= '".$_SESSION['user']['userid']."' LIMIT 1 ;";
		$query->updateQuery($sql);
		
		return true;
	}
	
	function getNotificationEmail(){
		
		$query				= new Bin_Query();
		$sql 				= "SELECT a.* FROM `temp_registration` as r , address_details as a ".
							" WHERE r.user_id= '".$_SESSION['user']['userid']."' && a.address_id = organization_address_id LIMIT 1";
		$query->executeQuery($sql);
		$email				= $query->records[0];
		
		return $email;
	}
	
	function getNotificationSetting(){
		
		$query				= new Bin_Query();
		$sql 				= "SELECT * FROM `user_notification_setting` WHERE user_id= '".$_SESSION['user']['userid']."' LIMIT 1";
		$query->executeQuery($sql);
		$records			= $query->records[0];
		return $records;
	}
	
	
	
	
	function updateNotification($post){
		
		
		 
		$query				= new Bin_Query();
		$sql 				= "SELECT * FROM `user_notification_setting` WHERE ".
							" user_id= '".$_SESSION['user']['userid']."' LIMIT 1";
		$query->executeQuery($sql);
		$trade				= $query->records;
		
		if(count($trade) > 0){
		
			$query				= new Bin_Query();
			$sql 				= "UPDATE `user_notification_setting` SET 
								`trading_open` = '".$post['trading_open']."',
								`trading_day` = '".$post['trading_day']."',
								`four_hour_close` = '".$post['four_hour_close']."',
								`one_hour_close` = '".$post['one_hour_close']."',
								`thirty_min_close` = '".$post['thirty_min_close']."',
								`fifteen_min_close` = '".$post['fifteen_min_close']."',
								`stalled` = '".$post['stalled']."',
								`won` = '".$post['won']."',
								`lost` = '".$post['lost']."',
								`mail_format` = '".$post['mail_format']."',
								`modified_at` = NOW(),
								`modified_by` = '".$_SESSION['user']['userid']."'
								WHERE user_id= '".$_SESSION['user']['userid']."' LIMIT 1 ;";
			$query->updateQuery($sql);
				
		}else{
			$query				= new Bin_Query();
			$sql 				= "INSERT INTO `user_notification_setting` (
								`user_id` ,				  `organisation_id` ,			 `trading_open` ,
								`trading_day` ,			  `four_hour_close` ,			`one_hour_close`,
								`thirty_min_close` ,	`fifteen_min_close` ,				  `stalled` ,						
								`won` ,								 `lost` ,			  `mail_format` ,			
								`modified_at` ,				  `modified_by`
								)
								VALUES (
								'".$_SESSION['user']['userid']."', 							  '0', 	  '".$post['trading_open']."', 
								'".$post['trading_day']."', 	  '".$post['four_hour_close']."',   '".$post['one_hour_close']."', 
								'".$post['thirty_min_close']."', '".$post['fifteen_min_close']."', 		   '".$post['stalled']."',
								'".$post['won']."', 						  '".$post['lost']."',     '".$post['mail_format']."',
								NOW(), 							'".$_SESSION['user']['userid']."'
								)";	
			$query->updateQuery($sql);
		}
		
		return true;
	}
	
	function getNaceCategory(){

		$query				= new Bin_Query();
		$sql 				= "SELECT g.*, c.nace_group FROM `category_group` as g, categories as c WHERE ".
							" g.nace_group_id !='' && c.nace_group_id = g.nace_group_id GROUP BY g.nace_group_id ";
		$query->executeQuery($sql);
		$records				= $query->records;
		
		return  Display_DInvestorGlobalSettings::displayTradeNace($records);
	}
	
	function getMasterDebtor(){
		
		$query				= new Bin_Query();
		$sql 				= "SELECT * FROM debtors_master ORDER BY debtor_name ASC ";
		$query->executeQuery($sql);
		$records			= $query->records;
		
		return  Display_DInvestorGlobalSettings::displayMasterDebtors($records);
	}
	
	function getTraderOrganisation(){
		
		$query				= new Bin_Query();
		$sql				= "SELECT org.* ".
							" FROM organisation_details as org , temp_registration as t WHERE ".
							" (t.user_type='3' OR t.user_type='4') && org.user_id = t.user_id GROUP BY org.organisation_id ";
		$query->executeQuery($sql);
		$records				= $query->records;
		
		return  Display_DInvestorGlobalSettings::displayTraderOrganisation($records);
	}
}
?>