<?php
if (! defined ( 'sugarEntry' ) || ! sugarEntry)
	die ( 'Not A Valid Entry Point' );
/**
 * ***************************************************************************
 * The contents of this file are subject to the RECIPROCAL PUBLIC LICENSE
 * Version 1.1 ("License"); You may not use this file except in compliance
 * with the License.
 * You may obtain a copy of the License at
 * http://opensource.org/licenses/rpl.php. Software distributed under the
 * License is distributed on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND,
 * either express or implied.
 *
 * You may:
 * a) Use and distribute this code exactly as you received without payment or
 * a royalty or other fee.
 * b) Create extensions for this code, provided that you make the extensions
 * publicly available and document your modifications clearly.
 * c) Charge for a fee for warranty or support or for accepting liability
 * obligations for your customers.
 *
 * You may NOT:
 * a) Charge for the use of the original code or extensions, including in
 * electronic distribution models, such as ASP (Application Service
 * Provider).
 * b) Charge for the original source code or your extensions other than a
 * nominal fee to cover distribution costs where such distribution
 * involves PHYSICAL media.
 * c) Modify or delete any pre-existing copyright notices, change notices,
 * or License text in the Licensed Software
 * d) Assert any patent claims against the Licensor or Contributors, or
 * which would in any way restrict the ability of any third party to use the
 * Licensed Software.
 *
 * You must:
 * a) Document any modifications you make to this code including the nature of
 * the change, the authors of the change, and the date of the change.
 * b) Make the source code for any extensions you deploy available via an
 * Electronic Distribution Mechanism such as FTP or HTTP download.
 * c) Notify the licensor of the availability of source code to your extensions
 * and include instructions on how to acquire the source code and updates.
 * d) Grant Licensor a world-wide, non-exclusive, royalty-free license to use,
 * reproduce, perform, modify, sublicense, and distribute your extensions.
 *
 * The Original Code is: CommuniCore
 * Olavo Farias
 * 2006-04-7 olavo.farias@gmail.com
 *
 * The Initial Developer of the Original Code is CommuniCore.
 * Portions created by CommuniCore are Copyright (C) 2005 CommuniCore Ltda
 * All Rights Reserved.
 * ******************************************************************************
 */
