/module/Order/src/Order/Controller/OrderController.php

Large files files are truncated, but you can click here to view the full file

<?php
/**
 * Zend Framework (http://framework.zend.com/)
 *
 * @link      http://github.com/zendframework/ZendSkeletonApplication for the canonical source repository
 * @copyright Copyright (c) 2005-2014 Zend Technologies USA Inc. (http://www.zend.com)
 * @license   http://framework.zend.com/license/new-bsd New BSD License
 */

namespace Order\Controller;

use Zend\View\Model\ViewModel;
use Zend\View\Model\JsonModel;
use Qv\Language;

use Provisioning\Model\Order;
use Provisioning\Model\Group;
use Provisioning\Model\Customer;
use Provisioning\Model\Device;
use Provisioning\Model\User;
use Provisioning\Model\Xml;
use Provisioning\Model\Dn;
use Provisioning\Model\Message;
use Provisioning\Model\Queue;
use Provisioning\Model\GroupServiceProvider;
use Provisioning\Model\DomainAdd;
use Provisioning\Model\ProviderAdd;
use Provisioning\Model\Provider;
use Provisioning\Model\Domain;
use Provisioning\Model\ServiceProviderEmpresaAdd;
use Provisioning\Model\UserModifyAdd;
use Provisioning\Model\AdditionLine;
use Provisioning\Model\ChangeNumber;
use Provisioning\Model\DeleteLine;
use Provisioning\Model\CreationGroup;
use Provisioning\Model\DeleteGroup;


use Provisioning\Form\OrderForm;
use Provisioning\Form\GroupForm;
use Provisioning\Form\CustomerForm;
use Provisioning\Form\DeviceForm;
use Provisioning\Form\DomainAddForm;
use Provisioning\Form\UserForm;
use Provisioning\Form\GroupDnAssignForm;
use Provisioning\Form\UserDnDeviceAssignForm;
use Provisioning\Form\ServiceProviderAddForm;
use Provisioning\Form\ServiceProviderOrderAddForm;
use Provisioning\Form\UserModifyAddForm;
use Provisioning\Form\GroupModifyForm;
use Provisioning\Form\GroupdnAssignListalForm;
use Provisioning\Form\ServiceProviderdnAddListalForm;
use Provisioning\Form\UserAddalForm;
use Provisioning\Form\UserModifyalForm;
use Provisioning\Form\UserServiceAssignListalForm;
use Provisioning\Form\UserAuthenticationModifyalForm;
use Provisioning\Form\GroupSeriesCompletionModifyInstancealForm;
use Provisioning\Form\UserModifycnForm;
use Provisioning\Form\GroupdnunAssignListcnForm;
use Provisioning\Form\ServiceProviderdnDeleteListcnForm;
use Provisioning\Form\ServiceProviderdnAddListcnForm;
use Provisioning\Form\GroupdnAssignListcnForm;
use Provisioning\Form\UserModifycnaForm;
use Provisioning\Form\GroupdnActivateListcnForm;
use Provisioning\Form\UserDeleteelForm;
use Provisioning\Form\GroupdnunAssignListelForm;
use Provisioning\Form\ServiceProviderdnDeleteListelForm;
use Provisioning\Form\GroupAddcgForm;
use Provisioning\Form\GroupAccessDeviceAddcgActionForm;
use Provisioning\Form\UserAddcgForm;
use Provisioning\Form\ServiceProviderdnAddListcgForm;
use Provisioning\Form\GroupdnAssignListcgForm;
use Provisioning\Form\UserModifycgForm;
use Provisioning\Form\UserAuthenticationModifycgForm;
use Provisioning\Form\GroupdnActivateListcgForm;
use Provisioning\Form\GroupDeleteegForm;
use Provisioning\Form\ServiceProviderdnDeleteListegForm;


use Preference\Dao\PreferenceDao;
use Generic\Controller\GenericController;
use Provisioning\Service\XmlService;
use Provisioning\Service\OCISoapService;

class OrderController extends GenericController
{ 
    public $serviceDao;
    
    public function indexAction() {
        
        if (! $this->getServiceLocator()
                 ->get('AuthService')->hasIdentity()){
            return $this->redirect()->toRoute('auth');
        }
        
        $_SESSION['current']            = "order";
        $_SESSION['activities']         = null;
        $_SESSION['current_priority']   = null; 

        return;
    }

    public function filterAction(){

        $model = new JsonModel();

        $request = $this->getRequest();
        if($request->isPost()){
            $post   = (array)$request->getPost();
            $limit  = isset( $post['limit'] ) ?  $post['limit'] : null;
            $offset = $post['offset'];
            $order  = $post['order'];
            $sort   = $post['sort'];

            $filters = array_key_exists('filters',$post) ? $post['filters'] : null;

            if($filters)
            foreach ($filters as $key => $value) {
                if (strpos($key,'QGDATE') !== false) {
                    if(stripos($value,":") !== false){
                        $filters[$key] = $this->convertToUTC($value);
                    } else {
                        $filters[$key] = $this->convertToUTC($value,array('date'=>true));
                    }
                    //print $filters[$key] . "\n";
                }
            }

            $result = $this->getDao()->fetchFilter($limit,$offset,$order,$sort,$filters);
        } 

        $items = array();
        foreach ($result['resultSet'] as $item) {
            $item->nexusid = $item->id;
            foreach ($item as $key => $value) {

                //Aqui se hace alguna transformación que los valores del grid requieran
                //$value      = $this->translator($value);
                //$item->$key = $value;

                if($this->isDate($value)){
                    if(stripos($value,":") === false){
                        $item->$key = $this->convertFromUTC($value,array('date'=>true));
                    } else {
                        $item->$key = $this->convertFromUTC($value);
                    }  
                }

                if($key == "nexusid" || $key == "cisid"){
                    $url = $this->url()->fromRoute('order',array('action'=>'view','id'=>$item->id));
                    $item->$key = "<a href='".$url."'>".$value."</a>";
                }
            }

            array_push($items, $item);
        }

        $model->setVariable("status","success");
        $model->setVariable("payload",array(
            "total"     =>  $result['total'],
            "items"     =>  $items,
        ));

        return $model;
    }
    
