<?php
if (! defined('sugarEntry') || ! sugarEntry)
    die('-1');
if (! $_POST['job'] || $_POST['job'] == '')
    die('-1');
switch ($_POST['job']) {
    case 'getParentInfo':
        getParentInfo($_POST['id'], $_POST['type']);
        break;
    case 'getContactInfo':
        getContactInfo($_POST['id']);
        break;
    case 'generateNumber':
        generateNumber();
        break;
    case 'searchProducts':
        searchProducts($_POST['searchKey'], $_POST['searchCategory'], 
                $_POST['searchStock'], $_POST['searchSort'], 
                $_POST['searchStockId']);
        break;
    case 'getProduct':
        getProduct($_POST['id'], $_POST['stockId']);
        break;
    case 'getItems':
        getItems($_POST['record']);
        break;
    case 'getCategoriesList':
        getCategoriesList();
        break;
    case 'getTranslation':
        getTranslation($_POST['product_id'], $_POST['language'], 
                $_REQUEST['unit_id']);
        break;
    case 'getPricesInfo':
        getPricesInfo($_POST['product_id'], $_POST['pricebook_id'], 
                $_POST['account_id']);
        break;
    case 'getStockArray':
        getStockArray($_POST['product_id']);
        break;
    case 'getPurchaseArray':
        getPurchaseArray($_POST['product_id']);
        break;
    case 'getStockState':
        getStockState($_POST['id'], $_POST['stockId']);
        break;
    case 'getComponents':
        getComponents($_POST['product_id']);
        break;
    case 'getAddresses':
        getAddresses($_POST['account_id']);
        break;
    case 'getAddress':
        getAddress($_POST['account_id']);
        break;
    case 'setAdress':
        setAdress($_POST['account_id']);
        break;
}

function setAdress ($account_id)
{
    $a = new Account();
    $a->retrieve($account_id);
    $res=array();
    $res['street']=$a->billing_address_street;
    $res['city']=$a->billing_address_city;
    $res['postalcode']=$a->billing_address_postalcode;
    $res['country']=$a->billing_address_country;
    $res['nip']=$a->to_vatid;
    echo json_encode($res);
    unset($a);
    return;
}

function getAddress ($account_id)
{
    $a = new Account();
    echo json_encode($a->getAddress($account_id));
    unset($a);
    return;
}

function getAddresses ($account_id)
{
    $a = new Account();
    
    echo json_encode($a->getAddresses($account_id));
    unset($a);
    return;
}

function getContactInfo ($id)
{
    if (! $id || $id == '')
        die('-1');
    $c = new Contact();
    $c->retrieve($id);
    $data = array();
    $data['parent_contact_name'] = $c->first_name . ' ' . $c->last_name;
    $data['parent_contact_title'] = $c->title;
    echo json_encode($data);
    unset($data);
    unset($c);
    return;
}

function getParentInfo ($id, $type)
{
    if (! $id || $id == '')
        die('-1');
    if (! $type || $type == '')
        die('-1');
    
    if ($type == 'Accounts') {
        $a = new Account();
        $a->retrieve($id);
        $data = array();
        $data['name'] = html_entity_decode($a->name);
        $data['parent_nip'] = $a->to_vatid;
        $data['parent_address_street'] = $a->billing_address_street;
        $data['parent_address_postalcode'] = $a->billing_address_postalcode;
        $data['parent_address_city'] = $a->billing_address_city;
        $data['parent_address_country'] = $a->billing_address_country;
        $data['invoice_type'] = $a->invoice_type;
        $data['currency_id'] = $a->currency_id;
        if ($a->ecmpaymentcondition_id && $a->ecmpaymentcondition_id != '') {
            $pc = new EcmPaymentCondition();
            $pc->retrieve($a->ecmpaymentcondition_id);
            $data['ecmpaymentcondition_id'] = $pc->id;
            $data['ecmpaymentcondition_name'] = $pc->name;
        }
        if ($a->ecmdeliverycondition_id && $a->ecmdeliverycondition_id != '') {
            $pc = new EcmdeliveryCondition();
            $pc->retrieve($a->ecmdeliverycondition_id);
            $data['ecmdeliverycondition_id'] = $pc->id;
            $data['ecmdeliverycondition_name'] = $pc->name;
        }
        
        if ($a->ecmprice_id && $a->ecmprice_id != '') {
            $pr = new EcmPrice();
            $pr->retrieve($a->ecmprice_id);
            $data['ecmprice_id'] = $pr->id;
            $data['ecmprice_name'] = $pr->name;
        }
        // get pricebooks, ownership pricebooks
        $pricebooks = array();
        $db = $GLOBALS['db'];
        $res = $db->query(
                "SELECT id, name FROM ecmpricebooks WHERE account_id IN ('" .
                         $a->id . "','" . $a->parent_id .
                         "') AND active='1' AND deleted='0'");
        while ($row = $db->fetchByAssoc($res)) {
            $tmp = array();
            $tmp['id'] = $row['id'];
            $tmp['name'] = $row['name'];
            $pricebooks[] = $tmp;
            unset($tmp);
        }
        $data['pricebooks'] = $pricebooks;
        echo json_encode($data);
        unset($data);
        unset($a);
        unset($res);
        return;
    }
}