require_once ('data/SugarBean.php');
require_once ('include/utils.php');
class EcmInsideOrder extends SugarBean {
	var $field_name_map = array ();
	// STANDARD FIELDS
	var $id;
	var $date_entered;
	var $date_modified;
	var $modified_user_id;
	var $assigned_user_id;
	var $name;
	var $description;
	var $number;
	var $document_no;
	var $register_date;
	var $total;
	var $position_list;
	var $created_by;
	var $created_by_name;
	var $modified_by_name;
	var $assigned_user_name;
	var $pw_stock_id;
	var $rw_stock_id;
	// SUBPANELS RELATED
	// MODULE OBJECT DETAILS
	var $module_dir = "EcmInsideOrders";
	var $table_name = "ecminsideorders";
	var $object_name = "EcmInsideOrder";
	// RELATED TABLE NAMES
	// USED TO RETRIEVE RELATED FIELDS FROM FORM POSTS.
	var $additional_column_fields = Array (
			'assigned_user_name',
			'assigned_user_id',
			'modified_user_id',
			'created_by' 
	);
	// RELATIONSHIP FIELDS
	var $relationship_fields = Array (
			'note_id' => 'notes',
		);
	function EcmInsideOrder() {
		parent::SugarBean ();
		$this->setupCustomFields ( 'EcmInsideOrders' );
		foreach ( $this->field_defs as $field ) {
			$this->field_name_map [$field ['name']] = $field;
		}
	}
	var $new_schema = true;
	function get_summary_text() {
		return "$this->name";
	}
	function create_list_query($order_by, $where, $show_deleted = 0) {
		// Fill in the assigned_user_name
		$custom_join = $this->custom_fields->getJOIN ();
		$query = "SELECT ";
		$query .= "ecminsideorders.*
                  ,users.user_name as assigned_user_name";
		if ($custom_join) {
			$query .= $custom_join ['select'];
		}
		$query .= " FROM ecminsideorders 
                   LEFT JOIN users
                   ON ecminsideorders.assigned_user_id=users.id";
		$query .= "  ";
		if ($custom_join) {
			$query .= $custom_join ['join'];
		}
		$where_auto = '1=1';
		if ($show_deleted == 0) {
			$where_auto = " $this->table_name.deleted=0 ";
		} else if ($show_deleted == 1) {
			$where_auto = " $this->table_name.deleted=1 ";
		}
		if ($where != "")
			$query .= "where $where AND " . $where_auto;
		else
			$query .= "where " . $where_auto;
		if (substr_count ( $order_by, '.' ) > 0) {
			$query .= " ORDER BY $order_by";
		} else if ($order_by != "")
			$query .= " ORDER BY $order_by";
		else
			$query .= " ORDER BY ecminsideorders.name";
		return $query;
	}
	function create_export_query($order_by, $where) {
		$custom_join = $this->custom_fields->getJOIN ();
		$query = "SELECT
                      ecminsideorders.*,
                      users.user_name assigned_user_name";
		if ($custom_join) {
			$query .= $custom_join ['select'];
		}
		$query .= " FROM ecminsideorders ";
		$query .= " LEFT JOIN users
                  ON ecminsideorders.assigned_user_id=users.id";
		if ($custom_join) {
			$query .= $custom_join ['join'];
		}
		$query .= "";
		$where_auto = " ecminsideorders.deleted=0 
                    ";
		if ($where != "")
			$query .= " where $where AND " . $where_auto;
		else
			$query .= " where " . $where_auto;
		if ($order_by != "")
			$query .= " ORDER BY $order_by";
		else
			$query .= " ORDER BY ecminsideorders.name";
		return $query;
	}
	function fill_in_additional_list_fields() {
	}
	function fill_in_additional_detail_fields() {
		// FILL IN THE ASSIGNED_USER_NAME
		$this->assigned_user_name = get_assigned_user_name ( $this->assigned_user_id );
		$this->created_by_name = get_assigned_user_name ( $this->created_by );
		$this->modified_by_name = get_assigned_user_name ( $this->modified_user_id );
	}
	function get_list_view_data() {
		global $current_language;
		$this->fill_in_additional_detail_fields ();
		$app_list_strings = return_app_list_strings_language ( $current_language );
		$mod_strings = return_module_language ( $current_language, 'EcmInsideOrders' );
		$the_array = parent::get_list_view_data ();
		//get stocks
		$prod=$this->ecmproduct_id;
		$this->retrieve($this->id);
		if($prod!=''){
		    //add subpanel data
		    $tmp=$this->getPriceFromDocument($prod);
		     
		    $the_array ['QUANTITY'] = format_number ( $tmp['quantity'] );
		    $the_array ['PRICE_NETTO'] = format_number ( $tmp['price_netto'] );
		    $the_array ['TOTAL_NETTO'] = format_number ( $tmp['total_netto'] );
		    if($tmp['product_component']==0){
		        $the_array ['COMPONENT']='Nie';
		    } else {
		        $the_array ['COMPONENT']='Tak';
		    }
		    
		    $pw = new EcmStockDocInsideIn();
		    $pw->retrieve($this->pw_id);
		    $the_array ['PW_NAME'] = '<a href="index.php?module=EcmStockDocInsideIns&action=DetailView&record='.$this->pw_id.'&offset=1">'.$pw->document_no.'</a>';
		    $rw = new EcmStockDocInsideOut();
		    $rw->retrieve($this->rw_id);
		    $the_array ['RW_NAME'] = '<a href="index.php?module=EcmStockDocInsideOuts&action=DetailView&record='.$this->rw_id.'&offset=1">'.$rw->document_no.'</a>';
		}
		
		
		if($this->rw_id=='' && $this->pw_id==''){
		    $the_array['PTASZEK']='<img width="13" src="modules/EcmInvoiceOuts/images/cancel.png">';
		} else {
		   $the_array['PTASZEK']='<img title="Zaakceptowana" src="modules/EcmInvoiceOuts/images/accepted.gif">';
		}
		$the_array['STOCK_OUT_NAME'] = $this->stock_out_name;
		$the_array['STOCK_IN_NAME'] = $this->stock_in_name;
		$the_array['NUMBER']='<a href="index.php?module=EcmInsideOrders&action=DetailView&record='.$this->id.'&offset=1">'.$this->document_no.'</a>';
		//create image options
		$op = '<a href="index.php?module=EcmInsideOrders&action=createPDF&to_pdf=1&record='.$this->id.'" target="new"/><img src="modules/EcmInsideOrders/images/pdf.gif"/></a>';
		$the_array['OPTIONS'] = $op;

		return $the_array;
	}
	function getPriceFromDocument($product){
	
	    $zap=$this->db->query("select quantity,product_component from ecminsideorderitems where  id='".$product."'");
	    $dane=$this->db->fetchByAssoc($zap);
	    return $dane;
	}
	function getStatusMenuInfo($inJSON = true) {
		global $app_list_strings;
		$arr = array ();
		foreach ( $app_list_strings ['ecminsideorders_status_dom'] as $key => $value ) {
			$arr [$key] = array (
					'enabled' => '<div><img src="modules/EcmInsideOrders/images/' . $key . '.gif" />' . $value . '</div>',
					'disabled' => '<div><img src="modules/EcmInsideOrders/images/' . $key . '.gif" />' . $value . '</div>' 
			);
		}
		$json = getJSONobj ();
		if ($inJSON)
			return str_replace ( '&quot;', '\"', $json->encode ( $arr ) );
		else
			return $arr;
	}
	function create_new_list_query($order_by, $where, $filter = array(), $params = array(), $show_deleted = 0, $join_type = '', $return_array = false, $parentbean, $singleSelect = false) {
		echo '<script type="text/javascript" src="include/ECM/EcmPreviewPDF/EcmPreviewPDF.js"></script>';
		echo '<script type="text/javascript" src="modules/EcmInsideOrders/ListView.js"></script>';
		echo '<link rel="stylesheet" type="text/css" href="modules/EcmInsideOrders/ListView.css" />';
		echo '<script language="javascript"> var EcmInsideOrdersStatusMenu = ' . $this->getStatusMenuInfo () . '; </script>';
		return parent::create_new_list_query ( $order_by, $where, $filter, $params, $show_deleted, $join_type, $return_array, $parentbean, $singleSelect );
	}
	static function CreateImgStatus($id, $status) {
		global $app_list_strings;
		return '<span id="statusListEcmInsideOrder_' . $id . '" style="display:inline;"><img src="modules/EcmInsideOrders/images/' . $status . '.gif" title="' . $app_list_strings ['ecminsideorders_status_dom'] [$status] . '" /></span>';
	}
	