    public function listAction()
    {
        if (! $this->getServiceLocator()
                 ->get('AuthService')->hasIdentity()){
            return $this->redirect()->toRoute('auth');
        }

        $cisid = $this->params()->fromRoute('id');
         
        return new ViewModel(array('cisid'=>$cisid));
    }

    public function viewAction()
    {
        $id         = $this->params()->fromRoute('id');
        
        $order  = $this->getDao("OrderDao")->get($id);
        $StatusId = $order->getStatusId();
        if($StatusId<>2){
            $order->setStatusId(2); 
            $order->setId($this->getDao()->save($order));
        }
        
        $order      = $this->getDao()->getOrder($id);
        $xmlFetch   = $this->getDao("XmlDao")->fetchByOrderId($order->id);
        $group     = $this->getDao("GroupDao")->get($order->groupId);

            $devices    = $this->getDao("DeviceDao")->fetchByGroupId($group->id);
            $devicesArray = array();
            foreach ($devices as $device) {
                $devicesArray[] = $device;
            }

            $group->devices = $devicesArray;
            
        

        return new ViewModel(array(
            'order'     => $order,
            //'customer'  => $customer,
            'group'     => $group,
            'xmls'      => $xmlFetch,
        ));
    }
    

    public function addAction()
    {
        if (! $this->getServiceLocator()
                 ->get('AuthService')->hasIdentity()){
            return $this->redirect()->toRoute('auth');
        }

        $id     = $this->params()->fromRoute('id');
        $order  = $this->getDao("OrderDao")->get($id);

        if(!$order){
            $order      = new Order();
        }

        

        $form = new OrderForm();
        $error = "";
        /**
         * Llenamos el select con los servicios
         */
        $caseSelect = $form->get('caseId');       
        $caseFetch = $this->getDao("CaseDao")->fetchAll();
        $serviceArray = array();
        foreach ($caseFetch as $case) {
            $caseArray[$case->id] = $case->name;
        }
        $caseSelect->setAttribute('options',$caseArray);
        
        
        /**
         * Llenamos la plataformas
         */
        $currentUser = (object)$this->getServiceLocator()->get('AuthService')->getIdentity();
        $order->setPlatformId($currentUser->platform_id);
        
        $request = $this->getRequest();
        if ($request->isPost()) {
            
            $form->setInputFilter($order->getInputFilter());

            $form->setData($request->getPost());
            
            if ($form->isValid()) {
                
                $order->setDateCreated(\date("Y-m-d H:i:s"));
                $order->setStatusId(1); // Status nuevo
                $order->setCisid($form->get("cisid")->getValue());
                //$order->setProductId($form->get("productId")->getValue());
                $order->setCaseId($form->get("caseId")->getValue());
                $order->setPlatformId($form->get("platformId")->getValue());
                $order->setDescription($form->get("description")->getValue());
                $order->setIntervention("manual");
                $order->setUserId($currentUser->id);
                $order->setCurrentStep(1);
                $order->setCurrentStep(1);

                $caseXmlTemplateFetch = $this->getDao("CaseXmlTemplateDao")
                                        ->fetchByCaseId($order->getCaseId());

                $activities = array();
                foreach ($caseXmlTemplateFetch as $caseXmlTemplate) {

                    $xmltemplate    = $this->getDao("XmlTemplateDao")
                                       ->get($caseXmlTemplate->xmltemplate_id);

                    $commandExploded = explode("Request",$xmltemplate->command);
                    $action = strtolower($commandExploded[0]);

                    $activities[ $caseXmlTemplate->priority ] = $action;
                }

                $_SESSION['activities']         = $activities; 

                $order->setTotalStep(count($activities));

                $thisStep = 0;
                if($thisStep > $order->getCompleteStep() ){
                    $order->setCompleteStep( $thisStep );
                }

                $order->setCurrentStep( $thisStep + 1 );

                $order->setId($this->getDao()->save($order));

                //$_SESSION['order_id'] = $order->getId();
                //$_SESSION['case_id']  = $order->getCaseId();                                     

                $this->next($order);

            } else {
                $error = $form->getMessages();
            }

        } 

        $form->setData($order->getArrayCopy());

        return new ViewModel(array(
            'form'  =>  $form,
            'error' =>  $error,
            'order' =>  $order,
            //'step'  =>  $step,
        ));
    }


    public function fetchbyAction()
    { 
         $id = $this->params()->fromRoute('id');
         
        $GroupFetch = $this->getDao('GroupDao')->fetchById($id);
        $groups = array();
        foreach ($GroupFetch as $grupos) {
            
            $groups[] = $grupos;
        }
        
        return new JsonModel($groups);
    }

     public function fetchbyProviderAction()
    { 
        $id = $this->params()->fromRoute('id');
         
        $domainFetch = $this->getDao('ProviderDao')->fetchBy_Id($id);
        $domains = array();
        foreach ($domainFetch as $domain) {
            
            $domains[] = $domain;
        }
        
        return new JsonModel($domains);
    }

    public function fetchbyUserIDAction()
    { 
         $id = $this->params()->fromRoute('id');
         
        $userFetch = $this->getDao('AdditionLineDao')->fetchByUserId($id);
        $users = array();
        foreach ($userFetch as $usuarios) {
            
            $users[] = $usuarios;
        }
        
        return new JsonModel($users);
    }

