<?php

require_once 'Pman/Core/ExcelToJson.php';

class Pman_Xtuple_Import_Transfer extends Pman_Core_ExcelToJson
{
    function getAuth()
    {
        if (HTML_FlexyFramework::get()->cli) {
            return true;
        }
        return parent::getAuth();
    }
    
    function post()
    {
        parent::post();
    }
    
    function importCsv($csv)
    {
        $ret = parent::importCsv($csv);
       
        $data = $ret['data'];
        
        $ret['data'] =$ret['extra'];
        
        // can not handle extra data.. .as image calls back with result.data...
        
        
        $lc = DB_DataObject::factory('location');
        if(!empty($ret['extra']['From']) && $lc->get('location_name', $ret['extra']['From'])){
            $ret['data']['invhist_transfer_from'] = $lc->pid();
            $ret['data']['invhist_transfer_from_location_name'] = $lc->location_name;
        }
        
        
        $lt = DB_DataObject::factory('location');
        if(!empty($ret['extra']['To']) && $lt->get('location_name', $ret['extra']['To'])){
            $ret['data']['invhist_transfer_to'] = $lt->pid();
            $ret['data']['invhist_transfer_to_location_name'] = $lt->location_name;
        }
        
        $ourdb = substr($lt->database(), -2);
        
        $ltc = ($lt->location_id  && $lt->location_cust_id ) ? $lt->customer()->char('INTERNALCOMPANY') : '';
        
        $ret['data']['isInter'] = 0;
        if(strlen($ltc) && $ourdb != $ltc){
            $ret['data']['isInter'] = 1;
        }
        
        $errmsg = array();
        
        foreach ($data as $r){
            $itemsite = DB_DataObject::factory('itemsite');
            $itemsite->autoJoin();
            $itemsite->whereAdd("UPPER(join_itemsite_item_id_item_id.item_number) = UPPER('{$itemsite->escape(trim($r['ITEM CODE']))}')");
            if(!$itemsite->find(true)){
                $errmsg[] = $r['ITEM CODE'];
                continue;
            }
            $r['UNIT PRICE']  = isset($r['UNIT PRICE'] ) ? $r['UNIT PRICE']  : '';
            $ret['data']['items'][] = array(
                'itemsite_item_id' => $itemsite->itemsite_item_id,
                'itemsite_id' => $itemsite->pid(),
                'itemsite_item_id_item_number' => trim($r['ITEM CODE']),
                'itemsite_item_id_item_descrip1' => !empty($r['DESCRIPTION']) ? $r['DESCRIPTION'] : $itemsite->itemsite_item_id_item_descrip1,
                'itemsite_qty' => $r['QUANTITY'],
                'unit_price' => (strlen($ltc) && $ourdb != $ltc) ? $r['UNIT PRICE'] : ''
            );
        }
        
        if(count($errmsg)){
            $this->jerr("MISSING \n" . implode("\n", $errmsg));
        }
        
        return $ret;
        
    }
    
}