	/**
	 * BUILDS A GENERIC SEARCH BASED ON THE QUERY STRING USING OR.
	 * DO NOT INCLUDE ANY $THIS-> BECAUSE THIS IS CALLED ON WITHOUT HAVING THE CLASS INSTANTIATED.
	 */
	function build_generic_where_clause($the_query_string) {
		$where_clauses = Array ();
		$the_query_string = PearDatabase::quote ( from_html ( $the_query_string ) );
		array_push ( $where_clauses, "ecminsideorders.name like '$the_query_string%'" );
		$the_where = "";
		foreach ( $where_clauses as $clause ) {
			if ($the_where != "")
				$the_where .= " or ";
			$the_where .= $clause;
		}
		return $the_where;
	}
	function set_notification_body($xtpl, $simplemodule) {
		global $mod_strings, $app_list_strings;
		$xtpl->assign ( "NAME", $simplemodule->name );
		$xtpl->assign ( "DESCRIPTION", $simplemodule->description );
		return $xtpl;
	}
	function bean_implements($interface) {
		switch ($interface) {
			case 'ACL' :
				return true;
		}
		return false;
	}
	
	
	function save($check_notify = FALSE) {
		global $current_user;
		// generate number
		if($this->id==''){
		$this->number = $this->generateNumber();
		$this->document_no = $this->formatNumber($this->number);
		}
		$return_id = parent::save ( $check_notify );
		$this->savePositions($return_id);
		
		//update total
		$db = $GLOBALS['db'];
		$r = $db->fetchByAssoc($db->query("SELECT sum(total) as sum FROM ecminsideorderitems WHERE ecminsideorder_id='$this->id' and deleted='0'"));
		$db->query("UPDATE ecminsideorders SET total='".$r['sum']."' WHERE id='$this->id'");
		
		return $return_id;
	}
	// ***************************Start Managing Positions*************************//
	function constructInsertQuery($data, $table = '') {
		if ($table == '' && isset ( $this->object_name ) && $this->object_name != '') {
			$table = strtolower ( $this->object_name ) . "items";
		} else
			return "";
		$keys = array ();
		$values = array ();
		foreach ( $data as $key => $value ) {
			$keys [] = $key;
			if (is_array ( $value ))
				$values [] = $value [1] . str_replace ( "'", "\'", $value [0] ) . $value [1];
			else
				$values [] = "'" . str_replace ( "'", "\'", $value ) . "'";
		}
		$q = "insert into `$table` (`";
		$q .= implode ( '`, `', $keys );
		$q .= "`) values (";
		$q .= implode ( ", ", $values );
		$q .= ");";
		
		$GLOBALS['db']->query("INSERT INTO log VALUES ('".mysql_real_escape_string($q)."')");
		return $q;
	}
	function savePositions($id = null, $position_list = null) {
		global $current_user, $timedate;
		if ($position_list == null)
			$position_list = $this->position_list;
		if ($id == null)
			$id = $this->id;
		if (count ( $position_list ) > 0)
			$this->deleteAssignedPositions ( $id );
		$arr = array ();
		$position = 0;
		
		for($i = 0; $i < count ( $position_list ); $i ++) {
			if ($position_list [$i] ['name'] == '')
				continue;
			$p = $position_list [$i];
			
			require_once ("modules/EcmProducts/EcmProduct.php");
			$pr = new EcmProduct ();
			$pr->retrieve ( $p ['product_id'] );
			$p ['category_id'] = $pr->product_category_id;
			unset($pr);
			$item_id = create_guid();
			$arr = array (
					'id' => $item_id,
					'date_entered' => array (
							'NOW()',
							'' 
					),
					'date_modified' => array (
							'NOW()',
							'' 
					),
					'modified_user_id' => $current_user->id,
					'assigned_user_id' => $current_user->id,
					'created_by' => $current_user->id,
					'deleted' => '0',
					strtolower ( $this->object_name ) . '_id' => $id,
					'ecmproduct_id' => $p ['product_id'],
					'position' => $position,
					'code' => $p ['product_code'],
					'name' => $p ['name'],
			        'product_product_id'=>$p ['product_product_id'], 
			        'product_component'=>$p ['product_component'],
					'quantity' => ((empty ( $p ['quantity'] ) || $p ['quantity'] == '') ? 0 : $p ['quantity']),
			        'quantity_comp' => ((empty ( $p ['quantity_comp'] ) || $p ['quantity_comp'] == '') ? 0 : $p ['quantity_comp']),
					'dd_unit_id' => $p ['unit_id'],
					'dd_unit_name' => $p['unit_name'],
					'ecmproductcategory_id' => $p ['category_id'],
			);
			$this->db->query ( $this->constructInsertQuery ( $arr ) );
			//add to stock
			//$this->addProducts($arr,$id,$item_id);
			$position ++;
		}
	}
	function getPosition($position,$stockId) {
	    
		if (! is_array ( $position ))
			return '';
		global $timedate;
		$return_array = array ();
		$return_array ['product_id'] = $position ['ecmproduct_id'];
		$return_array ['position'] = $position ['position'];
		$return_array ['product_code'] = $position ['code'];
		$return_array ['product_product_id'] = $position ['product_product_id'];
		$return_array ['product_component'] = $position ['product_component'];
		$return_array ['name'] = $position ['name'];
		$return_array ['quantity'] = $position ['quantity'];
		$return_array ['quantity_comp'] = $position ['quantity_comp'];
		$return_array ['price'] = $position ['price'];
		$return_array ['total'] = $position ['total'];
		$return_array ['unit_id'] = $position ['dd_unit_id'];
		$return_array ['unit_name'] = $position ['dd_unit_name'];
		$return_array['ecmproductcategory_id'] = $position ['ecmproductcategory_id'];
		if($stockId!=''){
		    $stocks = explode(",", $stockId);
		    if($return_array ['product_component']==1)$checkId= $stocks[0];
		    if($return_array ['product_component']==0)$checkId= $stocks[1];

		    $return_array['stock_state'] = $tmp['stock_state'] = EcmStockOperation::getStock($position['ecmproduct_id'], $checkId);
		} else {
		    if($return_array ['product_component']==1)$checkId= $this->rw_stock_id;
		    if($return_array ['product_component']==0)$checkId= $this->pw_stock_id;
		    
		    $return_array['stock_state'] = $tmp['stock_state'] = EcmStockOperation::getStock($position['ecmproduct_id'], $checkId);
		}
		
		return $return_array;
	}
	function getPositionList($array = false,$stockId) {
		if (isset ( $this->id ) && $this->id != '') {
			$query = "SELECT * FROM `" . strtolower ( $this->object_name ) . "items` WHERE `" . strtolower ( $this->object_name ) . "_id`='" . $this->id . "' order by position asc";
			$r = $this->db->query ( $query );
			$return_array = array ();
			if ($r) {
				while ( $w = $this->db->fetchByAssoc ( $r ) ) {
					$return_array [] = $this->getPosition ( $w,$stockId);
				}
				$json = getJSONobj ();
				return $array ? $return_array : $json->encode ( $return_array );
			}
		}
		return $array ? false : '[]';
	}
	