    public function fetchbyGroupAction()
    { 
         $id = $this->params()->fromRoute('id');
         
        $groupFetch = $this->getDao('GroupDao')->fetchById($id);
        $groups = array();
        foreach ($groupFetch as $group) {
            $groups[] = $group;
        }
        
        return new JsonModel($groups);
    }

    public function serviceproviderdndeletelistegAction(){

        $deletegroup = new DeleteGroup();
        $form = new ServiceProviderdnDeleteListegForm();

        $id     = $this->params()->fromRoute('id');
        $order  = $this->getDao("OrderDao")->get($id);
        $error=""; 



        $request = $this->getRequest();

        if ($request->isPost()) {
            
            $form->setData($request->getPost());
             
            if ($form->isValid()) {

               
                
                $numero = $form->get("numero")->getValue();
                
                $fechaHora = date("Y-m-d H:i:s");                
                $deletegroup->setid_service_provider('Business_Line');
                $deletegroup->setid_order($id);
                $deletegroup->setcommand('ServiceProviderDnDeleteListegRequest');      
                $deletegroup->setcreatedate($fechaHora); 
                $deletegroup->setnumber_empresa($numero);  

                
                
                $deletegroup->setId( $this->getDao("DeleteGroupDao")->save($deletegroup) );
                $this->generateXml('list','ServiceProviderDnDeleteListegRequest',$deletegroup,$order);
 
                $thisStep = (int)array_search(explode('Action',__FUNCTION__)[0],$_SESSION['activities']);
                if($thisStep > $order->getCompleteStep() ){
                    $order->setCompleteStep( $thisStep );
                }

                $order->setCurrentStep( $thisStep + 1 );
                $order->setId( $this->getDao("OrderDao")->save($order) );

                $this->next($order);
            }


        }
        
        $form->setData($order->getArrayCopy());
        return new ViewModel(array(
            'form'   =>  $form,
            'error'  =>  $error,
            'order'  =>  $order,
        ));


    }

    public function groupdeleteegAction(){

        $deletegroup = new DeleteGroup();
        $form = new GroupDeleteegForm();

        $id     = $this->params()->fromRoute('id');
        $order  = $this->getDao("OrderDao")->get($id);
        $error=""; 

        $groupidSelect = $form->get('groupid');
        $GroupFetch = $this->getDao("GroupDao")->fetchAll();
        $groupArray = array();
        foreach ($GroupFetch as $group) {
            $groupArray[$group->name]=$group->name;                
        }

        $groupidSelect->setAttribute('options',$groupArray);

        $request = $this->getRequest();

        if ($request->isPost()) {
            
            $form->setData($request->getPost());
             
            if ($form->isValid()) {

               
                
                $groupid = $form->get("groupid")->getValue();
                
                $fechaHora = date("Y-m-d H:i:s");                
                $deletegroup->setid_service_provider('Business_Line');
                $deletegroup->setid_order($id);
                $deletegroup->setcommand('GroupDeleteegRequest');      
                $deletegroup->setcreatedate($fechaHora); 
                $deletegroup->setid_group($groupid);  

                $order->setGroupId($groupid);
                
                $deletegroup->setId( $this->getDao("DeleteGroupDao")->save($deletegroup) );
                $this->generateXml('delete','GroupDeleteegRequest',$deletegroup,$order);
 
                $thisStep = (int)array_search(explode('Action',__FUNCTION__)[0],$_SESSION['activities']);
                if($thisStep > $order->getCompleteStep() ){
                    $order->setCompleteStep( $thisStep );
                }

                $order->setCurrentStep( $thisStep + 1 );
                $order->setId( $this->getDao("OrderDao")->save($order) );

                $this->next($order);
            }


        }
        
        $form->setData($order->getArrayCopy());
        return new ViewModel(array(
            'form'   =>  $form,
            'error'  =>  $error,
            'order'  =>  $order,
        ));


    }

    public function groupseriescompletionaddinstancecgAction(){
        $creationgroup = new CreationGroup();
        

        $id     = $this->params()->fromRoute('id');
        $order  = $this->getDao("OrderDao")->get($id);
        $error=""; 

        $creationgroupFetch = $this->getDao("CreationGroupDao")->fetchByOrderIdUserID($id);
        foreach ($creationgroupFetch as $creationgroupdatum) {
            $groupid = $creationgroupdatum->id_group;
            $userid = $creationgroupdatum->id_user;
        }
        
        $fechaHora = date("Y-m-d H:i:s");                
        $creationgroup->settype('CreationGroup');
        $creationgroup->setid_order($id);
        $creationgroup->setcommand('GroupSeriesCompletionAddInstancecgRequest');      
        $creationgroup->setcreatedate($fechaHora); 
        $creationgroup->setid_group($groupid); 
        $creationgroup->setname('Empresa_BL_B');
        $creationgroup->setid_user($userid);   
        
    
        
        $creationgroup->setId( $this->getDao("CreationGroupDao")->save($creationgroup) );
        $this->generateXml('add','GroupSeriesCompletionAddInstancecgRequest',$creationgroup,$order);

        $thisStep = (int)array_search(explode('Action',__FUNCTION__)[0],$_SESSION['activities']);
        if($thisStep > $order->getCompleteStep() ){
            $order->setCompleteStep( $thisStep );
        }

        $order->setCurrentStep( $thisStep + 1 );
        $order->setId( $this->getDao("OrderDao")->save($order) );

        $this->next($order);
        
    }
    

