<?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', 'accounts');
$ui->assign('_title', $_L['Delete'] . '- ' . $config['CompanyName']);
$action = $routes['1'];
$user = User::_info();
switch ($action) {

    case 'crm-user':

        if (!has_access($user->roleid, 'customers', 'delete')) {

            permissionDenied();
        }

        $id = $routes['2'];
        $id = str_replace('uid', '', $id);
        $d = ORM::for_table('crm_accounts')->find_one($id);
        if ($d) {
            $username = $d->account;
//delete all activity
            $x = ORM::for_table('sys_activity')->where('cid', $id)->delete_many();
            $x = ORM::for_table('sys_invoices')->where('userid', $id)->delete_many();
            $x = ORM::for_table('sys_quotes')->where('userid', $id)->delete_many();
            $x = ORM::for_table('sys_orders')->where('cid', $id)->delete_many();
            $x = ORM::for_table('sys_staffpermissions')->where('rid', $id)->delete_many();
            $x = ORM::for_table('ib_doc_rel')->where('rtype', 'contact')->where('rid', $id)->delete_many();
            //adicionado para seguir o padrão de remoção
            $x = ORM::for_table('crm_accounts_address')->where('crm_account_id', $id)->delete_many();
            $x = ORM::for_table('crm_accounts_contacts')->where('crm_accounts_id', $id)->delete_many();
            $x = ORM::for_table('crm_accounts_contacts')->where('crm_accounts_id_contact', $id)->delete_many();
            
            //remover tbls para funcionario lpillon - 17/03/2017
            $x = ORM::for_table('module_hr_job_journey')->where('func', $id)->delete_many();
            $x = ORM::for_table('module_hr_suns')->where('func', $id)->delete_many();
            $x = ORM::for_table('module_hr_empl_files')->where('func', $id)->delete_many();
            $x = ORM::for_table('module_hr_compl_data')->where('func', $id)->delete_many();
            
            $x = ORM::for_table('crm_accounts_groups')->where('crm_accounts_id', $id)->delete_many();
            #todo update payer and payee

            $d->delete();
            _log('Contact Deleted: ' . $username, 'Admin', $user['id']);

            $gid = route(3);

            if (!$gid) {
                r2(U . 'contacts/list/', 's', $_L['Contact Deleted Successfully']);
            } else {
                r2(U . 'contacts/find_by_group/' . $gid . '/', 's', $_L['Contact Deleted Successfully']);
            }
        } else {
            echo 'contact not found';
        }
        break;

    case 'ps':

        if (!has_access($user->roleid, 'products_n_services', 'delete')) {
            permissionDenied();
        }

        $id = $routes['2'];
        $id = str_replace('pid', '', $id);
        $d = ORM::for_table('sys_items')->find_one($id);
        if ($d) {
            $type = $d['type'];
            $r = 'ps/s-list';
            if ($type == 'Product') {
                $r = 'ps/p-list';
            }
            //valida registros antes de habilitar exclusão
            $invoice = ORM::for_table('sys_invoiceitems')->where('sys_item_id', $d->id)->find_many();
            $taxation = ORM::for_table('sys_items_taxation')->where('id_sys_items', $d->id)->find_many();

            if (count($invoice) > 0) {
                if ($type == 'Product') {
                    r2(U . $r, 'e', $_L['Not permited remove this product. Invoices having  product']);
                } else {
                    r2(U . $r, 'e', $_L['Not permited remove this service. Invoices having  service']);
                }
            } else if (count($taxation) > 0) {
                if ($type == 'Product') {
                    r2(U . $r, 'e', $_L['Not permited remove this product. Product having  taxation']);
                } else {
                    r2(U . $r, 'e', $_L['Not permited remove this service. Service having  taxation']);
                }
            } else {

                $product_steps = ORM::for_table('sys_items_step')->where('sys_items_id', $d->id)->order_by_asc('id')->find_many();
                $product_costs = ORM::for_table('sys_items_costs')->where('sys_items_id', $d->id)->order_by_asc('cost_date')->find_many();
                $stocks = ORM::for_table('sys_items_stock')->where('sys_items_id', $d->id)->find_many();
                $product_images = ORM::for_table('sys_items_images')->where('sys_items_id', $d->id)->find_many();
                $tags = ORM::for_table('sys_items_having_tags')->where('sys_items_id', $d->id)->find_many();

                $product_steps->delete();
                $product_costs->delete();
                $stocks->delete();
                $product_images->delete();
                $tags->delete();

                _log($type . ' Deleted: ' . $d['name'] . ' [ID: ' . $d['id'] . ']', 'Admin', $user['id']);

                $d->delete();

                r2(U . $r, 's', $_L[$type] . ' ' . $_L['Deleted Successfully']);
            }
        } else {
            echo 'not found';
        }
        break;

    case 'invoice':

        if (!has_access($user->roleid, 'sales', 'delete')) {

            permissionDenied();
        }

        $id = $routes['2'];
        $id = str_replace('iid', '', $id);
        $d = ORM::for_table('sys_invoices')->find_one($id);
        if ($d) {
//delete all invoice items
            $x = ORM::for_table('sys_invoiceitems')->where('invoiceid', $id)->delete_many();

            $d->delete();
            r2(U . 'invoices/list', 's', $_L['Invoice Deleted Successfully']);
        } else {
            echo 'Invoice not found';
        }
        break;

    case 'quote':

        if (!has_access($user->roleid, 'sales', 'delete')) {

            permissionDenied();
        }

        $id = $routes['2'];
        $id = str_replace('iid', '', $id);
        $d = ORM::for_table('sys_quotes')->find_one($id);
        if ($d) {
//delete all invoice items
            $x = ORM::for_table('sys_quoteitems')->where('qid', $id)->delete_many();

            $d->delete();
            r2(U . 'quotes/list/', 's', $_L['Quote Deleted Successfully']);
        } else {
            echo 'Invoice not found';
        }
        break;

    case 'tags':
        $id = $routes['2'];
        $id = str_replace('iid', '', $id);
        $d = ORM::for_table('sys_tags')->find_one($id);
        if ($d) {
            //tenta remover as tags
            try{
                $d->delete();
                r2(U . 'settings/tags', 's', $_L['Tag Deleted Successfully']);
            }catch(Exception $e){
                 r2(U . 'settings/tags', 's', $_L['Not Permited']);
            }
        } else {
            echo 'Invoice not found';
        }
        break;

    case 'tax':
        $id = $routes['2'];
        $id = str_replace('t', '', $id);
        $d = ORM::for_table('sys_tax')->find_one($id);
        if ($d) {

            $d->delete();
            r2(U . 'tax/list/', 's', $_L['TAX Deleted Successfully']);
        } else {
            echo 'TAX not found';
        }
        break;


    case 'customfield':

        $id = $routes[2];
        $id = str_replace('d', '', $id);

        $d = ORM::for_table('crm_customfields')->find_one($id);
        if ($d) {

            $d->delete();
            r2(U . 'settings/customfields/', 's', $_L['Custom Field Deleted Successfully']);
        } else {
            echo 'Custom Field Not found';
        }

        break;

    case 'crm-group':
        $id = $routes[2];
        //grupos fixos no sistema não pode editar. validação para ação
        $id = intval(str_replace('g', '', $id));
        $d = ORM::for_table('crm_groups')->find_one($id);
        if ($d) {
            if ($d->default) {
                _msglog('e', $_L['Fixed Group']);
                r2(U . 'contacts/groups/', 'e', $_L['Fixed Group']);
            } else {

                // find all contacts with this group
                $group_client = ORM::for_table('crm_accounts_groups')->where("crm_group_id", $id)->find_many();
                if (count($group_client) > 0) {
                    r2(U . 'contacts/groups/', 'e', $_L['Not permited remove this group. Group having  Contacts']);
                } else {
                    $d->delete();
                    _log($_L['Group'] . " " . $_L['Deleted'] . " - " + $d->name, 'Admin', $user['id']);
                    r2(U . 'contacts/groups/', 's', $_L['Group Deleted Successfully']);
                }
            }
        } else {
            echo 'contact not found';
        }

        break;





    case 'currency':

        $id = route(2);
        $id = str_replace('c', '', $id);

        $currency = Model::factory('Models_Currency');

        $c = $currency->find_one($id);

        if ($c) {

            if ($c->cname == $config['home_currency']) {

                r2(U . 'settings/currencies/', 'e', 'You Can\'t Delete Home Currency');
            }


            // check currency is using


            $invoice = Model::factory('Models_Invoice');

            $check = $invoice->where('currency', $id)->find_one();

            if ($check) {

                r2(U . 'settings/currencies/', 'e', 'This Currency is in use, You Can\'t Delete.');
            }

            $c->delete();


            r2(U . 'settings/currencies/', 's', 'Currency Deleted Successfully.');
        }


        break;


    case 'company':

        $id = route(2);
        $id = str_replace('c', '', $id);

        $company = Model::factory('Models_Company');

        $c = $company->find_one($id);

        if ($c) {

            $c->delete();

            r2(U . 'contacts/companies/', 's', $_L['Deleted Successfully']);
        }


        break;


    case 'event':

        $id = route(2);

        $calendar = Model::factory('Models_Calendar')->find_one($id);

        if ($calendar) {

            $calendar->delete();

            r2(U . 'calendar/events/', 's', $_L['Deleted Successfully']);
        }




        break;


    case 'role':

        $id = route(2);

        $role = Model::factory('Models_Role')->find_one($id);

        if ($role) {

            // check this role is using

            $users = Model::factory('Models_User')->where('roleid', $id)->find_one();

            if ($users) {

                r2(U . 'settings/roles/', 'e', 'This Role is in Use. You will have to assign User to another Role before deleting.');
            } else {

                // delete all permissions

                $p = ORM::for_table('sys_staffpermissions')->where('rid', $id)->delete_many();

                $role->delete();



                r2(U . 'settings/roles/', 's', $_L['Deleted Successfully']);
            }
        }




        break;

    case 'order':

        if (!has_access($user->roleid, 'orders', 'delete')) {

            permissionDenied();
        }

        $id = route(2);

        $id = str_replace('uid', '', $id);

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

        if ($d) {
            //delete all invoice items
            $x = ORM::for_table('sys_orders_items')->where('sys_orders_id', $id)->delete_many();
            $x = ORM::for_table('sys_orders_installment')->where('sys_orders_id', $id)->delete_many();
             
            $d->delete();
        }

        r2(U . 'orders/list/', 's', $_L['Deleted Successfully']);

        break;


    case 'document':

        if ($_app_stage == 'Demo') {
            r2(U . 'documents/list/', 'e', $_L['disabled_in_demo']);
        }

        if (!has_access($user->roleid, 'documents', 'delete')) {

            permissionDenied();
        }

        $id = route(2);

        $id = str_replace('did', '', $id);

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

        if ($d) {

            $file = 'application/storage/docs/' . $d->file_path;

            if (file_exists($file)) {

                unlink($file);
            }

            $d->delete();

            // now delete file relations


            $rel = ORM::for_table('ib_doc_rel')->where('did', $id)->delete_many();
        }

        r2(U . 'documents/list/', 's', $_L['Deleted Successfully']);


        break;





    default:
        echo 'action not defined';
}