	function getPosition2($position) {
	     
	    if (! is_array ( $position ))
	        return '';
	    global $timedate;
	    $return_array = array ();
	    $return_array ['product_id'] = $position ['ecmproduct_id'];
	    $return_array ['position'] = $position ['position'];
	    $return_array ['product_code'] = $position ['code'];
	    $return_array ['product_product_id'] = $position ['product_product_id'];
	    $return_array ['product_component'] = $position ['product_component'];
	    $return_array ['name'] = $position ['name'];
	    $return_array ['quantity'] = $position ['quantity'];
	    $return_array ['quantity_comp'] = $position ['quantity_comp'];
	    $return_array ['price'] = $position ['price'];
	    $return_array ['total'] = $position ['total'];
	    $return_array ['unit_id'] = $position ['dd_unit_id'];
	    $return_array ['unit_name'] = $position ['dd_unit_name'];
	    $return_array['ecmproductcategory_id'] = $position ['ecmproductcategory_id'];

	        if($return_array ['product_component']==1)$checkId= $this->rw_stock_id;
	        if($return_array ['product_component']==0)$checkId= $this->pw_stock_id;
	
	        $return_array['stock_state'] = $tmp['stock_state'] = EcmStockOperation::getStock($position['ecmproduct_id'], $checkId);

	    return $return_array;
	}


	function getPositionList2($array = false,$count) {
	    if (isset ( $this->id ) && $this->id != '') {
	        $query = "SELECT * FROM `" . strtolower ( $this->object_name ) . "items` WHERE `" . strtolower ( $this->object_name ) . "_id`='" . $this->id . "' order by position asc";
	        $r = $this->db->query ( $query );
	        $return_array = array ();
	        $same=array();
	        
	        $i=0;
	        if ($r) {
	            while ( $w = $this->db->fetchByAssoc ( $r ) ) {

	                $return_array [] = $this->getPosition2 ( $w);
	                /*
	               
	                */
	               $i++;
	            }
	            $count=0;
	           foreach($return_array as $k=>$v){
	               
                    $dup=0;
                    $ile=1;
	                   foreach($same as $k2=>$v2){
	                       if($same[$k2]['product_id']==$return_array [$k]['product_id']){
	                       $same[$k2]['quantity']+=$return_array [$k]['quantity'];
	                       $dup=1;
	                       $ile++;
	                       $same[$k2]['ile']=$ile;
	                       }
	                   }
	                   if($dup==0){
	                   $same[$count]['product_id']=$return_array [$k]['product_id'];
	                   $same[$count]['name']=$return_array [$k]['name'];
	                   $same[$count]['product_code']=$return_array [$k]['product_code'];
	                   $same[$count]['quantity']=$return_array [$k]['quantity'];
	                   $same[$count]['product_component']=$return_array [$k]['product_component'];
	                   $same[$count]['ecmproductcategory_id']=$return_array [$k]['ecmproductcategory_id'];
	                   }
	                   $count++;
	               }
	               foreach($same as $k2=>$v2){
	                   if($same[$k2] ['product_component']==1)$checkId= $this->rw_stock_id;
	                   if($same [$k2]['product_component']==0)$checkId= $this->pw_stock_id;
	                   
	                   $same[$k2]['stock_state'] = $tmp['stock_state'] = EcmStockOperation::getStock($same[$k2]['product_id'], $checkId);
	               }
	               $return_array=$same;
	            $json = getJSONobj ();
	            return $array ? $return_array : $json->encode ( $return_array );
	        }
	    }
	    return $array ? false : '[]';
	}
	