    public function groupdnactivatelistcgAction(){
       $creationgroup = new CreationGroup();
        $form = new GroupdnActivateListcgForm();

        $id     = $this->params()->fromRoute('id');
        $order  = $this->getDao("OrderDao")->get($id);
        $error=""; 

        $request = $this->getRequest();

        if ($request->isPost()) {
            
            $form->setData($request->getPost());
             
            if ($form->isValid()) {

                $creationgroupFetch = $this->getDao("CreationGroupDao")->fetchByOrderIdUserID($id);
                foreach ($creationgroupFetch as $creationgroupdatum) {
                    $groupid = $creationgroupdatum->id_group;
                }
                
                $username = $form->get("number")->getValue();
                
                $fechaHora = date("Y-m-d H:i:s");                
                $creationgroup->settype('CreationGroup');
                $creationgroup->setid_order($id);
                $creationgroup->setcommand('GroupDnActivateListcgRequest');      
                $creationgroup->setcreatedate($fechaHora); 
                $creationgroup->setid_group($groupid);  
                $creationgroup->setnumber_activar($username);  
                
                $creationgroup->setId( $this->getDao("CreationGroupDao")->save($creationgroup) );
                $this->generateXml('list','GroupDnActivateListcgRequest',$creationgroup,$order);
 
                $thisStep = (int)array_search(explode('Action',__FUNCTION__)[0],$_SESSION['activities']);
                if($thisStep > $order->getCompleteStep() ){
                    $order->setCompleteStep( $thisStep );
                }

                $order->setCurrentStep( $thisStep + 1 );
                $order->setId( $this->getDao("OrderDao")->save($order) );

                $this->next($order);
            }


        }
        
        $form->setData($order->getArrayCopy());
        return new ViewModel(array(
            'form'   =>  $form,
            'error'  =>  $error,
            'order'  =>  $order,
        ));
        
    }

    public function userauthenticationmodifycgAction(){
       $creationgroup = new CreationGroup();
        $form = new UserAuthenticationModifycgForm();

        $id     = $this->params()->fromRoute('id');
        $order  = $this->getDao("OrderDao")->get($id);
        $error=""; 

        $request = $this->getRequest();

        if ($request->isPost()) {
            
            $form->setData($request->getPost());
             
            if ($form->isValid()) {

                $creationgroupFetch = $this->getDao("CreationGroupDao")->fetchByOrderIdUserID($id);
                foreach ($creationgroupFetch as $creationgroupdatum) {
                    $groupid = $creationgroupdatum->id_group;
                    $userid = $creationgroupdatum->id_user;
                }
                
                $username = $form->get("username")->getValue();
                
                $fechaHora = date("Y-m-d H:i:s");                
                $creationgroup->settype('CreationGroup');
                $creationgroup->setid_order($id);
                $creationgroup->setcommand('UserAuthenticationModifycgRequest');      
                $creationgroup->setcreatedate($fechaHora); 
                $creationgroup->setid_group($groupid);  
                $creationgroup->setid_user($userid);  
                $creationgroup->setusername($username); 
                $creationgroup->setnewpassword('npswrdquantic'); 
                
                $creationgroup->setId( $this->getDao("CreationGroupDao")->save($creationgroup) );
                $this->generateXml('modify','UserAuthenticationModifycgRequest',$creationgroup,$order);
 
                $thisStep = (int)array_search(explode('Action',__FUNCTION__)[0],$_SESSION['activities']);
                if($thisStep > $order->getCompleteStep() ){
                    $order->setCompleteStep( $thisStep );
                }

                $order->setCurrentStep( $thisStep + 1 );
                $order->setId( $this->getDao("OrderDao")->save($order) );

                $this->next($order);
            }


        }
        
        $form->setData($order->getArrayCopy());
        return new ViewModel(array(
            'form'   =>  $form,
            'error'  =>  $error,
            'order'  =>  $order,
        ));
        
    }


     public function groupcallprocessingmodifypolicycgAction(){
        $creationgroup = new CreationGroup();
        

        $id     = $this->params()->fromRoute('id');
        $order  = $this->getDao("OrderDao")->get($id);
        $error=""; 

        $creationgroupFetch = $this->getDao("CreationGroupDao")->fetchByOrderId($id);
        foreach ($creationgroupFetch as $creationgroupdatum) {
            $groupid = $creationgroupdatum->id_group;
        }
        
        $fechaHora = date("Y-m-d H:i:s");                
        $creationgroup->settype('CreationGroup');
        $creationgroup->setid_order($id);
        $creationgroup->setcommand('GroupCallProcessingModifyPolicycgRequest15sp2');      
        $creationgroup->setcreatedate($fechaHora); 
        $creationgroup->setid_group($groupid); 
    
        
        $creationgroup->setId( $this->getDao("CreationGroupDao")->save($creationgroup) );
        $this->generateXml('modify','GroupCallProcessingModifyPolicycgRequest15sp2',$creationgroup,$order);

        $thisStep = (int)array_search(explode('Action',__FUNCTION__)[0],$_SESSION['activities']);
        if($thisStep > $order->getCompleteStep() ){
            $order->setCompleteStep( $thisStep );
        }

        $order->setCurrentStep( $thisStep + 1 );
        $order->setId( $this->getDao("OrderDao")->save($order) );

        $this->next($order);
        
    }

     public function userserviceassignlistcgAction(){
        $creationgroup = new CreationGroup();
        

        $id     = $this->params()->fromRoute('id');
        $order  = $this->getDao("OrderDao")->get($id);
        $error=""; 

       $creationgroupFetch = $this->getDao("CreationGroupDao")->fetchByOrderIdUserID($id);
       foreach ($creationgroupFetch as $creationgroupdatum) {
            $groupid = $creationgroupdatum->id_group;
            $userid = $creationgroupdatum->id_user;
        }
        
        $fechaHora = date("Y-m-d H:i:s");                
        $creationgroup->settype('CreationGroup');
        $creationgroup->setid_order($id);
        $creationgroup->setcommand('UserServiceAssignListcgRequest');      
        $creationgroup->setcreatedate($fechaHora); 
        $creationgroup->setid_group($groupid); 
        $creationgroup->setid_user($userid);  
        
        $creationgroup->setId( $this->getDao("CreationGroupDao")->save($creationgroup) );
        $this->generateXml('list','UserServiceAssignListcgRequest',$creationgroup,$order);

        $thisStep = (int)array_search(explode('Action',__FUNCTION__)[0],$_SESSION['activities']);
        if($thisStep > $order->getCompleteStep() ){
            $order->setCompleteStep( $thisStep );
        }

        $order->setCurrentStep( $thisStep + 1 );
        $order->setId( $this->getDao("OrderDao")->save($order) );

        $this->next($order);
        
    }

