function client_print_for_approval()
 {
     $qualifying_circulation_id = $this->params['named']['qualifying_circulation_id'];
     $printing_centers = $this->Session->read('Auth.PrintingCenter');
     $printing_center_ids = Set::extract('/id', $printing_centers);
     App::import('Model', 'QualifyingCirculation');
     $QualifyingCirculation = new QualifyingCirculation();
     $options = array('conditions' => array('QualifyingCirculation.id' => $qualifying_circulation_id, 'QualifyingCirculation.printing_center_id' => $printing_center_ids));
     $qualifyingCirculation = $QualifyingCirculation->find('first', $options);
     App::import('Model', 'Address');
     $objAddress = new Address();
     $options = array('conditions' => array('Address.id' => $qualifyingCirculation['DuplicateCopy']['0']['address_id']));
     $addr = $objAddress->find('first', $options);
     $qualifyingCirculation['DuplicateCopy'][0]['Address'] = $addr['Address'];
     $qualifyingCirculation['DuplicateCopy'][0]['City'] = $addr['City'];
     $qualifyingCirculation['DuplicateCopy'][0]['State'] = $addr['State'];
     $qualifyingCirculation['DuplicateCopy'][0]['Zone'] = $addr['Zone'];
     $qualifyingCirculation['DuplicateCopy'][0]['Country'] = $addr['Country'];
     // Printing Center Details
     App::import('Model', 'PrintingCenter');
     $objPrintingCenter = new PrintingCenter();
     $optionsPrintingCenter = array('contain' => array('Address', 'Membership', 'PrintedAt', 'Membership.Publication', 'Membership.Edition'), 'conditions' => array('PrintingCenter.id' => $qualifyingCirculation['PrintingCenter']['id']));
     $printingCenter = $objPrintingCenter->find('first', $optionsPrintingCenter);
     unset($qualifyingCirculation['PrintingCenter']['PrintingCenter']);
     unset($qualifyingCirculation['PrintingCenter']['QualifyingCirculation']);
     unset($qualifyingCirculation['PrintingCenter']['CreatedBy']);
     unset($qualifyingCirculation['PrintingCenter']['ModifiedBy']);
     unset($qualifyingCirculation['PrintingCenter']['Membership']['User']);
     unset($qualifyingCirculation['PrintingCenter']['Membership']['Address']);
     unset($qualifyingCirculation['PrintingCenter']['Membership']['Proposer1Representative']);
     unset($qualifyingCirculation['PrintingCenter']['Membership']['Proposer2Representative']);
     unset($qualifyingCirculation['PrintingCenter']['Membership']['CreatedBy']);
     unset($qualifyingCirculation['PrintingCenter']['Membership']['ModifiedBy']);
     unset($qualifyingCirculation['PrintingCenter']['Membership']['MembershipPayment']);
     unset($qualifyingCirculation['PrintingCenter']['Membership']['PrintingCenter']);
     unset($qualifyingCirculation['PrintingCenter']['Membership']['Representative']);
     // HoldingCompany.Address
     App::import('Model', 'HoldingCompany');
     $objHoldingCompany = new HoldingCompany();
     $optionsHoldingCompany = array('contain' => array('Address'), 'conditions' => array('HoldingCompany.id' => $printingCenter['Membership']['HoldingCompany'][0]['id']));
     $holdingCompany = $objHoldingCompany->find('first', $optionsHoldingCompany);
     // PrintingCenterAuditorBranch
     App::import('Model', 'PrintingCenterAuditorBranch');
     $objPrintingCenterAuditorBranch = new PrintingCenterAuditorBranch();
     $optionsPrintingCenterAuditorBranch = array('contain' => array('AuditorBranch', 'AuditorBranch.AuditorFirm'), 'conditions' => array('PrintingCenterAuditorBranch.printing_center_id' => $printingCenter['PrintingCenter']['id'], 'PrintingCenterAuditorBranch.regular_period_id' => $qualifyingCirculation['QualifyingCirculation']['regular_period_id']));
     $printingCenterAuditorBranch = $objPrintingCenterAuditorBranch->find('first', $optionsPrintingCenterAuditorBranch);
     $options = array('conditions' => array('Address.id' => $printingCenterAuditorBranch['AuditorBranch']['Address']['id']), 'contain' => array('Country', 'Zone', 'State', 'District', 'City'));
     $addr = $objAddress->find('first', $options);
     $printingCenterAuditorBranch['AuditorBranch']['Address'] = $addr['Address'];
     $printingCenterAuditorBranch['AuditorBranch']['Address']['Country'] = $addr['Country'];
     $printingCenterAuditorBranch['AuditorBranch']['Address']['Zone'] = $addr['Zone'];
     $printingCenterAuditorBranch['AuditorBranch']['Address']['State'] = $addr['State'];
     $printingCenterAuditorBranch['AuditorBranch']['Address']['District'] = $addr['District'];
     $printingCenterAuditorBranch['AuditorBranch']['Address']['City'] = $addr['City'];
     App::import('Model', 'SaleType');
     App::import('Model', 'TradeTerm');
     $SaleType = new SaleType();
     $TradeTerm = new TradeTerm();
     $saleTypes = $SaleType->find('list');
     $subscriptionTypes = $TradeTerm->SubscriptionType->find('list');
     App::import('Model', 'City');
     $objCities = new City();
     $cities = $objCities->find('all', array('conditions' => array('City.id' => Set::extract('/city_id', $qualifyingCirculation['WhiteForm']))));
     $this->set(compact('saleTypes', 'subscriptionTypes', 'qualifyingCirculation', 'cities', 'printingCenter', 'holdingCompany', 'printingCenterAuditorBranch'));
 }
Exemplo n.º 2
0
 function _getPcToNamed()
 {
     App::import('Model', 'QualifyingCirculation');
     $PrintingCenter = new PrintingCenter();
     $pc = $PrintingCenter->query("SELECT \n                                            PrintingCenter.id, \n                                            PrintingCenter.printed_at_id, PrintedAt.city_name, PrintedAt.id, PrintingCenter.membership_id,\n                                            Publication.publication_name, Edition.city_name, Edition.id\n                                            FROM qualifying_circulations as `QualifyingCirculation` \n                                            LEFT JOIN printing_centers as `PrintingCenter` on QualifyingCirculation.printing_center_id = PrintingCenter.id \n                                            LEFT JOIN cities as `PrintedAt` on PrintingCenter.printed_at_id = PrintedAt.id \n                                            LEFT JOIN memberships as `Membership` on PrintingCenter.membership_id = Membership.id \n                                            LEFT JOIN cities as `Edition` on Membership.edition_id = Edition.id \n                                            LEFT JOIN publications as `Publication` on Membership.publication_id = Publication.id\n                                            ");
     foreach ($pc as $k => $v) {
         $printingCenters[$v['PrintingCenter']['id']] = "{$v['Publication']['publication_name']} - {$v['Edition']['city_name']} Edition - Printed At {$v['PrintedAt']['city_name']} ({$v['PrintingCenter']['id']})";
     }
     return $printingCenters;
 }