	function deleteAssignedPositions() {
		if (isset ( $this->id ) && $this->id != '') {
			$query = "DELETE FROM `" . strtolower ( $this->object_name ) . "items` WHERE `" . strtolower ( $this->object_name ) . "_id`='" . $this->id . "'";
			$r = $this->db->query ( $query );
			if ($r)
				return true;
		}
		return false;
	}
	function formatPositions($position_list) {
		return;
		if (! is_array ( $position_list ) || count ( $position_list ) == 0)
			return false;
		global $app_list_strings;
		require_once ('modules/Currencies/Currency.php');
		foreach ( $position_list as $key => $value ) {
			$position_list [$key] ['unit_id'] = $app_list_strings ['ecmproducts_unit_dom'] [$value ['unit_id']];
			$position_list [$key] ['category_id'] = $app_list_strings ['ecmproducts_category_dom'] [$value ['category_id']];
			// $position_list[$key]['vat_id'] = format_number($value['vat_id']).'%';
			$position_list [$key] ['discount'] = format_number ( $value ['discount'] ) . '%';
			if (isset ( $currency ) && ($currency->id == $this->currency_id)) {
			} else {
				$currency = new Currency ();
				$currency->retrieve ( $this->currency_id );
			}
			$position_list [$key] ['price'] = format_number ( $value ['price'] ) . ' ' . $currency->iso4217;
			$position_list [$key] ['total'] = format_number ( $value ['total'] ) . ' ' . $currency->iso4217;
			// $position_list[$key]['price'] = format_number($value['price']).' PLN';
			// $position_list[$key]['total'] = format_number($value['total']).' PLN';
			$this->currency_symbol = $currency->iso4217;
		}
		return $position_list;
	}
	// ***************************End Managing Positions*************************//
	//begin stock
	function addProducts($p,$id,$itemid){
		$arr=array();
		$w=$GLOBALS['db']->query("select quantity as qty,id,price from ecmstockoperations where deleted='0' and type='0' and in_id IS NULL and stock_id='".$this->stock_out_id."' and product_id='".$p['ecmproduct_id']."' and used='0'");
		while($rrr=$GLOBALS['db']->fetchByAssoc($w)){
			$ww=$GLOBALS['db']->query("select quantity from ecmstockoperations where in_id='".$rrr['id']."' and type='1' and in_id IS NOT NULL and stock_id='".$this->stock_out_id."' and product_id='".$p['ecmproduct_id']."' and deleted='0'");
			$rqty=0;
			while($rrp=$GLOBALS['db']->fetchByAssoc($ww)){
				$rqty+=$rrp['quantity'];
			}
			$qty=$rrr['qty']-$rqty;
			if($qty>0){
				$arr[]=array("qty"=>$qty,"id"=>$rrr['id'],"price"=>$rrr['price']);
			}
		}
		$rr=array();
		$used_qty=0;
		$stop=0;
		foreach($arr as $value){
			if($p['quantity']-$used_qty<=$value['qty']){
				$rr[]=array("id"=>$value['id'],"qty"=>$p['quantity']-$used_qty,"price"=>$value['price']);
				$stop=1;
			}
			else{
				$rr[]=array("id"=>$value['id'],"qty"=>$value['qty'],"price"=>$value['price']);
				$used_qty+=$value['qty'];
			}
			if($stop){
				$stop=0;
				break;
			}
		}
		$avg_pq=0;
		$avg_q=0;
		foreach($rr as $r){
				$this->addProductToStockOut($r['id'],$p['ecmproduct_id'],$r['qty'],$r['price'],$this->register_date,$id,$this->stock_out_id,$itemid);
				$this->addProductToStockTo($r['id'],$p['ecmproduct_id'],$r['qty'],$r['price'],$this->register_date,$id,$this->stock_in_id,$itemid);
				$avg_pq+=$r['qty']*$r['price'];
				$avg_q+=$r['qty'];
		}
		$GLOBALS['db']->query("update ecminsideorderitems set price='".($avg_pq/$avg_q)."',total='".$avg_pq."' where id='".$itemid."'");
	}	
	function addProductToStockOut($pw_stock_id,$product_id,$quantity,$price,$date,$mm_id,$stock_id,$itemid)
	{
		require_once("modules/EcmStockOperations/EcmStockOperation.php");
		$o=new EcmStockOperation();
		$o->unformat_all_fields();
	
		require_once("modules/EcmProducts/EcmProduct.php");
		$o->product_id=$product_id;
		$p=new EcmProduct();
		$p->retrieve($product_id);
		$o->product_code=$p->code;
		$o->product_name=$p->name;
	
		require_once("modules/EcmStocks/EcmStock.php");
		$o->stock_id=$stock_id;
		$s=new EcmStock();
		$s->retrieve($stock_id);
		$o->stock_name=$s->name;
	
		$o->parent_id=$mm_id;
		$r=$GLOBALS['db']->fetchByAssoc($GLOBALS['db']->query("select document_no from ecminsideorders where id='".$mm_id."'"));
		$o->parent_name=$r['document_no'];
		$o->parent_type="EcmInsideOrders";
	
		$o->quantity=$quantity;
		$o->price=$price;
		$o->in_id=$pw_stock_id;
		$o->documentitem_id=$itemid;
		$o->type=1;
		$oid=$o->save();
		$GLOBALS['db']->query("update ecmstockoperations set price='".$price."' where id='".$oid."'");
	
		require_once("modules/EcmStockStates/EcmStockState.php");
		$ss=new EcmStockState();
		$ss->UpdateStockState($o->stock_id,$o->product_id);
	}
	function addProductToStockTo($pw_stock_id,$product_id,$quantity,$price,$date,$mm_id,$stock_id,$itemid)
	{
		require_once("modules/EcmStockOperations/EcmStockOperation.php");
		$o=new EcmStockOperation();
		$o->unformat_all_fields();
	
		require_once("modules/EcmProducts/EcmProduct.php");
		$o->product_id=$product_id;
		$p=new EcmProduct();
		$p->retrieve($product_id);
		$o->product_code=$p->code;
		$o->product_name=$p->name;
	
		require_once("modules/EcmStocks/EcmStock.php");
		$o->stock_id=$stock_id;
		$s=new EcmStock();
		$s->retrieve($stock_id);
		$o->stock_name=$s->name;
	
		$o->parent_id=$mm_id;
		$r=$GLOBALS['db']->fetchByAssoc($GLOBALS['db']->query("select document_no from ecminsideorders where id='".$mm_id."'"));
		$o->parent_name=$r['document_no'];
		$o->parent_type="EcmInsideOrders";
	
		$o->quantity=$quantity;
		$o->price=$price;
		$o->documentitem_id=$itemid;
		$o->type=0;
		$oid=$o->save();
		$GLOBALS['db']->query("update ecmstockoperations set price='".$price."' where id='".$oid."'");
	
		require_once("modules/EcmStockStates/EcmStockState.php");
		$ss=new EcmStockState();
		$ss->UpdateStockState($o->stock_id,$o->product_id);
	}
	//end stock
	function ACLAccess($view, $is_owner = 'not_set') {
		global $current_user;
		$file = 'modules/EcmGroupSales/EcmGroupSale.php';
		if (file_exists ( $file )) {
			require_once ($file);
			$cc = EcmGroupSale::loadSettings ( true );
		} else
			return true;
		if (is_admin ( $current_user )) {
			switch ($view) {
				case 'confirming' :
					return ($this->status == "s20");
				case 'send_to_confirm' :
					return ($this->status == "s10");
				case 'pdf_toolbar' :
					return ($this->status != "s10" && $this->status != "s20" && $this->status != "s40");
			}
			return true;
		}
		if ($is_owner == 'not_set') {
			$is_owner = $this->isOwner ( $current_user->id );
		}
		// if we don't implent acls return true
		if (! $this->bean_implements ( 'ACL' ))
			return true;
		$view = strtolower ( $view );
		if ($cc ['user_manager_role']) { // Manager
			switch ($view) {
				case 'list' :
				case 'index' :
				case 'listview' :
					return ACLController::checkAccess ( $this->module_dir, 'list', true );
				case 'edit' :
				case 'save' :
				case 'popupeditview' :
				case 'editview' :
					return (ACLController::checkAccess ( $this->module_dir, 'edit', $is_owner ));
				case 'view' :
				case 'detail' :
				case 'detailview' :
					return ACLController::checkAccess ( $this->module_dir, 'view', $is_owner );
				case 'delete' :
					return ACLController::checkAccess ( $this->module_dir, 'delete', $is_owner );
				case 'export' :
					return ACLController::checkAccess ( $this->module_dir, 'export', $is_owner );
				case 'import' :
					return ACLController::checkAccess ( $this->module_dir, 'import', true );
				case 'send_to_confirm' :
					return ($this->status == "s10");
				case 'can_commit' :
					return true;
				case 'confirming' :
					return ($this->status == "s20");
				case 'auto_commiting' :
					return true;
				case 'pdf_toolbar' :
					return ($this->status != "s10" && $this->status != "s20" && $this->status != "s40");
			}
		} else if ($cc ['user_representative_extra_role']) { // Representative Extra
			switch ($view) {
				case 'list' :
				case 'index' :
				case 'listview' :
					return ACLController::checkAccess ( $this->module_dir, 'list', true );
				case 'edit' :
					return (ACLController::checkAccess ( $this->module_dir, 'edit', $is_owner ) && ($this->status == "s10" || $this->status == "s40"));
				case 'save' :
				case 'popupeditview' :
				case 'editview' :
					return (ACLController::checkAccess ( $this->module_dir, 'edit', $is_owner ));
				case 'view' :
				case 'detail' :
				case 'detailview' :
					return ACLController::checkAccess ( $this->module_dir, 'view', $is_owner );
				case 'delete' :
					return (ACLController::checkAccess ( $this->module_dir, 'delete', $is_owner ) && $this->status == "s10");
				case 'export' :
					return ACLController::checkAccess ( $this->module_dir, 'export', $is_owner );
				case 'import' :
					return ACLController::checkAccess ( $this->module_dir, 'import', true );
				case 'quote_to_sale' :
				case 'quote_to_invoice' :
					return ($this->status != "s10" && $this->status != "s20" && $this->status != "s40" && $this->status != "s60");
				case 'send_to_confirm' :
					return ($this->status == "s10");
				case 'send_email' :
					return ($this->status != "s10" && $this->status != "s20" && $this->status != "s40");
				case 'can_commit' :
					return true;
				case 'confirming' :
					return false;
				case 'auto_commiting' :
					return true;
				case 'pdf_toolbar' :
					return ($this->status != "s10" && $this->status != "s20" && $this->status != "s40");
			}
		} else if ($cc ['user_representative_role']) { // Representative
			switch ($view) {
				case 'list' :
				case 'index' :
				case 'listview' :
					return ACLController::checkAccess ( $this->module_dir, 'list', true );
				case 'edit' :
					return (ACLController::checkAccess ( $this->module_dir, 'edit', $is_owner ) && ($this->status == "s10" || $this->status == "s40"));
				case 'save' :
				case 'popupeditview' :
				case 'editview' :
					return (ACLController::checkAccess ( $this->module_dir, 'edit', $is_owner ));
				case 'view' :
				case 'detail' :
				case 'detailview' :
					return ACLController::checkAccess ( $this->module_dir, 'view', $is_owner );
				case 'delete' :
					return (ACLController::checkAccess ( $this->module_dir, 'delete', $is_owner ) && $this->status == "s10");
				case 'export' :
					return ACLController::checkAccess ( $this->module_dir, 'export', $is_owner );
				case 'import' :
					return ACLController::checkAccess ( $this->module_dir, 'import', true );
				case 'quote_to_sale' :
				case 'quote_to_invoice' :
					return ($this->status != "s10" && $this->status != "s20" && $this->status != "s40" && $this->status != "s60");
				case 'send_to_confirm' :
					return ($this->status == "s10");
				case 'send_email' :
					return ($this->status != "s10" && $this->status != "s20" && $this->status != "s40");
				case 'can_commit' :
					return false;
				case 'confirming' :
					return false;
				case 'auto_commiting' :
					return false;
				case 'pdf_toolbar' :
					return ($this->status != "s10" && $this->status != "s20" && $this->status != "s40");
			}
		}
		// if it is not one of the above views then it should be implemented on the page level
		return true;
	}
	