function generateNumber ()
{
    $data = array();
    $data['number'] = EcmPurchaseOrder::generateNumber();
    $data['document_no'] = EcmPurchaseOrder::formatNumber($data['number']);
    echo json_encode($data);
    unset($data);
    return;
}

function searchProducts ($searchKey, $searchCategory, $searchStock, $searchSort, 
        $searchStockId)
{
    $db = $GLOBALS['db'];
    $q = "SELECT id, code, name FROM ecmproducts WHERE
					(UPPER(code) LIKE '%$searchKey%' OR
					UPPER(name) LIKE '%$searchKey%')
					AND deleted='0' ";
    if ($searchCategory && $searchCategory != "")
        $q .= "AND product_category_id='$searchCategory' ";
    
    if ($searchSort == '1')
        $q .= "ORDER BY code";
    else 
        if ($searchSort == '2')
            $q .= "ORDER BY code DESC";
        else 
            if ($searchSort == '3')
                $q .= "ORDER BY name";
            else 
                if ($searchSort == '4')
                    $q .= "ORDER BY name DESC";
    
    $q .= " LIMIT 0,50";
    
    $res = $db->query($q);
    $result = array();
    
    $stock_id = $searchStockId;
    
    while ($row = $db->fetchByAssoc($res)) {
        $tmp = array();
        $tmp['id'] = $row['id'];
        $tmp['name'] = $row['name'];
        $tmp['code'] = $row['code'];
        
        // get stock if necessary
        if ($searchStock != '1') {
            $tmp['stock_state'] = EcmStockOperation::getStock($row['id'], 
                    $stock_id);
        }
        
        if ($searchStock == '3' && $tmp['stock_state'] == 0)
            continue; // don't
                          // show
                          // null
                          // stock
        
        $result[] = $tmp;
    }
    echo json_encode($result);
    return;
}

function getProduct ($id, $stockId)
{
    $db = $GLOBALS['db'];
    $p = $db->fetchByAssoc(
            $db->query(
                    "SELECT p.id, p.code, p.name, v.id as ecmvat_id, v.name as ecmvat_name, v.value as ecmvat_value, p.ean, p.ean2, p.unit_id FROM ecmproducts as p INNER JOIN ecmvats as v ON v.id=p.vat_id WHERE p.id='$id'"));
    global $app_list_strings;
    $p['unit_name'] = $app_list_strings['ecmproducts_unit_dom'][$p['unit_id']];
    $p['stock_state'] = $tmp['stock_state'] = EcmStockOperation::getStock($id, 
            $stockId);
    $p['unit_precision'] = $app_list_strings['ecmproducts_unit_dom_precision'][$p['unit_id']];
    
    echo json_encode($p);
    return;
}

function getItems ($record)
{
    $mm = new EcmPurchaseOrder();
    $mm->retrieve($record);
    $pl = $mm->getPositionList(true);
    unset($mm);
    echo json_encode($pl);
    return;
}

