<?php
class GlobalSharing{
	var $id;
	private $db;
	private $username, $email;
	
	function __construct(){
		global $db, $username, $usermail;
		$this->db = $db;		
		$this->username = $username;	
		$this->email = $usermail;		
	}	
	function setId($id){
		$this->id = $id;
	}
	
	function getGlobalSharingDetail(){
		$sqls = array();
		$dbdata = array();
		if (!empty($this->id)){
			array_push($sqls,'d.gs_id = \''.$this->id.'\'');
		}
		
		$sql = '';
		if (sizeof($sqls) > 0){
			$sql = ' WHERE '.implode(' AND ',$sqls);
		}
		$dbdata = $this->db->fetch_one("SELECT d.* FROM global_sharing d".$sql);

		return $dbdata;
	}
	
	function getNumber($year){
		$theids = '';
		$valid = 'global_sharing';
		if (!empty($year)){
			$getpoint = $this->db->fetch_one("SELECT number_val FROM number_setup WHERE number_tag = '".$this->db->clean($valid)."' AND year = '".$this->db->clean($year)."'");
			if (!empty($getpoint['number_val'])){
				$theids = $getpoint['number_val'] + 1;
				$this->db->query("UPDATE number_setup SET number_val = '".$this->db->clean($theids)."' WHERE number_tag = '".$this->db->clean($valid)."' AND year = '".$this->db->clean($year)."'");
			}
			else{
				$theids = 1;
				$inserts['number_tag'] = $valid;
				$inserts['number_val'] = $theids;
				$inserts['year'] = $year;
				$this->db->insert("number_setup",$inserts);
			}
		}
		
		return $theids;
	}

	function saveGlobalSharing($amount){	
		global $userid, $yearnow, $monthnow, $transactionsetting;
		
		$lastnumber = $this->getNumber($yearnow);
		$totaldigit = empty($transactionsetting['autonumberdigit'])?0:$transactionsetting['autonumberdigit'];
		
		$inserts['transaction_number'] = 'GS/'.$yearnow.'/'.$monthnow.'/'.str_pad($lastnumber,$totaldigit,"0",STR_PAD_LEFT);
		$inserts['date'] = date('Y-m-d');
		$inserts['amount'] = $amount;
		$inserts['created_by'] = $userid;
		$inserts['created_date'] = 'now()';
		
 		$lastid = $this->db->insert("global_sharing",$inserts);	
		return $lastid;		
	}
	
	function saveGlobalSharingHistory($transactionnumber, $nominal, $userid){
		$inserts['transactionnumber'] = $transactionnumber;
		$inserts['transaction_type'] = 'global_sharing';
		$inserts['notes'] = 'Global Sharing';
		$inserts['transactiondate'] = 'now()';
		$inserts['nominal'] = $nominal;
		$inserts['userid'] = $userid;
				
		$this->db->insert("transaction_history", $inserts);	
		return true;		
	}

	
	
	
}
?>