	//mz generate number
	function generateNumber() {
		$db = $GLOBALS['db'];
		$r = $db->fetchByAssoc($db->query("SELECT count(id) as c FROM ecminsideorders WHERE YEAR(register_date)='".date('Y')."'"));

	    if (!$r || !$r['c'] || $r['c']=='')
	    	$count = 0;
	    else
	    	$count = intval($r['c']);
	    
	    $count++;
	    
	    //has 5 digits?
	    $tmp = strval($count);
	    while (strlen($tmp) < 5)
	    	$tmp = '0'.$tmp;
	    
	    return date("Ymd").$tmp;
	}
	
	function formatNumber($number) {
		$n = intval(substr($number, 8,5));
		$y = substr($number,2,2);
		
		//has 3 digits?
		while (strlen($n) < 3)
			$n = '0'.$n;
		
	   return ''.$n.'/'.$y;
	}
	
	function SaveProductionRw($id){
	    
	    $out=new EcmStockDocInsideOut();
	    $chk=$GLOBALS['db']->fetchByAssoc($GLOBALS['db']->query("select rw_id from ecminsideorders where id='".$_REQUEST['record']."'"));
	    if($chk['rw_id']==''){
	    $out->name=$this->document_no;
	    $out->assigned_user_id=$_SESSION['authenticated_user_id'];
	    $out->stock_id=$this->rw_stock_id;
	    $out->stock_name=$this->rw_stock_name;
	    $out->type='2';
	    $out->register_date=$GLOBALS['timedate']->to_display_date(date("Y-m-d"));
	    $out->status="accepted";
	    $position_list=json_decode($this->getPositionList(),true);
	
	    if(count($position_list)>0){
	        $pos=0;
	        for($i=0;$i<count($position_list);$i++){
	            if($position_list[$i]['product_component']!=1){
	            	$iid=$position_list[$i]['product_id'];
	            	continue;
	            }
	            if($position_list[$i]['ecmproductcategory_id']=='d7f876b0-1a3d-43a1-7c9b-511ba40df3d1')continue;
	            $r=$GLOBALS['db']->fetchByAssoc($GLOBALS['db']->query("select vat_id,vat_value,vat_name,name,code,id,product_category_id from ecmproducts where id='".$position_list[$i]['product_id']."'"));
	            $return_array['id'] = create_guid();
	            $return_array['position'] = $pos;
	            $return_array['product_code'] = $position_list[$i]['product_code'];
	            $return_array['name'] =$position_list[$i]['name'];
	            $return_array['quantity'] =$position_list[$i]['quantity'];
	            $return_array['product_id'] =$position_list[$i]['product_id'];
	            $return_array['price'] = null;
	            $return_array['discount'] = 0;
	            $return_array['total'] = null;
	            $return_array['unit_id'] =$position_list[$i]['unit_id'];
	            $return_array['unit_name'] = $position_list[$i]['unit_name'];
	            $return_array['ecmvat_id'] = $r['vat_id'];
	            $return_array['ecmvat_name'] = $r['vat_name'];
	            $return_array['ecmvat_value'] = $r['vat_value'];
	            $return_array['category_id'] =$position_list[$i]['ecmproductcategory_id'];
	            $return_array['currency_id'] = "PLN";
	            $return_array['currency_name'] = "PLN";
	            $return_array['product_product_id']=$iid;
	            $pos++;
	            $rw_prod[]=$return_array;
	            	
	        }
	    }
	   
	   $out->position_list=$rw_prod;
	   $out_id=$out->save(true);
	    $GLOBALS['db']->query("update ecminsideorders set rw_id='".$out_id."' where id='".$_REQUEST['record']."'");
	    //echo "update ecminsideorders set rw_id='".$out_id."' where id='".$_REQUEST['record']."'";
	    $GLOBALS['db']->query("update ecmstockdocinsideouts set ecminsideorder_id='".$this->id."' where id='".$out_id."'");
	    return $out_id;
	    }
	}
	