     public function groupserviceassignlistcgAction(){
        $creationgroup = new CreationGroup();
        

        $id     = $this->params()->fromRoute('id');
        $order  = $this->getDao("OrderDao")->get($id);
        $error=""; 

        $creationgroupFetch = $this->getDao("CreationGroupDao")->fetchByOrderId($id);
        foreach ($creationgroupFetch as $creationgroupdatum) {
            $groupid = $creationgroupdatum->id_group;
        }
        
        $fechaHora = date("Y-m-d H:i:s");                
        $creationgroup->settype('CreationGroup');
        $creationgroup->setid_order($id);
        $creationgroup->setcommand('GroupServiceAssignListcgRequest');      
        $creationgroup->setcreatedate($fechaHora); 
        $creationgroup->setid_group($groupid);  
        
        $creationgroup->setId( $this->getDao("CreationGroupDao")->save($creationgroup) );
        $this->generateXml('list','GroupServiceAssignListcgRequest',$creationgroup,$order);

        $thisStep = (int)array_search(explode('Action',__FUNCTION__)[0],$_SESSION['activities']);
        if($thisStep > $order->getCompleteStep() ){
            $order->setCompleteStep( $thisStep );
        }

        $order->setCurrentStep( $thisStep + 1 );
        $order->setId( $this->getDao("OrderDao")->save($order) );

        $this->next($order);
        
    }

    public function groupservicemodifyauthorizationlistcgAction(){
        $creationgroup = new CreationGroup();
        

        $id     = $this->params()->fromRoute('id');
        $order  = $this->getDao("OrderDao")->get($id);
        $error=""; 

        $creationgroupFetch = $this->getDao("CreationGroupDao")->fetchByOrderId($id);
        foreach ($creationgroupFetch as $creationgroupdatum) {
            $groupid = $creationgroupdatum->id_group;
        }
        
        $fechaHora = date("Y-m-d H:i:s");                
        $creationgroup->settype('CreationGroup');
        $creationgroup->setid_order($id);
        $creationgroup->setcommand('GroupServiceModifyAuthorizationListcgRequest');      
        $creationgroup->setcreatedate($fechaHora); 
        $creationgroup->setid_group($groupid);  

        $creationgroup->setId( $this->getDao("CreationGroupDao")->save($creationgroup) );
        $this->generateXml('modify','GroupServiceModifyAuthorizationListcgRequest',$creationgroup,$order);

        $thisStep = (int)array_search(explode('Action',__FUNCTION__)[0],$_SESSION['activities']);
        if($thisStep > $order->getCompleteStep() ){
            $order->setCompleteStep( $thisStep );
        }

        $order->setCurrentStep( $thisStep + 1 );
        $order->setId( $this->getDao("OrderDao")->save($order) );

        $this->next($order);
        
    }

    public function serviceproviderservicemodifyauthorizationlistcgAction(){
        $creationgroup = new CreationGroup();
        

        $id     = $this->params()->fromRoute('id');
        $order  = $this->getDao("OrderDao")->get($id);
        $error=""; 

        $creationgroupFetch = $this->getDao("CreationGroupDao")->fetchByOrderId($id);
        foreach ($creationgroupFetch as $creationgroupdatum) {
            $groupid = $creationgroupdatum->id_group;
        }
        
        $fechaHora = date("Y-m-d H:i:s");                
        $creationgroup->settype('CreationGroup');
        $creationgroup->setid_order($id);
        $creationgroup->setcommand('ServiceProviderServiceModifyAuthorizationListcgRequest');      
        $creationgroup->setcreatedate($fechaHora); 
        $creationgroup->setid_group($groupid);  
         
          
        
        
        $creationgroup->setId( $this->getDao("CreationGroupDao")->save($creationgroup) );
        $this->generateXml('modify','ServiceProviderServiceModifyAuthorizationListcgRequest',$creationgroup,$order);

        $thisStep = (int)array_search(explode('Action',__FUNCTION__)[0],$_SESSION['activities']);
        if($thisStep > $order->getCompleteStep() ){
            $order->setCompleteStep( $thisStep );
        }

        $order->setCurrentStep( $thisStep + 1 );
        $order->setId( $this->getDao("OrderDao")->save($order) );

        $this->next($order);
        
    }


