<?php

// *************************************************************************
// *                                                                       *
// * iBilling -  Accounting, Billing Software                              *
// * Copyright (c) Sadia Sharmin. All Rights Reserved                      *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * Email: sadiasharmin3139@gmail.com                                                *
// * Website: http://www.sadiasharmin.com                                  *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * This software is furnished under a license and may be used and copied *
// * only  in  accordance  with  the  terms  of such  license and with the *
// * inclusion of the above copyright notice.                              *
// * If you Purchased from Codecanyon, Please read the full License from   *
// * here- http://codecanyon.net/licenses/standard                         *
// *                                                                       *
// *************************************************************************
_auth();
$ui->assign('_application_menu', 'orders');
$ui->assign('_title', $_L['Orders'] . '- ' . $config['CompanyName']);
$ui->assign('_st', $_L['Orders']);
$action = $routes['1'];
$user = User::_info();
$ui->assign('user', $user);

Event::trigger('orders');

switch ($action) {

    case 'list':
        $ui->assign('jsvar', '
_L[\'are_you_sure\'] = \'' . $_L['are_you_sure'] . '\';
 ');
        $mode_css = '';
        $mode_js = '';
        $mode_css = Asset::css('footable/css/footable.core.min');
        $mode_js = Asset::js(array('footable/js/footable.all.min', 'numeric', 'orders/list'));
        $d = ORM::for_table('sys_orders')
                        ->table_alias('o')
                        ->select('o.*')
                        ->select('c.account', 'account')
                        ->left_outer_join('crm_accounts', array('c.id', '=', 'o.crm_accounts_id'), 'c')
                        ->order_by_desc('o.id')->find_many();
        $ui->assign('d', $d);
        $ui->assign('xheader', $mode_css);
        $ui->assign('xfooter', $mode_js);

        $xjq = '
        $(\'.amount\').autoNumeric(\'init\', {
        aSign: \'' . $config['currency_code'] . ' \',
        dGroup: ' . $config['thousand_separator_placement'] . ',
        aPad: ' . $config['currency_decimal_digits'] . ',
        pSign: \'' . $config['currency_symbol_position'] . '\',
        aDec: \'' . $config['dec_point'] . '\',
        aSep: \'' . $config['thousands_sep'] . '\'
        });
     ';
        $ui->assign('xjq', $xjq);
        $ui->display('orders_list.tpl');
        break;


    case 'add':
        // find all customers
        $c = ORM::for_table('crm_accounts')->select('id')->select('account')->select('company')->select('email')->order_by_desc('id')->find_many();
        $ui->assign('c', $c);

        // find all products

        $p = ORM::for_table('sys_items')->select('id')->select('name')->find_array();

        $ui->assign('p', $p);

        if (isset($routes['3']) AND ( $routes['3'] != '')) {
            $p_cid = $routes['3'];
            $p_d = ORM::for_table('crm_accounts')->find_one($p_cid);
            if ($p_d) {
                $ui->assign('p_cid', $p_cid);
            }
        } else {
            $ui->assign('p_cid', '');
        }

        $max = ORM::for_table('sys_orders')->max('id');
        $nxt = $max + 1;
        //validaçao para caso tenha algum pedido no base, e nao pegue a numeração correta
        if ($nxt < 1000) {
            $nxt == 1000;
        }

        $ui->assign('orderNumber', $nxt);
        $ui->assign('items', null);
        $ui->assign('d', null);
        $ui->assign('numberItens', null);
        $ui->assign('qtdItens', null);
        $ui->assign('netWeight', null);
        $ui->assign('grossWeight', null);
        $ui->assign('totalProduct', null);
        $ui->assign('total', null);
        $ui->assign('ipi', null);
        $ui->assign('icmsst', null);
        $ui->assign('date', date('Y-m-d'));


        //CARREGA A LISTA DE estados
        $e = ORM::for_table('state')->order_by_asc('state_name')->find_many();
        $ui->assign('state', $e);


        // Busca os meios de pagamentos
        $pmethods = ORM::for_table('sys_pmethods')
                ->order_by_asc('sorder')
                ->find_array();
        $ui->assign('payment_methods', $pmethods);

        $pmethods = ORM::for_table('shipping_method')
                ->order_by_asc('sorder')
                ->find_array();
        $ui->assign('shipping_method', $pmethods);

        $css_arr = array('s2/css/select2.min', 'modal', 'dp/dist/datepicker.min');


        $mode_js = Asset::js(array('s2/js/select2.min', 's2/js/i18n/' . lan(), 'dp/dist/datepicker.min', 'dp/i18n/' . $config['language'], 'numeric', 'modal', 'modal-add-contact', 'modal_edit_contact_address', 'orders/add'));
        $ui->assign('xheader', Asset::css($css_arr));

        $ui->assign('xfooter', $mode_js);

        $ui->assign('xjq', '
        function ib_amount() {    
        }
         $(\'.amount\').autoNumeric(\'init\', {
            aSign: \'' . $config['currency_code'] . ' \',
            dGroup: ' . $config['thousand_separator_placement'] . ',
            aPad: ' . $config['currency_decimal_digits'] . ',
            pSign: \'' . $config['currency_symbol_position'] . '\',
            aDec: \'' . $config['dec_point'] . '\',
            aSep: \'' . $config['thousands_sep'] . '\'

            });
             $(".select2").select2({
            theme: "bootstrap"
            });
            $(\'.integer\').autoNumeric(\'init\', {aSep: \'\', aDec: \'' . $config['dec_point'] . '\', mDec: 0, aSign: \' \', pSign: \'s\'});
        ');

        $ui->assign('jsvar', '
            _L[\'are_you_sure\'] = \'' . $_L['are_you_sure'] . '\';
            _L[\'Save\'] = \'' . $_L['Save'] . '\';
            _L[\'OK\'] = \'' . $_L['OK'] . '\';
             _L[\'Remove\'] = \'' . $_L['Remove'] . '\';  
            _L[\'Select\'] = \'' . $_L['Select'] . '\';  
            _L[\'Cancel\'] = \'' . $_L['Cancel'] . '\';
            _L[\'Name\'] = \'' . $_L['Name'] . '\';
            _L[\'Add New Nature Of Operation\'] = \'' . $_L['Add New Nature Of Operation'] . '\';
            _L[\'Select Nature Of Operation\'] = \'' . $_L['Select Nature Of Operation'] . '\';
            _L[\'Select Client\'] = \'' . $_L['Select Client'] . '\';
            _L[\'Select Salesman\'] = \'' . $_L['Select Salesman'] . '\';
            _L[\'not enough stock available:\'] = \'' . $_L['not enough stock available:'] . '\';   
            _L[\'stock available:\'] = \'' . $_L['stock available:'] . '\';   
            _L[\'Add New Tag\'] = \'' . $_L['Add New Tag'] . '\';   
            _L[\'Tags\'] = \'' . $_L['Tags'] . '\';   
            _L[\'Select State\'] = \'' . $_L['Select State'] . '\';   
            _L[\'Select City\'] = \'' . $_L['Select City'] . '\';   
            _L[\'Select the item first.\'] = \'' . $_L['Select the item first.'] . '\'; 
            _L[\'Select\'] = \'' . $_L['Select'] . '\'; 
            _L[\'There are no items to add\'] = \'' . $_L['There are no items to add'] . '\';     
            _L[\'CPF Invalid\'] = \'' . $_L['CPF Invalid'] . '\';
            _L[\'CNPJ Invalid\'] = \'' . $_L['CNPJ Invalid'] . '\';
        ');

        $ui->display('orders_add.tpl');

        break;

    case 'post':
        $client = _post('client');

        $msg = '';
        if ($client == '') {
            $msg .= $_L['select_a_contact'] . ' <br> ';
        }

        if (isset($_POST['amount'])) {
            $qty = $_POST['qty'];
            $description = $_POST['desc'];
            $item_id = $_POST['id_product'];
            $i = '0';
            //validação de estoque
            foreach ($description as $item) {
                $stock = ORM::for_table('sys_items_stock')->where('sys_items_id', $item_id[$i])->find_many();
                if (count($stock) > 0) {
                    if ($stock[0]->current_stock < Finance::amount_fix($qty[$i])) {
                        $msg.= $item . " " . $_L['not enough stock available:'] . " " . $stock[0]->current_stock . "<br/>";
                    }
                }
                if(Finance::amount_fix($qty[$i])<=0){
                      $msg.= $item . " " . $_L['can not be registered with quantity 0 "zero"']. "<br/>";
                }
               if(empty($item_id[$i])){
                      $msg.= $_L['Select the item first.']. "<br/>";
                }
                $i++;
            }
        } else {
            $msg .= $_L['at_least_one_item_required'] . ' <br> ';
        }

        if ($msg == '') {

            $d = ORM::for_table('sys_orders')->create();
            empty(_post('nature_operation')) ? '' : $d->nature_operation_id = _post('nature_operation');
            $d->crm_accounts_id = $client;

            //grava o endereço, ou informado pelo usuário ou buscado do banco do cadastro do cliente, no pedido
            $d->delivery_address = !empty(_post('delivery_address')) ? _post('delivery_address') : 'other';
            if ($d->delivery_address == 'other') {
                if (intval(_post('state'))) {
                    $d->state_id = _post('state');
                }

                if (intval(_post('city')) > 0) {
                    $d->city_id = _post('city');
                }
                $d->zip = _post('zip');
                $d->address = _post('address');
                $d->neighborhood = _post('neighborhood');
                $d->number = _post('number');
                $d->complement = _post('complement');
            } else {
                $address = ORM::for_table('crm_accounts_address')->where('crm_account_id', $d->crm_accounts_id)->where('type_address', $d->delivery_address)->find_many();
                if (count($address) > 0) {
                    if (intval($address[0]->state_id)) {
                        $d->state_id = $address[0]->state_id;
                    }

                    if (intval($address[0]->city_id) > 0) {
                        $d->city_id = $address[0]->city_id;
                    }
                    $d->zip = $address[0]->zip;
                    $d->address = $address[0]->address;
                    $d->neighborhood = $address[0]->neighborhood;
                    $d->number = $address[0]->number;
                    $d->complement = $address[0]->complement;
                }
            }
            empty(_post('salesman')) ? '' : $d->salesman_id = _post('salesman');
            $d->gross_weight = Finance::amount_fix(_post('gross_weight'));
            $d->net_weight = Finance::amount_fix(_post('net_weight'));
            $amount = $_POST['amount'];
            $i = 0;
            $sTotal = 0;
            foreach ($amount as $samount) {
                $samount = Finance::amount_fix($samount);
                $a[$i] = $samount;
                /* @since v 2.0 */
                $sqty = $qty[$i];

                $sqty = Finance::amount_fix($sqty);

                $sTotal += $samount * ($sqty);
                $lamount = $samount * ($sqty);
                $i++;
            }

            $fTotal = $sTotal;

            $d->sub_total = $sTotal;


            // calculate discount

            $discount_amount = Finance::amount_fix(_post('discount'));
            $discount_type = _post('type_discount');
            $discount_value = '0.00';

            if ($discount_amount == '0' OR $discount_amount == '') {
                $actual_discount = '0.00';
            } else {
                if ($discount_type == 'f') {

                    $actual_discount = $discount_amount;
                    $discount_value = $discount_amount;
                } else {

                    $discount_type = 'p';
                    $actual_discount = ($sTotal * $discount_amount) / 100;
                    $discount_value = $discount_amount;
                }
            }


            $actual_discount = number_format((float) $actual_discount, 2, '.', '');
            $fTotal = $fTotal - $actual_discount;


            $d->freight = Finance::amount_fix(_post('freight'));
            $d->total = $fTotal + $d->freight;

            $d->discount_type = $discount_type;
            $d->discount_value = Finance::amount_fix($discount_value);
            $d->discount = $actual_discount;
            empty(_post('sales_date')) ? '' : $d->sales_date = _postDate('sales_date', $_c);
            empty(_post('expected_date')) ? '' : $d->expected_date = _postDate('expected_date', $_c);
            $d->payment_method = _post('mtdopgto');
            empty(_post('shipping_method')) ? '' : $d->shipping_method_id = _post('shipping_method');
            $d->tracking_code = _post('tracking_code');
            $d->craw_url = _post('craw_url');
            $d->conveyor_id = _post('conveyor_id');
            $d->freight_by = _post('freight_by');
            $d->qtd_volumes = _post('qtd_volumes');
            $d->notes = _post('notes');
            $d->internal_remarks = _post('internal_remarks');
            if (isset($_POST['tags']) AND ( $_POST['tags']) != '') {
                $tags = $_POST['tags'];
            } else {
                $tags = '';
            }
            $d->tags = Arr::arr_to_str($tags);
            //salva status inicial do pedido
            $d->status = 'Open';


            $d->save();

            $order_id = $d->id();
            $description = $_POST['desc'];
            $item_id = $_POST['id_product'];

            $i = '0';
            foreach ($description as $item) {
                $samount = $a[$i];
                $sqty = $qty[$i];
                $sqty = Finance::amount_fix($sqty);
                $samount = Finance::amount_fix($samount);
                $ltotal = ($samount) * ($sqty);
                $sys_orders_items = ORM::for_table('sys_orders_items')->create();
                $sys_orders_items->sys_orders_id = $order_id;
                $sys_orders_items->description = $item;
                $sys_orders_items->qty = $sqty;
                $sys_orders_items->amount = $samount;
                $sys_orders_items->discount = '0.00';
                $sys_orders_items->total = $ltotal;
                $sys_orders_items->sys_item_id = $item_id[$i];

                $sys_orders_items->save();
                $i++;
            }

            $generate_invoice = _post('generate_invoice');
            if ($generate_invoice == 'Yes') {
                $d->status = 'Approved';
                $u = ORM::for_table('crm_accounts')->find_one($client);
                $id = convertInvoice($d, $u->account);
                $d->sys_invoice_id = $id;
                $d->save();
            }

            echo $order_id;
        } else {
            echo $msg;
        }


        break;

    case 'convert_invoice':
        $oid = route(2);
        $order = ORM::for_table('sys_orders')
                ->table_alias('o')
                ->select('o.*')
                ->select('c.account', 'account')
                ->left_outer_join('crm_accounts', array('c.id', '=', 'o.crm_accounts_id'), 'c')
                ->find_one($oid);
        if ($order->status == 'Open') {
            $id = convertInvoice($order, $order->account);
            $order = ORM::for_table('sys_orders')->find_one($order->id);
            $order->status = 'Approved';
            $order->sys_invoice_id = $id;
            $order->save();
            r2(U . "orders/view/" . $order->id, 's', $_L['Invoice Created']);
        } else {
            r2(U . "orders/list/", 'e', $_L['Not Permited']);
        }
        break;
    case 'view':


        $oid = route(2);

        // find the orders

        $order = ORM::for_table('sys_orders')
                ->table_alias('o')
                ->select('o.*')
                ->select('c.account', 'account')
                ->left_outer_join('crm_accounts', array('c.id', '=', 'o.crm_accounts_id'), 'c')
                ->find_one($oid);

        if ($order) {

            $ui->assign('jsvar', '
_L[\'data_updated\'] = \'' . $_L['Data Updated'] . '\';
_L[\'email_sent\'] = \'' . $_L['Email Sent'] . '\';
 ');




            $ui->assign('xfooter', Asset::js(array('tinymce/tinymce.min', 'numeric', 'orders/view')));

            $ui->assign('order', $order);

            $xjq = '

    $(\'.amount\').autoNumeric(\'init\', {

    aSign: \'' . $config['currency_code'] . ' \',
    dGroup: ' . $config['thousand_separator_placement'] . ',
    aPad: ' . $config['currency_decimal_digits'] . ',
    pSign: \'' . $config['currency_symbol_position'] . '\',
    aDec: \'' . $config['dec_point'] . '\',
    aSep: \'' . $config['thousands_sep'] . '\'

    });

 ';

            $ui->assign('xjq', $xjq);

            $ui->display('orders_view.tpl');
        } else {
            i_close('Order Not Found');
        }


        break;

    case 'set':

        $id = route(2);
        $status = route(3);

        $allowed_status = array('Pending', 'Active', 'Cancelled', 'Fraud', 'Processing');

        if (in_array($status, $allowed_status)) {
            
        } else {
            $msg = 'Invalid Status';
        }

        $d = ORM::for_table('sys_orders')->find_one($id);

        if ($d) {

            $d->status = $status;
            $d->save();

            $msg = $_L['Data Updated'];
        } else {
            $msg = 'Order not found';
        }


        r2(U . 'orders/view/' . $id . '/', 's', $msg);



        break;



    case 'save_activation':

        $oid = _post('oid');

        $activation_subject = $_POST['activation_subject'];

        $activation_message = $_POST['activation_message'];

        $send_email = _post('send_email');

        if ($activation_message == '' || $activation_message == '') {
            i_close($_L['All Fields are Required']);
        }




        $d = ORM::for_table('sys_orders')->find_one($oid);

        if ($d) {

            $cid = $d->cid;

            $d->activation_subject = $activation_subject;
            $d->activation_message = $activation_message;

            $d->save();


            if ($send_email == 'yes') {

                // Send Email

                $client = ORM::for_table('crm_accounts')->find_one($cid);

                if ($client) {

                    if ($client->email != '') {
                        Ib_Email::_send($client->account, $client->email, $activation_subject, $activation_message, $cid);
                    }
                }
            }




            echo $d->id();
        } else {

            echo 'Order not found';
        }



        break;


    case 'module':

        $id = route(2);



        $d = ORM::for_table('sys_orders')->find_one($id);

        if ($d) {

            Event::trigger('orders/modules/');

            r2(U . 'orders/view/' . $id . '/', 's', $_L['Data Updated']);
        } else {
            $msg = 'Order not found';
        }





        break;








    default:
        echo 'action not defined';
}

function convertInvoice($q, $nameClient) {
    $today = date('Y-m-d');
    $idate = $today;
    $its = strtotime($idate);
    $duedate = $today;

    $dd = $today;

    $invoicenum = '';
    $vtoken = _raid(10);
    $ptoken = _raid(10);
    $d = ORM::for_table('sys_invoices')->create();
    $d->userid = $q['crm_accounts_id'];
    $d->account = $nameClient;
    $d->date = $idate;
    $d->duedate = $dd;
    $d->subtotal = $q['sub_total'];
    $d->discount_type = $q['discount_type'];
    $d->discount_value = $q['discount_value'];
    $d->discount = $q['discount'];
    $d->total = $q['total'];
    $d->vtoken = $vtoken;
    $d->ptoken = $ptoken;
    $d->status = 'Unpaid';
    $d->notes = $q['notes'];
    $d->invoicenum = $invoicenum;
    $d->tax2 = '0.00';
    $d->tax = '0.00';
    $d->taxname = '';
    $d->taxrate2 = '0.00';
    $d->taxrate = '0.00';
    $d->paymentmethod = $q['payment_method'];
    $d->sys_accounts_id = $q['crm_accounts_id'];
    $d->freight = $q['freight'];
    $d->paymentcondition = 0;
    $d->sys_orders_id = $q['id'];
    $d->freight_by = $q['freight_by'];
    if ($d->freight_by == 'Free shipping') {
        $d->freight = 0;
    } else {
        $d->freight = $q['freight'];
    }
    $d->save();

    $invoiceid = $d->id();

    $taxed = '0';
    $i = '0';

    $items = ORM::for_table('sys_orders_items')->where('sys_orders_id', $q['id'])->order_by_asc('id')->find_many();

    foreach ($items as $item) {

        $d = ORM::for_table('sys_invoiceitems')->create();
        $d->invoiceid = $invoiceid;
        $d->userid = $q['crm_accounts_id'];
        $d->description = $item['description'];
        $d->qty = $item['qty'];
        $d->amount = $item['amount'];
        $d->total = $item['total'];


        $d->taxed = '0';

        //others
        $d->type = '';
        $d->relid = '0';
        $d->itemcode = '';
        $d->taxamount = '0.00';
        $d->duedate = date('Y-m-d');
        $d->paymentmethod = '';
        $d->notes = '';
        $d->sys_item_id = $item['sys_item_id'];

        $d->save();
        $i++;
    }

    return $invoiceid;
}