	function SaveProductionPw($id,$rw_id){
	 
		$chk=$GLOBALS['db']->fetchByAssoc($GLOBALS['db']->query("select pw_id from ecminsideorders where id='".$_REQUEST['record']."'"));
		if($chk['pw_id']==''){
	    $in=new EcmStockDocInsideIn();
	    $in->name=$this->document_no;
	    $in->assigned_user_id=$_SESSION['authenticated_user_id'];
	    $in->register_date=$GLOBALS['timedate']->to_display_date(date("Y-m-d"));
	    $in->stock_id=$this->pw_stock_id;
	    $in->stock_name=$this->pw_stock_name;
	    $in->ecmlanguage="pl_pl";
	    $in->currency_id="PLN";
	    $in->status="accepted";
	    $position_list=json_decode($this->getPositionList(),true);
	    
	    if(count($position_list)>0){
	        $pos=0;
	        for($i=0;$i<count($position_list);$i++){
	            
	            if($position_list[$i]['product_component']!=0)continue;
	            $wi=$GLOBALS['db']->query("select i.price,i.quantity,i.ecmproductcategory_id,i.ecmproduct_id from ecmstockdocinsideoutitems as i 
join ecmstockdocinsideouts as o on o.id=i.ecmstockdocinsideout_id where o.ecminsideorder_id='".$this->id."' and i.product_product_id='".$position_list[$i]['product_id']."' and o.id='".$rw_id."'");
	            $rqty=0;
	            $rvalue=0;
	            $rprice=0;
	            while($rwi=$GLOBALS['db']->fetchByAssoc($wi)){
	               

	                $tmp = floatval($rwi['price'])*floatval($rwi['quantity']);
	                $rvalue+=$tmp;
	            }
				$work_price=0;
	                $ss=$GLOBALS['db']->query("select pr.purchase_price,i.quantity from ecmproducts as pr
join ecminsideorderitems as i on i.ecmproduct_id=pr.id where i.ecminsideorder_id='".$id."'
and i.ecmproductcategory_id='d7f876b0-1a3d-43a1-7c9b-511ba40df3d1' and i.product_product_id='".$position_list[$i]['product_id']."'");
	               while($pp=$GLOBALS['db']->fetchByAssoc($ss)){
	                $tmp = floatval($pp['purchase_price'])*floatval($pp['quantity']);
	                $rvalue+=$tmp;
	                $work_price=$tmp;
	               }

	            if(floatval($position_list[$i]['quantity'])>0)$rprice=$rvalue/floatval($position_list[$i]['quantity']);
	            $r=$GLOBALS['db']->fetchByAssoc($GLOBALS['db']->query("select vat_id,vat_value,vat_name,name,code,id,product_category_id from ecmproducts where id='".$position_list[$i]['product_id']."'"));
	    
	            $return_array['id'] = create_guid();
	            $return_array['position'] = $pos;
	            $return_array['product_code'] = $position_list[$i]['product_code'];
	            $return_array['product_id'] =$position_list[$i]['product_id'];
	            $return_array['name'] =$position_list[$i]['name'];
	            $return_array['quantity'] =$position_list[$i]['quantity'];
	            $return_array['price'] = round($rprice,2);
	            $return_array['work_price'] = round($work_price,2);
	            $return_array['discount'] = 0;
	            $return_array['total'] =round($rvalue,2);
	            $return_array['unit_id'] =$position_list[$i]['unit_id'];
	            $return_array['unit_name'] = $position_list[$i]['unit_name'];
	            $return_array['vat_id'] = $r['vat_id'];
	            $return_array['vat_name'] = $r['vat_name'];
	            $return_array['vat_value'] = $r['vat_value'];
	            $return_array['category_id'] =$position_list[$i]['ecmproductcategory_id'];
	            $return_array['currency_id'] = "PLN";
	            $return_array['currency_name'] = "PLN";
	            $pw_prod[]=$return_array;
	        }
	    }

	    $in->position_list=$pw_prod;
	   
	   $in_id=$in->save(true);
	   $GLOBALS['db']->query("update ecminsideorders set pw_id='".$in_id."' where id='".$this->id."'");
	   // echo "update ecminsideorders set pw_id='".$in_id."' where id='".$this->id."'";
	   $GLOBALS['db']->query("update ecmstockdocinsideins set ecminsideorder_id='".$this->id."' where id='".$in_id."'");
	    return $in_id;
		}
	}
}
?>