    public function usermodifycgAction(){
        $creationgroup = new CreationGroup();
        $form = new UserModifycgForm();

        $id     = $this->params()->fromRoute('id');
        $order  = $this->getDao("OrderDao")->get($id);
        $error=""; 

        $request = $this->getRequest();

        if ($request->isPost()) {
            
            $form->setData($request->getPost());
             
            if ($form->isValid()) {

                $creationgroupFetch = $this->getDao("CreationGroupDao")->fetchByOrderIdUserID($id);
                foreach ($creationgroupFetch as $creationgroupdatum) {
                    $groupid = $creationgroupdatum->id_group;
                    $userid = $creationgroupdatum->id_user;
                }
                
                $numero = $form->get("numero")->getValue();
                $deviceLevel = $form->get("deviceLevel")->getValue();
                $deviceName = $form->get("deviceName")->getValue();
                $lineport = $form->get("lineport")->getValue();

                

                $fechaHora = date("Y-m-d H:i:s");                
                $creationgroup->settype('CreationGroup');
                $creationgroup->setid_order($id);
                $creationgroup->setcommand('UserModifycgRequest17sp4');      
                $creationgroup->setcreatedate($fechaHora); 
                $creationgroup->setid_group($groupid);  
                $creationgroup->setid_user($userid);  
                $creationgroup->setnumber_usuario($numero); 
                $creationgroup->setdevicename($deviceName); 
                $creationgroup->setdevicelevel($deviceLevel); 
                $creationgroup->setlineport($lineport); 
                  
                
                
                $creationgroup->setId( $this->getDao("CreationGroupDao")->save($creationgroup) );
                $this->generateXml('modify','UserModifycgRequest17sp4',$creationgroup,$order);
 
                $thisStep = (int)array_search(explode('Action',__FUNCTION__)[0],$_SESSION['activities']);
                if($thisStep > $order->getCompleteStep() ){
                    $order->setCompleteStep( $thisStep );
                }

                $order->setCurrentStep( $thisStep + 1 );
                $order->setId( $this->getDao("OrderDao")->save($order) );

                $this->next($order);
            }


        }
        
        $form->setData($order->getArrayCopy());
        return new ViewModel(array(
            'form'   =>  $form,
            'error'  =>  $error,
            'order'  =>  $order,
        ));
    }

    public function groupdnassignlistcgAction(){
        $creationgroup = new CreationGroup();
        $form = new GroupdnAssignListcgForm();

        $id     = $this->params()->fromRoute('id');
        $order  = $this->getDao("OrderDao")->get($id);
        $error=""; 

        $request = $this->getRequest();

        if ($request->isPost()) {
            
            $form->setData($request->getPost());
             
            if ($form->isValid()) {

                $creationgroupFetch = $this->getDao("CreationGroupDao")->fetchByOrderId($id);
                foreach ($creationgroupFetch as $creationgroupdatum) {
                    $groupid = $creationgroupdatum->id_group;
                }
                
                $numero = $form->get("numero")->getValue();
                

                $fechaHora = date("Y-m-d H:i:s");                
                $creationgroup->settype('CreationGroup');
                $creationgroup->setid_order($id);
                $creationgroup->setcommand('GroupDnAssignListcgRequest');      
                $creationgroup->setcreatedate($fechaHora); 
                $creationgroup->setid_group($groupid);  
                $creationgroup->setnumber_grupo($numero);   
                
                
                $creationgroup->setId( $this->getDao("CreationGroupDao")->save($creationgroup) );
                $this->generateXml('list','GroupDnAssignListcgRequest',$creationgroup,$order);
 
                $thisStep = (int)array_search(explode('Action',__FUNCTION__)[0],$_SESSION['activities']);
                if($thisStep > $order->getCompleteStep() ){
                    $order->setCompleteStep( $thisStep );
                }

                $order->setCurrentStep( $thisStep + 1 );
                $order->setId( $this->getDao("OrderDao")->save($order) );

                $this->next($order);
            }


        }
        
        $form->setData($order->getArrayCopy());
        return new ViewModel(array(
            'form'   =>  $form,
            'error'  =>  $error,
            'order'  =>  $order,
        ));
    }

    public function serviceproviderdnaddlistcgAction(){
        $creationgroup = new CreationGroup();
        $form = new ServiceProviderdnAddListcgForm();

        $id     = $this->params()->fromRoute('id');
        $order  = $this->getDao("OrderDao")->get($id);
        $error=""; 

        $request = $this->getRequest();

        if ($request->isPost()) {
            
            $form->setData($request->getPost());
             
            if ($form->isValid()) {

                $creationgroupFetch = $this->getDao("CreationGroupDao")->fetchByOrderId($id);
                foreach ($creationgroupFetch as $creationgroupdatum) {
                    $groupid = $creationgroupdatum->id_group;
                }
                
                $numero = $form->get("numero")->getValue();
                

                $fechaHora = date("Y-m-d H:i:s");                
                $creationgroup->settype('CreationGroup');
                $creationgroup->setid_order($id);
                $creationgroup->setcommand('ServiceProviderDnAddListcgRequest');      
                $creationgroup->setcreatedate($fechaHora); 
                $creationgroup->setid_group($groupid);  
                $creationgroup->setnumber_empresa($numero);   
                
                
                $creationgroup->setId( $this->getDao("CreationGroupDao")->save($creationgroup) );
                $this->generateXml('add','ServiceProviderDnAddListcgRequest',$creationgroup,$order);
 
                $thisStep = (int)array_search(explode('Action',__FUNCTION__)[0],$_SESSION['activities']);
                if($thisStep > $order->getCompleteStep() ){
                    $order->setCompleteStep( $thisStep );
                }

                $order->setCurrentStep( $thisStep + 1 );
                $order->setId( $this->getDao("OrderDao")->save($order) );

                $this->next($order);
            }


        }
        
        $form->setData($order->getArrayCopy());
        return new ViewModel(array(
            'form'   =>  $form,
            'error'  =>  $error,
            'order'  =>  $order,
        ));






    }

