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')); }
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; }