function getCategoriesList ()
{
    $db = $GLOBALS['db'];
    $res = $db->query(
            "SELECT id, name FROM ecmproductcategories WHERE deleted='0'");
    $result = array();
    while ($row = $db->fetchByAssoc($res)) {
        $tmp = array();
        $tmp['id'] = $row['id'];
        $tmp['name'] = $row['name'];
        $result[] = $tmp;
    }
    echo json_encode($result);
    return;
}

function getTranslation ($product_id, $language, $unit_id)
{
    $db = $GLOBALS['db'];
    $result = array();
    if ($language == 'en_us') {
        $r = $db->fetchByAssoc(
                $db->query(
                        "SELECT short_description FROM ecmproduct_language WHERE ecmproduct_id='$product_id' AND language='en'"));
        $result['name'] = htmlspecialchars_decode($r['short_description']);
    } else 
        if ($language == 'pl_pl') {
            $p = new EcmProduct();
            $p->retrieve($product_id);
            $result['name'] = htmlspecialchars_decode($p->name);
            unset($p);
        }
    $lists = return_app_list_strings_language($language);
    $result['unit_name'] = $lists['ecmproducts_unit_dom'][$unit_id];
    unset($lists);
    
    echo json_encode($result);
    return;
}

function getPricesInfo ($product_id, $pricebook_id, $account_id)
{
    $db = $GLOBALS['db'];
    
    $result = array();
    if ($pricebook_id && $pricebook_id != '') {
        // try get price from pricebook
        $res = $db->fetchByAssoc(
                $db->query(
                        "SELECT price FROM ecmpricebooks_ecmproducts WHERE ecmpricebook_id='$pricebook_id' AND ecmproduct_id='$product_id' AND deleted='0'"));
        if ($res['price'] && $res['price'] != '' && $res['price'] != 0) {
            $tmp = array();
            $tmp['name'] = 'pricebook';
            $tmp['price'] = $res['price'];
            $result[] = $tmp;
        }
    }
    
    // get from ecmprices
    $res = $db->query(
            "SELECT p.name, pp.price FROM ecmprices_ecmproducts AS pp 
					   INNER JOIN ecmprices AS p
					   ON p.id=pp.ecmprice_id
					   WHERE
					   pp.ecmproduct_id='$product_id'
					   AND pp.price!=0");
    while ($row = $db->fetchByAssoc($res)) {
        $tmp = array();
        $tmp['name'] = $row['name'];
        $tmp['price'] = $row['price'];
        $result[] = $tmp;
    }
    
    // get last invoice price
    if ($account_id && $account_id != '') {
        $res = $db->fetchByAssoc(
                $db->query(
                        "SELECT ii.subprice, i.id, i.document_no FROM ecminvoiceoutitems AS ii
										     INNER JOIN ecminvoiceouts AS i
											 ON ii.ecminvoiceout_id=i.id
											 WHERE ii.ecmproduct_id='$product_id'
											 AND i.parent_id='$account_id'
											 AND ii.deleted='0'
											 AND i.deleted='0'
											 AND i.canceled='0'
											 ORDER BY i.register_date DESC
											 LIMIT 0,1"));
        if ($res && $res['subprice'] != '') {
            $tmp = array();
            $tmp['name'] = $res['document_no'];
            $tmp['price'] = $res['subprice'];
            $result[] = $tmp;
        }
    }
    
    echo json_encode($result);
    return;
}

function getStockArray ($product_id)
{
    $o = new EcmStockOperation();
    echo json_encode($o->getStockArray($product_id));
    unset($o);
    return;
}

function getPurchaseArray ($product_id)
{
    $o = new EcmStockOperation();
    echo json_encode($o->getPurchaseArray($product_id));
    unset($o);
    return;
}

function getStockState ($id, $stock_id)
{
    echo EcmStockOperation::getStock($id, $stock_id);
    return;
}

function getComponents ($product_id)
{
    $p = new EcmProduct();
    $p->retrieve($product_id);
    echo json_encode($p->getPositionList(true));
    return;
}