    public function useraddcgAction(){
        $creationgroup = new CreationGroup();
        $form = new UserAddcgForm();

        $id     = $this->params()->fromRoute('id');
        $order  = $this->getDao("OrderDao")->get($id);
        $error="";   

        

        $error = "";
        $request = $this->getRequest();

        if ($request->isPost()) {
            
            $form->setData($request->getPost());
             
            if ($form->isValid()) {

                $creationgroupFetch = $this->getDao("CreationGroupDao")->fetchByOrderId($id);
                foreach ($creationgroupFetch as $creationgroupdatum) {
                    $groupid = $creationgroupdatum->id_group;
                }
                
                $userid = $form->get("userid")->getValue();
                $firstname = $form->get("firstname")->getValue();
                $lastname = $form->get("lastname")->getValue();
                $callingLineidfirstname = $form->get("callingLineidfirstname")->getValue();
                $callinglineidlastname = $form->get("callinglineidlastname")->getValue();
                $lenguague = $form->get("lenguague")->getValue();
                $timezone = $form->get("timezone")->getValue();

                $fechaHora = date("Y-m-d H:i:s");                
                $creationgroup->settype('CreationGroup');
                $creationgroup->setid_order($id);
                $creationgroup->setcommand('UserAddcgRequest17sp4');      
                $creationgroup->setcreatedate($fechaHora); 
                $creationgroup->setid_group($groupid);  
                $creationgroup->setid_user($userid);   
                $creationgroup->setfirstname($firstname);   
                $creationgroup->setlastname($lastname);   
                $creationgroup->setpassword('npswrdquantic'); 

                $creationgroup->setcallinglineidfirstname($callingLineidfirstname);   
                $creationgroup->setcallinglineidlastname($callinglineidlastname);   
                $creationgroup->setlanguague($lenguague);   
                $creationgroup->settimezone($timezone);   
                
                $creationgroup->setId( $this->getDao("CreationGroupDao")->save($creationgroup) );
                $this->generateXml('add','UserAddcgRequest17sp4',$creationgroup,$order);
 
                $thisStep = (int)array_search(explode('Action',__FUNCTION__)[0],$_SESSION['activities']);
                if($thisStep > $order->getCompleteStep() ){
                    $order->setCompleteStep( $thisStep );
                }

                $order->setCurrentStep( $thisStep + 1 );
                $order->setId( $this->getDao("OrderDao")->save($order) );

                $this->next($order);
            }


        }
        
        $form->setData($order->getArrayCopy());
        return new ViewModel(array(
            'form'   =>  $form,
            'error'  =>  $error,
            'order'  =>  $order,
        ));



    }
    
     public function groupaccessdeviceaddcgAction(){


        $creationgroup = new CreationGroup();
        $form = new GroupAccessDeviceAddcgActionForm();

        $id     = $this->params()->fromRoute('id');
        $order  = $this->getDao("OrderDao")->get($id);
        $error="";   

        $devicetypeSelect = $form->get('devicetype');
        $devicetypeFetch = $this->getDao("DeviceTypeDao")->fetchAll();
        $devicetypeArray = array();
        foreach ($devicetypeFetch as $devicetype) {
            $devicetypeArray[$devicetype->type]=$devicetype->type;                
        }

        $devicetypeSelect->setAttribute('options',$devicetypeArray);

        $error = "";
        $request = $this->getRequest();

        if ($request->isPost()) {
            
            $form->setData($request->getPost());
             
            if ($form->isValid()) {

                $creationgroupFetch = $this->getDao("CreationGroupDao")->fetchByOrderId($id);
                foreach ($creationgroupFetch as $creationgroupdatum) {
                    $groupid = $creationgroupdatum->id_group;
                }
                
                $devicename = $form->get("devicename")->getValue();
                $devicetype = $form->get("devicetype")->getValue();
                $protocol = $form->get("protocol")->getValue();

                $fechaHora = date("Y-m-d H:i:s");                
                $creationgroup->settype('CreationGroup');
                $creationgroup->setid_order($id);
                $creationgroup->setcommand('GroupAccessDeviceAddcgRequest14');      
                $creationgroup->setcreatedate($fechaHora); 
                $creationgroup->setid_group($groupid);  
                $creationgroup->setdevicename($devicename);   
                $creationgroup->setdevicetype($devicetype);   
                $creationgroup->setprotocol($protocol);   
                
                
                $creationgroup->setId( $this->getDao("CreationGroupDao")->save($creationgroup) );

                $this->generateXml('add','GroupAccessDeviceAddcgRequest14',$creationgroup,$order);
 
                $thisStep = (int)array_search(explode('Action',__FUNCTION__)[0],$_SESSION['activities']);
                if($thisStep > $order->getCompleteStep() ){
                    $order->setCompleteStep( $thisStep );
                }

                $order->setCurrentStep( $thisStep + 1 );
                $order->setId( $this->getDao("OrderDao")->save($order) );

                $this->next($order);
            }


        }
        
        $form->setData($order->getArrayCopy());
        return new ViewModel(array(
            'form'   =>  $form,
            'error'  =>  $error,
            'order'  =>  $order,
        ));
        



    }


    public function groupaddcgAction(){


        $creationgroup = new CreationGroup();
        $form = new GroupAddcgForm();

        $id     = $this->params()->fromRoute('id');
        $order  = $this->getDao("OrderDao")->get($id);
        $error="";   

        $groupidSelect = $form->get('groupid');
        $GroupFetch = $this->getDao("GroupDao")->fetchAll();
        $groupArray = array();
        foreach ($GroupFetch as $group) {
            $groupArray[$group->name]=$group->name;                
        }

        $groupidSelect->setAttribute('options',$groupArray);

        $error = "";
        $request = $this->getRequest();

        if ($request->isPost()) {
            
            $form->setData($request->getPost());
             
            if ($form->isValid()) {
                
                $groupid = $form->get("groupid")->getValue();
                $domain = $form->get("domain")->getValue();
                $userlimit = $form->get("userlimit")->getValue();
                $groupname = $form->get("groupname")->getValue();
                $callingLineIdName = $form->get("callingLineIdName")->getValue();
                $timezone = $form->get("timezone")->getValue();
                $contactname = $form->get("contactname")->getValue();
                $contactnumber = $form->get("contactnumber")->getValue();

                
               
                $fechaHora = date("Y-m-d H:i:s");                
                $creationgroup->settype('CreationGroup');
                $creationgroup->setid_order($id);
                $creationgroup->setcommand('GroupAddcgRequest');      
                $creationgroup->setcreatedate($fechaHora); 
                $creationgroup->setid_group($groupid);  
                $creationgroup->setgroupname($groupname);   
                $creationgroup->setdomain($domain);   
                $creationgroup->setuserlimit($userlimit);   
                $creationgroup->setcallinglineidname($callingLineIdName);   
                $creationgroup->settimezone($timezone);   
                $creationgroup->setcontactname($contactname);   
                $creationgroup->setcontactnumber($contactnumber);   

                $order->setGroupId($groupid);
                $creationgroup->setId( $this->getDao("CreationGroupDao")->save($creationgroup) );

                $this->generateXml('add','GroupAddcgRequest',$creationgroup,$order);
 
                $thisStep = (int)array_search(explode('Action',__FUNCTION__)[0],$_SESSION['activities']);
                if($thisStep > $order->getCompleteStep() ){
                    $order->setCompleteStep( $thisStep );
                }

                $order->setCurrentStep( $thisStep + 1 );
                $order->setId( $this->getDao("OrderDao")->save($order) );

                $this->next($order);
            }


        }
        
        $form->setData($order->getArrayCopy());
        return new ViewModel(array(
            'form'   =>  $form,
            'error'  =>  $error,
            'order'  =>  $order,
        ));
        



    }

     public function serviceproviderdndeletelistelAction(){

        $deleteline = new DeleteLine();

        $form = new ServiceProviderdnDeleteListelForm();


        $id     = $this->params()->fromRoute('id');
        $order  = $this->getDao("OrderDao")->get($id);
        $error="";   

        
        $error = "";
        $request = $this->getRequest();

        if ($request->isPost()) {
            
            $form->setData($request->getPost());
             
            if ($form->isValid()) {
                
                $number = $form->get("numero")->getValue();
                
                $DeleteLineFetch = $this->getDao("DeleteLineDao")->fetchByOrderId($id);
                foreach ($DeleteLineFetch as $deletelinedatum) {
                    $id_group = $deletelinedatum->id_group;                    
                }
               
                $fechaHora = date("Y-m-d H:i:s");                
                $deleteline->settype('Deleteline');
                $deleteline->setid_order($id);
                $deleteline->setcommand('ServiceProviderDnDeleteListelRequest');      
                $deleteline->setcreatedate($fechaHora); 
                $deleteline->setid_group($id_group);    
                $deleteline->setnumber_empresa($number);   
                $order->setGroupId($id_group);
                $deleteline->setId( $this->getDao("DeleteLineDao")->save($deleteline) );

                $this->generateXml('delete','ServiceProviderDnDeleteListelRequest',$deleteline,$order);
 
                $thisStep = (int)array_search(explode('Action',__FUNCTION__)[0],$_SESSION['activities']);
                if($thisStep > $order->getCompleteStep() ){
                    $order->setCompleteStep( $thisStep );
                }

                $order->setCurrentStep( $thisStep + 1 );
                $order->setId( $this->getDao("OrderDao")->save($order) );

                $this->next($order);
            }


        }
        
        $form->setData($order->getArrayCopy());
        return new ViewModel(array(
            'form'   =>  $form,
            'error'  =>  $error,
            'order'  =>  $order,
        ));
        

    }

    public function groupdnunassignlistelAction(){

        $deleteline = new DeleteLine();

        $form = new GroupdnunAssignListelForm();


        $id     = $this->params()->fromRoute('id');
        $order  = $this->getDao("OrderDao")->get($id);
        $error="";   

        
        $error = "";
        $request = $this->getRequest();

        if ($request->isPost()) {
            
            $form->setData($request->getPost());
             
            if ($form->isValid()) {
                
                $number = $form->get("numero")->getValue();
                
                $DeleteLineFetch = $this->getDao("DeleteLineDao")->fetchByOrderId($id);
                foreach ($DeleteLineFetch as $deletelinedatum) {
                    $id_group = $deletelinedatum->id_group;                    
                }
               
                $fechaHora = date("Y-m-d H:i:s");                
                $deleteline->settype('Deleteline');
                $deleteline->setid_order($id);
                $deleteline->setcommand('GroupDnUnassignListelRequest');      
                $deleteline->setcreatedate($fechaHora); 
                $deleteline->setid_group($id_group);    
                $deleteline->setnumber_grupo($number);   
                $order->setGroupId($id_group);
                $deleteline->setId( $this->getDao("DeleteLineDao")->save($deleteline) );

                $this->generateXml('list','GroupDnUnassignListelRequest',$deleteline,$order);
 
                $thisStep = (int)array_search(explode('Action',__FUNCTION__)[0],$_SESSION['activities']);
                if($thisStep > $order->getCompleteStep() ){
                    $order->setCompleteStep( $thisStep );
                }

                $order->setCurrentStep( $thisStep + 1 );
                $order->setId( $this->getDao("OrderDao")->save($order) );

                $this->next($order);
            }


        }
        
        $form->setData($order->getArrayCopy());
        return new ViewModel(array(
            'form'   =>  $form,
            'error'  =>  $error,
            'order'  =>  $order,
        ));
        

    }


   public function groupcallprocessingmodifypolicyelAction(){

        $deleteline = new DeleteLine();        
        $id     = $this->params()->fromRoute('id');
        $order  = $this->getDao("OrderDao")->get($id);
        $error="";  

        $DeleteLineFetch = $this->getDao("DeleteLineDao")->fetchByOrderId($id);
        foreach ($DeleteLineFetch as $deletelinedatum) {
            $id_group = $deletelinedatum->id_group;                    
        }

        $fechaHora = date("Y-m-d H:i:s");                
        $deleteline->settype('Deleteline');
        $deleteline->setcommand('GroupCallProcessingModifyPolicyelRequest15sp2'); 
        $deleteline->setid_order($id…