public function index()
{
//ini_set("max_execution_time", "500000");
$user_groups = Emails::getStateprovincial();
foreach ($user_groups as $user_group)
{
$provincial = $user_group["provincial"];
//this is a variable that stores the part of the array user_group
$district_or_region = $provincial;
//if provincial is selected
if ($provincial > 0)
{
//loads the regions model and calls the specified function i.e get regionName
$region = Regions::getRegionName($district_or_region);
$region_name = urlencode($region);
//mktime($hour, $minute, $second, $month, $day, $year, $is_dst)
//Get Unix timestamp for a date
$today = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
$from = $today;
}
//$provincial is the id of the region
$this -> get_sms_level($region_name, $from, $district_or_region);
}
}//end of index function
public function index() {
ini_set("max_execution_time", "500000");
$user_groups = Emails::getStateprovincial();
foreach ($user_groups as $user_group) {
$provincial = $user_group["provincial"];
$district_or_region = $provincial;
//if provincial is selected
if ($district_or_region > 0)
{
$region = Regions::getRegionName($district_or_region);
$region_name = urlencode($region);
$today = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
$from = $today;
$this -> getBalances($region_name, $from, $district_or_region);
}
}
}//end of index function
public function __construct($options = null)
{
//Get data to form select menu for primary and secondary material
$primaries = new Materials();
$primary_options = $primaries->getPrimaries();
//Get data to form select menu for periods
//Get Rally data
$rallies = new Rallies();
$rally_options = $rallies->getRallies();
//Get Hoard data
$hoards = new Hoards();
$hoard_options = $hoards->getHoards();
$counties = new Counties();
$county_options = $counties->getCountyName2();
$denominations = new Denominations();
$denom_options = $denominations->getOptionsIronAge();
$rulers = new Rulers();
$ruler_options = $rulers->getIronAgeRulers();
$mints = new Mints();
$mint_options = $mints->getIronAgeMints();
$axis = new Dieaxes();
$axis_options = $axis->getAxes();
$geog = new Geography();
$geog_options = $geog->getIronAgeGeographyDD();
$regions = new Regions();
$region_options = $regions->getRegionName();
$tribes = new Tribes();
$tribe_options = $tribes->getTribes();
$institutions = new Institutions();
$inst_options = $institutions->getInsts();
parent::__construct($options);
$decorators = array(array('ViewHelper'), array('Description', array('placement' => 'append', 'class' => 'info')), array('Errors', array('placement' => 'append', 'class' => 'error', 'tag' => 'li')), array('Label'), array('HtmlTag', array('tag' => 'li')));
$this->setName('Advanced');
$old_findID = new Zend_Form_Element_Text('old_findID');
$old_findID->setLabel('Find number: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addErrorMessage('Please enter a valid number!')->setDecorators($decorators);
$description = new Zend_Form_Element_Text('description');
$description->setLabel('Object description contains: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addErrorMessage('Please enter a valid term')->setDecorators($decorators);
$workflow = new Zend_Form_Element_Select('workflow');
$workflow->setLabel('Workflow stage: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->setDecorators($decorators);
if (in_array($this->getRole(), $this->_higherlevel)) {
$workflow->addMultiOptions(array(NULL => 'Choose a workflow stage', 'Available workflow stages' => array('1' => 'Quarantine', '2' => 'On review', '4' => 'Awaiting validation', '3' => 'Published')));
}
if (in_array($this->getRole(), $this->_restricted)) {
$workflow->addMultiOptions(array(NULL => 'Choose a workflow stage', 'Available workflow stages' => array('4' => 'Awaiting validation', '3' => 'Published')));
}
//Rally details
$rally = new Zend_Form_Element_Checkbox('rally');
$rally->setLabel('Rally find: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->setUncheckedValue(NULL)->setDecorators($decorators);
$geographyID = new Zend_Form_Element_Select('geographyID');
$geographyID->setLabel('Geographic area: ')->setDecorators($decorators)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose a geography', 'Available geographies' => $geog_options))->addValidator('inArray', false, array(array_keys($geog_options)))->addValidator('Int');
$rallyID = new Zend_Form_Element_Select('rallyID');
$rallyID->setLabel('Found at this rally: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose a rally', 'Available rallies' => $rally_options))->setDecorators($decorators)->addValidator('inArray', false, array(array_keys($rally_options)))->addValidator('Int');
$hoard = new Zend_Form_Element_Checkbox('hoard');
$hoard->setLabel('Hoard find: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->setUncheckedValue(NULL)->setDecorators($decorators);
$hoardID = new Zend_Form_Element_Select('hID');
$hoardID->setLabel('Part of this hoard: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose a hoard', 'Available hoards' => $hoard_options))->setDecorators($decorators)->addValidator('inArray', false, array(array_keys($hoard_options)))->addValidator('Int');
$county = new Zend_Form_Element_Select('county');
$county->setLabel('County: ')->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose a county', 'Available counties' => $county_options))->addValidator('inArray', false, array(array_keys($county_options)))->setDecorators($decorators);
$district = new Zend_Form_Element_Select('district');
$district->setLabel('District: ')->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose district after county'))->setDecorators($decorators)->disabled = true;
$parish = new Zend_Form_Element_Select('parish');
$parish->setLabel('Parish: ')->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose parish after county'))->setDecorators($decorators)->disabled = true;
$regionID = new Zend_Form_Element_Select('regionID');
$regionID->setLabel('European region: ')->setDecorators($decorators)->addMultiOptions(array(NULL => 'Choose a region for a wide result', 'Available regions' => $region_options))->addValidator('Int');
$gridref = new Zend_Form_Element_Text('gridref');
$gridref->setLabel('Grid reference: ')->setDecorators($decorators)->addValidator('ValidGridRef')->addFilters(array('StripTags', 'StringTrim'))->addValidator('Alnum');
$fourFigure = new Zend_Form_Element_Text('fourFigure');
$fourFigure->setLabel('Four figure grid reference: ')->setDecorators($decorators)->addFilters(array('StripTags', 'StringTrim'))->addValidator('ValidGridRef')->addValidator('Alnum');
###
##Numismatic data
###
// Denomination
$denomination = new Zend_Form_Element_Select('denomination');
$denomination->setLabel('Denomination: ')->setRegisterInArrayValidator(false)->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose denomination type', 'Available denominations' => $denom_options))->addValidator('inArray', false, array(array_keys($denom_options)))->setDecorators($decorators);
//Primary ruler
$ruler = new Zend_Form_Element_Select('ruler');
$ruler->setLabel('Ruler / issuer: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose primary ruler', 'Available rulers' => $ruler_options))->addValidator('inArray', false, array(array_keys($denom_options)))->setDecorators($decorators);
//Mint
$mint = new Zend_Form_Element_Select('mint');
$mint->setLabel('Issuing mint: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose issuing mint', 'Available mints' => $mint_options))->addValidator('inArray', false, array(array_keys($mint_options)))->setDecorators($decorators);
//Secondary ruler
$ruler2 = new Zend_Form_Element_Select('ruler2');
$ruler2->setLabel('Secondary ruler / issuer: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose secondary ruler', 'Available rulers' => $ruler_options))->addValidator('inArray', false, array(array_keys($ruler_options)))->setDecorators($decorators);
//Obverse inscription
$obverseinsc = new Zend_Form_Element_Text('obverseLegend');
$obverseinsc->setLabel('Obverse inscription contains: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addErrorMessage('Please enter a valid term')->setDecorators($decorators);
//Obverse description
$obversedesc = new Zend_Form_Element_Text('obverseDescription');
$obversedesc->setLabel('Obverse description contains: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addErrorMessage('Please enter a valid term')->setDecorators($decorators);
//reverse inscription
$reverseinsc = new Zend_Form_Element_Text('reverseLegend');
$reverseinsc->setLabel('Reverse inscription contains: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addErrorMessage('Please enter a valid term')->setDecorators($decorators);
//reverse description
$reversedesc = new Zend_Form_Element_Text('reverseDescription');
$reversedesc->setLabel('Reverse description contains: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addErrorMessage('Please enter a valid term')->setDecorators($decorators);
//Die axis
$axis = new Zend_Form_Element_Select('axis');
$axis->setLabel('Die axis measurement: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose measurement', 'Available die axes' => $axis_options))->addValidator('inArray', false, array(array_keys($axis_options)))->addErrorMessage('That option is not a valid choice')->addValidator('Int')->setDecorators($decorators);
//Tribe
$tribe = new Zend_Form_Element_Select('tribe');
$tribe->setLabel('Iron Age tribe: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose a tribe', 'Available tribes' => $tribe_options))->addValidator('inArray', false, array(array_keys($tribe_options)))->addErrorMessage('That option is not a valid choice')->addValidator('Int')->setDecorators($decorators);
$objecttype = new Zend_Form_Element_Hidden('objecttype');
$objecttype->setValue('COIN')->setAttrib('class', 'none')->addFilters(array('StripTags', 'StringTrim'))->addValidator('Alpha', false, array('allowWhiteSpace' => true))->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label');
$broadperiod = new Zend_Form_Element_Hidden('broadperiod');
$broadperiod->setValue('IRON AGE')->addValidator('Alnum', false, array('allowWhiteSpace' => true))->setAttrib('class', 'none')->addFilters(array('StripTags', 'StringTrim'))->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label');
$mack_type = new Zend_Form_Element_Text('mackType');
$mack_type->setLabel('Mack Type: ')->setDecorators($decorators)->addFilters(array('StripTags', 'StringTrim'))->addValidator('Alnum', false, array('allowWhiteSpace' => true));
$bmc_type = new Zend_Form_Element_Text('bmc');
$bmc_type->setLabel('British Museum catalogue number: ')->setDecorators($decorators)->addFilters(array('StripTags', 'StringTrim'))->addValidator('Alnum', false, array('allowWhiteSpace' => true));
$allen_type = new Zend_Form_Element_Text('allenType');
$allen_type->setLabel('Allen Type: ')->setDecorators($decorators)->addFilters(array('StripTags', 'StringTrim'))->addValidator('Alnum', false, array('allowWhiteSpace' => true));
$va_type = new Zend_Form_Element_Text('vaType');
$va_type->setLabel('Van Arsdell Number: ')->setDecorators($decorators)->addFilters(array('StripTags', 'StringTrim'))->addValidator('Alnum', false, array('allowWhiteSpace' => true));
$rudd_type = new Zend_Form_Element_Text('ruddType');
$rudd_type->setLabel('Ancient British Coinage number: ')->setDecorators($decorators)->addFilters(array('StripTags', 'StringTrim'))->addValidator('Alnum', false, array('allowWhiteSpace' => true));
$phase_date_1 = new Zend_Form_Element_Text('phase_date_1');
$phase_date_1->setLabel('Phase date 1: ')->setDecorators($decorators)->addFilters(array('StripTags', 'StringTrim'))->addValidator('Alnum', false, array('allowWhiteSpace' => true));
$phase_date_2 = new Zend_Form_Element_Text('phase_date_2');
$phase_date_2->setLabel('Phase date 2: ')->setDecorators($decorators)->addFilters(array('StripTags', 'StringTrim'))->addValidator('Alnum', false, array('allowWhiteSpace' => true));
$context = new Zend_Form_Element_Text('context');
$context->setLabel('Context of coins: ')->setDecorators($decorators)->addFilters(array('StripTags', 'StringTrim'))->addValidator('Alnum', false, array('allowWhiteSpace' => true));
$depositionDate = new Zend_Form_Element_Text('depositionDate');
$depositionDate->setLabel('Date of deposition: ')->setDecorators($decorators)->addFilters(array('StripTags', 'StringTrim'))->addValidator('Alnum', false, array('allowWhiteSpace' => true));
$numChiab = new Zend_Form_Element_Text('numChiab');
$numChiab->setLabel('Coin hoards of Iron Age Britain number: ')->setDecorators($decorators)->addFilters(array('StripTags', 'StringTrim'))->addValidator('Alnum', false, array('allowWhiteSpace' => true));
//Submit button
$submit = new Zend_Form_Element_Submit('submit');
$submit->setAttrib('id', 'submit')->setAttrib('class', 'large')->setLabel('Submit your search...');
$institution = new Zend_Form_Element_Select('institution');
$institution->setLabel('Recording institution: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addMultiOptions(array(NULL => NULL, 'Choose institution' => $inst_options))->setDecorators($decorators);
$hash = new Zend_Form_Element_Hash('csrf');
$hash->setValue($this->_config->form->salt)->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('label')->setTimeout(4800);
$this->addElement($hash);
$this->addElements(array($old_findID, $description, $workflow, $rally, $rallyID, $hoard, $hoardID, $county, $regionID, $district, $parish, $fourFigure, $gridref, $denomination, $ruler, $mint, $axis, $obverseinsc, $obversedesc, $reverseinsc, $reversedesc, $ruler2, $tribe, $objecttype, $broadperiod, $geographyID, $bmc_type, $mack_type, $allen_type, $va_type, $rudd_type, $numChiab, $context, $depositionDate, $phase_date_1, $phase_date_2, $submit, $institution));
$this->addDisplayGroup(array('denomination', 'geographyID', 'ruler', 'ruler2', 'tribe', 'mint', 'axis', 'obverseLegend', 'obverseDescription', 'reverseLegend', 'reverseDescription', 'bmc', 'vaType', 'allenType', 'ruddType', 'mackType', 'numChiab', 'context', 'phase_date_1', 'phase_date_2', 'depositionDate'), 'numismatics')->removeDecorator('HtmlTag');
$this->numismatics->addDecorators(array('FormElements', array('HtmlTag', array('tag' => 'ul'))));
$this->numismatics->removeDecorator('DtDdWrapper');
$this->numismatics->setLegend('Numismatic details: ');
$this->addDisplayGroup(array('old_findID', 'description', 'rally', 'rallyID', 'hoard', 'hID', 'workflow'), 'details')->removeDecorator('HtmlTag');
$this->details->addDecorators(array('FormElements', array('HtmlTag', array('tag' => 'ul'))));
$this->details->removeDecorator('DtDdWrapper');
$this->details->setLegend('Object details: ');
$this->addDisplayGroup(array('county', 'regionID', 'district', 'parish', 'gridref', 'fourFigure', 'institution'), 'spatial')->removeDecorator('HtmlTag');
$this->spatial->addDecorators(array('FormElements', array('HtmlTag', array('tag' => 'ul'))));
$this->spatial->removeDecorator('DtDdWrapper');
$this->spatial->setLegend('Spatial details: ');
$this->addDisplayGroup(array('submit'), 'submit');
$this->submit->removeDecorator('DtDdWrapper');
$this->submit->removeDecorator('HtmlTag');
}
public function download()
{
$this->load->database();
$valid = $this->validate_form();
if ($valid) {
$data_buffer = "\n\t\t\t<style>\n\t\t\ttable.data-table {\n\t\t\ttable-layout: fixed;\n\t\t\twidth: 700px;\n\t\t\tborder-collapse:collapse;\n\t\t\tborder:1px solid black;\n\t\t\t}\n\t\t\ttable.data-table td, th {\n\t\t\twidth: 100px;\n\t\t\tborder: 1px solid black;\n\t\t\t}\n\t\t\t.leftie{\n\t\t\t\ttext-align: left !important;\n\t\t\t}\n\t\t\t.center{\n\t\t\t\ttext-align: center !important;\n\t\t\t}\n\t\t\t.right{\n\t\t\t\ttext-align: right !important;\n\t\t\t}\n\t\t\t</style> \n\t\t\t";
$start_date = $this->input->post("start_date");
$end_date = $this->input->post("end_date");
$data_buffer .= "<table class='data-table'>";
$vaccines = Vaccines::getAll_Minified();
$data_buffer .= $this->echoTitles($vaccines);
$population = 0;
$store = "";
$district_or_region = $this->session->userdata('district_province_id');
$identifier = $this->session->userdata('user_identifier');
$sql_issues = "";
if ($identifier == 'provincial_officer') {
$region_object = Regions::getRegion($district_or_region);
$store = $region_object->name;
$owner = "R" . $district_or_region;
$sql_issues = "select vaccine_summaries.*,group_concat(vaccine_id,'-',quantity) as vaccine_issues from (SELECT vaccine_id,sum(Quantity) as quantity,issued_to_region,issued_to_district,issued_to_facility FROM `disbursements` where owner = '" . $owner . "' and Issued_By_Region = '" . $district_or_region . "' and vaccine_id != '' and str_to_date(date_issued,'%m/%d/%Y') between str_to_date('" . $start_date . "','%m/%d/%Y') and str_to_date('" . $end_date . "','%m/%d/%Y') group by vaccine_id,issued_to_region,issued_to_district,issued_to_facility) vaccine_summaries group by issued_to_region,issued_to_district,issued_to_facility";
} else {
if ($identifier == 'district_officer') {
$district_object = Districts::getDistrict($district_or_region);
$store = $district_object->name;
$owner = "D" . $district_or_region;
$sql_issues = "select vaccine_summaries.*,group_concat(vaccine_id,'-',quantity) as vaccine_issues from (SELECT vaccine_id,sum(Quantity) as quantity,issued_to_region,issued_to_district,issued_to_facility FROM `disbursements` where owner = '" . $owner . "' and Issued_By_Region = '" . $district_or_region . "' and vaccine_id != '' and str_to_date(date_issued,'%m/%d/%Y') between str_to_date('" . $start_date . "','%m/%d/%Y') and str_to_date('" . $end_date . "','%m/%d/%Y') group by vaccine_id,issued_to_region,issued_to_district,issued_to_facility) vaccine_summaries group by issued_to_region,issued_to_district,issued_to_facility";
} else {
if ($identifier == 'national_officer') {
$store = "Central Vaccines Store";
$sql_issues = "select vaccine_summaries.*,group_concat(vaccine_id,'-',quantity) as vaccine_issues from (SELECT vaccine_id,sum(Quantity) as quantity,issued_to_region,issued_to_district,issued_to_facility FROM `disbursements` where owner = 'N0' and Issued_By_National = '0' and vaccine_id != '' and str_to_date(date_issued,'%m/%d/%Y') between str_to_date('" . $start_date . "','%m/%d/%Y') and str_to_date('" . $end_date . "','%m/%d/%Y') group by vaccine_id,issued_to_region,issued_to_district,issued_to_facility) vaccine_summaries group by issued_to_region,issued_to_district,issued_to_facility";
}
}
}
$query = $this->db->query($sql_issues);
$issues_data = $query->result_array();
foreach ($issues_data as $recipient_data) {
$population = 0;
$recipient = "";
if (isset($recipient_data['issued_to_region'])) {
$population = Regional_Populations::getRegionalPopulation($recipient_data['issued_to_region'], date('Y'));
$recipient = Regions::getRegionName($recipient_data['issued_to_region']);
} else {
if (isset($recipient_data['issued_to_district'])) {
$population = District_Populations::getDistrictPopulation($recipient_data['issued_to_district'], date('Y'));
$recipient = Districts::getDistrictName($recipient_data['issued_to_district']);
} else {
if (isset($recipient_data['issued_to_facility'])) {
$recipient = $recipient_data['issued_to_facility'];
}
}
}
$data_buffer .= "<tr><td style='text-align:left;'>" . $recipient . "</td><td class='right'>" . number_format($population + 0) . "</td>";
//Get the vaccine data
$vaccine_data = $recipient_data['vaccine_issues'];
$separated_data = explode(',', $vaccine_data);
$final_vaccine_data = array();
foreach ($separated_data as $vaccine_issue) {
$further_separation = explode("-", $vaccine_issue);
$final_vaccine_data[$further_separation[0]] = $further_separation[1];
}
foreach ($vaccines as $vaccine) {
$doses = 0;
$mos = 0;
$population = str_replace(',', '', $population);
if (isset($final_vaccine_data[$vaccine->id])) {
$doses = $final_vaccine_data[$vaccine->id];
}
if ($population != 0 && $doses != 0) {
$monthly_requirement = ceil($vaccine->Doses_Required * $population * $vaccine->Wastage_Factor / 12);
$mos = number_format($doses / $monthly_requirement, 1);
}
$data_buffer .= "<td class='right'>" . number_format($doses + 0) . "</td><td class='center'>" . $mos . "</td>";
}
$data_buffer .= "</tr>";
}
$data_buffer .= "</table>";
$this->generatePDF($data_buffer, $start_date, $end_date, $store);
} else {
$this->view_transactions_interface();
}
}
public function view_ledger($type, $id, $paged_vaccine = null, $date_from = null, $date_to = null, $offset = 0, $default_offset = 0) {
$data['type'] = $type;
//get current district/region
$district_or_province = $this -> session -> userdata('district_province_id');
//get current level
$identifier = $this -> session -> userdata('user_identifier');
$dummy_identifier = "";
//Determine if the user is trying to view the ledger for his/her own store
//Type 0 means we are drilling down to a region
if ($type == 0) {
if ($identifier == "provincial_officer" && $district_or_province == $id) {
redirect("disbursement_management/view_disbursements");
}
$dummy_identifier = "provincial_officer";
}
//Type 1 means we are drilling down to a district
else if ($type == 1) {
if ($identifier == "district_officer" && $district_or_province == $id) {
redirect("disbursement_management/view_disbursements");
}
$dummy_identifier = "district_officer";
}
//Type 2 means we are drilling down to the whole country
else if ($type == 2) {
if ($identifier == "national_officer") {
redirect("disbursement_management/view_disbursements");
}
$dummy_identifier = "national_officer";
}
$data['identifier'] = $dummy_identifier;
$data['district_or_province'] = $id;
$district_or_province = $id;
//Now display the 'foreign' ledger
$to = $this -> input -> post('to');
$from = $this -> input -> post('from');
$store = $this -> input -> post('selected_store_id');
$order_by = $this -> input -> post('order_by');
$order = $this -> input -> post('order');
$per_page = $this -> input -> post('per_page');
if ($to == false) {
$to = date("U", mktime(0, 0, 0, 1, 1, date("Y") + 1));
} else if ($to == true) {
$to = strtotime($to);
}
if ($from == false) {
$from = date("U", mktime(0, 0, 0, 1, 1, date('Y')));
} else if ($from == true) {
$from = strtotime($from);
}
if ($date_from != null) {
$from = $date_from;
} else if ($date_to != null) {
$to = $date_to;
}
//Check if the user has specified how many items he/she wants per page. If not, default to 10 items per page.
if ($per_page > 0) {
$this -> session -> set_userdata(array("external_from" => $from, "external_to" => $to, "external_per_page" => $per_page, "external_order_by" => $order_by, "external_order" => $order));
} else {
$temp = $this -> session -> userdata('external_per_page');
if ($temp == false) {
$this -> session -> set_userdata(array("external_from" => $from, "external_to" => $to, "external_per_page" => 10, "external_order_by" => "Date_Issued_Timestamp", "external_order" => "DESC"));
}
}
$items_per_page = $this -> session -> userdata('external_per_page');
$order_by = $this -> session -> userdata('external_order_by');
$order = $this -> session -> userdata('external_order');
$region = 0;
$district = 0;
if ($store != null) {
$split_parts = explode("_", $store);
$type = $split_parts[0];
$id = $split_parts[1];
if ($type == "district") {
$district = $id;
$this -> session -> set_userdata(array("external_region" => ""));
$this -> session -> set_userdata(array("external_district" => $district));
} else if ($type == "region") {
$region = $id;
$this -> session -> set_userdata(array("external_district" => ""));
$this -> session -> set_userdata(array("external_region" => $region));
} else if ($type == "national") {
$this -> session -> set_userdata(array("external_district" => ""));
$this -> session -> set_userdata(array("external_region" => ""));
}
}
$district = $this -> session -> userdata('external_district');
$region = $this -> session -> userdata('external_region');
$data['vaccines'] = Vaccines::getAll_Minified();
$return_array = array();
$balances = array();
if ($type == 2) {//National Level
$recipient = "Central Vaccines Store";
foreach ($data['vaccines'] as $vaccine) {
//skip the vaccine that is currently being browsed through
if ($vaccine -> id == $paged_vaccine) {
continue;
}
$total_disbursements = Disbursements::getTotalNationalDisbursements($vaccine -> id, $from, $to, $district, $region);
if ($total_disbursements > $items_per_page) {
$config['base_url'] = base_url() . "external_ledger_management/view_ledger/" . $type . "/" . $id . "/" . $vaccine -> id . "/" . $from . "/" . $to;
$config['total_rows'] = $total_disbursements;
$config['per_page'] = $items_per_page;
$config['uri_segment'] = 9;
$config['num_links'] = 5;
$this -> pagination -> initialize($config);
$data['pagination'][$vaccine -> id] = $this -> pagination -> create_links();
}
if ($order == "ASC") {
$balances[$vaccine -> id] = Disbursements::getNationalPeriodBalance($vaccine -> id, $from);
} else if ($order == "DESC") {
$balances[$vaccine -> id] = Disbursements::getNationalPeriodBalance($vaccine -> id, $to);
}
$return_array[$vaccine -> id] = Disbursements::getNationalDisbursements($vaccine -> id, $from, $to, $default_offset, $items_per_page, $district, $region, $order_by, $order, $balances[$vaccine -> id]);
}
if ($paged_vaccine != null) {
$data['paged_vaccine'] = $paged_vaccine;
$total_disbursements = Disbursements::getTotalNationalDisbursements($paged_vaccine, $from, $to, $district, $region);
if ($total_disbursements > $items_per_page) {
$config['base_url'] = base_url() . "external_ledger_management/view_ledger/" . $type . "/" . $id . "/" . $paged_vaccine . "/" . $from . "/" . $to;
$config['total_rows'] = $total_disbursements;
$config['per_page'] = $items_per_page;
$config['uri_segment'] = 8;
$config['num_links'] = 5;
$this -> pagination -> initialize($config);
$data['pagination'][$paged_vaccine] = $this -> pagination -> create_links();
}
if ($order == "ASC") {
$balances[$paged_vaccine] = Disbursements::getNationalPeriodBalance($paged_vaccine, $from);
} else if ($order == "DESC") {
$balances[$paged_vaccine] = Disbursements::getNationalPeriodBalance($paged_vaccine, $to);
}
$return_array[$paged_vaccine] = Disbursements::getNationalDisbursements($paged_vaccine, $from, $to, $offset, $items_per_page, $district, $region, $order_by, $order, $balances[$paged_vaccine]);
}
} else if ($type == 0) {//Regional Store Level
$recipient = Regions::getRegionName($district_or_province);
foreach ($data['vaccines'] as $vaccine) {
if ($vaccine -> id == $paged_vaccine) {
continue;
}
$total_disbursements = Disbursements::getTotalRegionalDisbursements($district_or_province, $vaccine -> id, $from, $to, $district, $region);
if ($total_disbursements > $items_per_page) {
$config['base_url'] = base_url() . "external_ledger_management/view_ledger/" . $type . "/" . $id . "/" . $vaccine -> id . "/" . $from . "/" . $to;
$config['total_rows'] = $total_disbursements;
$config['per_page'] = $items_per_page;
$config['uri_segment'] = 9;
$config['num_links'] = 5;
$this -> pagination -> initialize($config);
$data['pagination'][$vaccine -> id] = $this -> pagination -> create_links();
}
if ($order == "ASC") {
$balances[$vaccine -> id] = Disbursements::getRegionalPeriodBalance($district_or_province, $vaccine -> id, $from);
} else if ($order == "DESC") {
$balances[$vaccine -> id] = Disbursements::getRegionalPeriodBalance($district_or_province, $vaccine -> id, $to);
}
$return_array[$vaccine -> id] = Disbursements::getRegionalDisbursements($district_or_province, $vaccine -> id, $from, $to, $default_offset, $items_per_page, $district, $region, $order_by, $order, $balances[$vaccine -> id]);
}
if ($paged_vaccine != null) {
$data['paged_vaccine'] = $paged_vaccine;
$total_disbursements = Disbursements::getTotalRegionalDisbursements($district_or_province, $paged_vaccine, $from, $to, $district, $region);
if ($total_disbursements > $items_per_page) {
$config['base_url'] = base_url() . "external_ledger_management/view_ledger/" . $type . "/" . $id . "/" . $paged_vaccine . "/" . $from . "/" . $to;
$config['total_rows'] = $total_disbursements;
$config['per_page'] = $items_per_page;
$config['uri_segment'] = 8;
$config['num_links'] = 5;
$this -> pagination -> initialize($config);
$data['pagination'][$paged_vaccine] = $this -> pagination -> create_links();
}
if ($order == "ASC") {
$balances[$paged_vaccine] = Disbursements::getRegionalPeriodBalance($district_or_province, $paged_vaccine, $from);
} else if ($order == "DESC") {
$balances[$paged_vaccine] = Disbursements::getRegionalPeriodBalance($district_or_province, $paged_vaccine, $to);
}
$return_array[$paged_vaccine] = Disbursements::getRegionalDisbursements($district_or_province, $paged_vaccine, $from, $to, $offset, $items_per_page, $district, $region, $order_by, $order, $balances[$paged_vaccine]);
}
} else if ($type == 1) {//District Store Level
$recipient = Districts::getDistrictName($district_or_province);
foreach ($data['vaccines'] as $vaccine) {
if ($vaccine -> id == $paged_vaccine) {
continue;
}
$total_disbursements = Disbursements::getTotalDistrictDisbursements($district_or_province, $vaccine -> id, $from, $to, $district);
if ($total_disbursements > $items_per_page) {
$config['base_url'] = base_url() . "external_ledger_management/view_ledger/" . $type . "/" . $id . "/" . $vaccine -> id . "/" . $from . "/" . $to;
$config['total_rows'] = $total_disbursements;
$config['per_page'] = $items_per_page;
$config['uri_segment'] = 9;
$config['num_links'] = 5;
$this -> pagination -> initialize($config);
$data['pagination'][$vaccine -> id] = $this -> pagination -> create_links();
}
if ($order == "ASC") {
$balances[$vaccine -> id] = Disbursements::getDistrictPeriodBalance($district_or_province, $vaccine -> id, $from);
} else if ($order == "DESC") {
$balances[$vaccine -> id] = Disbursements::getDistrictPeriodBalance($district_or_province, $vaccine -> id, $to);
}
$return_array[$vaccine -> id] = Disbursements::getDistrictDisbursements($district_or_province, $vaccine -> id, $from, $to, $default_offset, $items_per_page, $order_by, $order, $district, $balances[$vaccine -> id]);
}
if ($paged_vaccine != null) {
$data['paged_vaccine'] = $paged_vaccine;
$total_disbursements = Disbursements::getTotalDistrictDisbursements($district_or_province, $paged_vaccine, $from, $to, $district);
if ($total_disbursements > $items_per_page) {
$config['base_url'] = base_url() . "external_ledger_management/view_ledger/" . $type . "/" . $id . "/" . $paged_vaccine . "/" . $from . "/" . $to;
$config['total_rows'] = $total_disbursements;
$config['per_page'] = $items_per_page;
$config['uri_segment'] = 8;
$config['num_links'] = 5;
$this -> pagination -> initialize($config);
$data['pagination'][$paged_vaccine] = $this -> pagination -> create_links();
}
if ($order == "ASC") {
$balances[$paged_vaccine] = Disbursements::getDistrictPeriodBalance($district_or_province, $paged_vaccine, $from);
} else if ($order == "DESC") {
$balances[$paged_vaccine] = Disbursements::getDistrictPeriodBalance($district_or_province, $paged_vaccine, $to);
}
$return_array[$paged_vaccine] = Disbursements::getDistrictDisbursements($district_or_province, $paged_vaccine, $from, $to, $offset, $items_per_page, $order_by, $order, $district, $balances[$paged_vaccine]);
}
}
$data['title'] = $recipient . " Stock Ledger For The Period Between " . date('d/m/Y', $from) . " to " . date('d/m/Y', $to);
$data['recipient'] = $recipient;
$data['content_view'] = "view_external_ledger";
$data['disbursements'] = $return_array;
//$data['balances'] = $balances;
$data['stylesheets'] = array("pagination.css");
//Get all the districts and regions so as to enable drilling down to a particular store
$data['districts'] = Districts::getAllDistricts();
$data['regions'] = Regions::getAllRegions();
$this -> base_params_min($data);
}
public function __construct($options = null)
{
$institutions = new Institutions();
$inst_options = $institutions->getInsts();
//Get data to form select menu for primary and secondary material
$primaries = new Materials();
$primary_options = $primaries->getPrimaries();
//Get data to form select menu for periods
//Get Rally data
$rallies = new Rallies();
$rally_options = $rallies->getRallies();
//Get Hoard data
$hoards = new Hoards();
$hoard_options = $hoards->getHoards();
$counties = new Counties();
$county_options = $counties->getCountyName2();
$rulers = new Rulers();
$ruler_options = $rulers->getRulersByzantine();
$denominations = new Denominations();
$denomination_options = $denominations->getDenomsByzantine();
$mints = new Mints();
$mint_options = $mints->getMintsByzantine();
$axis = new Dieaxes();
$axis_options = $axis->getAxes();
$reece = new Reeces();
$reece_options = $reece->getReeces();
$regions = new Regions();
$region_options = $regions->getRegionName();
parent::__construct($options);
$this->setAttrib('accept-charset', 'UTF-8');
$this->clearDecorators();
$decorator = array('SimpleInput');
$decoratorButton = array('NormalDecButton');
$decorators = array(array('ViewHelper'), array('Description', array('placement' => 'append', 'class' => 'info')), array('Errors', array('placement' => 'append', 'class' => 'error', 'tag' => 'li')), array('Label'), array('HtmlTag', array('tag' => 'li')));
$this->setName('byzantine-search');
$old_findID = new Zend_Form_Element_Text('old_findID');
$old_findID->setLabel('Find number: ')->setRequired(false)->addFilter('StripTags')->addFilter('StringTrim')->addErrorMessage('Please enter a valid number!')->setDecorators($decorators)->setDisableTranslator(true);
$description = new Zend_Form_Element_Text('description');
$description->setLabel('Object description contains: ')->setRequired(false)->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty')->addErrorMessage('Please enter a valid term')->setDecorators($decorators)->setDisableTranslator(true);
$workflow = new Zend_Form_Element_Select('workflow');
$workflow->setLabel('Workflow stage: ')->setRequired(false)->addFilter('StripTags')->addFilter('StringTrim')->addMultiOptions(array(NULL => NULL, 'Choose Worklow stage' => array('1' => 'Quarantine', '2' => 'On review', '3' => 'Awaiting validation', '4' => 'Published')))->setDecorators($decorators)->setDisableTranslator(true);
//Rally details
$rally = new Zend_Form_Element_Checkbox('rally');
$rally->setLabel('Rally find: ')->setRequired(false)->addFilter('StripTags')->addFilter('StringTrim')->setUncheckedValue(NULL)->setDecorators($decorators)->setDisableTranslator(true);
$rallyID = new Zend_Form_Element_Select('rallyID');
$rallyID->setLabel('Found at this rally: ')->setRequired(false)->addFilter('StripTags')->addFilter('StringTrim')->addMultiOptions(array(NULL => NULL, 'Choose rally name' => $rally_options))->setDecorators($decorators)->setDisableTranslator(true);
$hoard = new Zend_Form_Element_Checkbox('hoard');
$hoard->setLabel('Hoard find: ')->setRequired(false)->addFilter('StripTags')->addFilter('StringTrim')->setUncheckedValue(NULL)->setDecorators($decorators);
$hoardID = new Zend_Form_Element_Select('hID');
$hoardID->setLabel('Part of this hoard: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => NULL, 'Choose rally name' => $hoard_options))->setDecorators($decorators);
$county = new Zend_Form_Element_Select('county');
$county->setLabel('County: ')->addFilters(array('StripTags', 'StringTrim'))->addValidators(array('NotEmpty'))->addMultiOptions(array(NULL => NULL, 'Choose county' => $county_options))->setDecorators($decorators);
$district = new Zend_Form_Element_Select('district');
$district->setLabel('District: ')->addMultiOptions(array(NULL => 'Choose district after county'))->setRegisterInArrayValidator(false)->setDecorators($decorators)->disabled = true;
$parish = new Zend_Form_Element_Select('parish');
$parish->setLabel('Parish: ')->setRegisterInArrayValidator(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose parish after county'))->setDecorators($decorators)->disabled = true;
$regionID = new Zend_Form_Element_Select('regionID');
$regionID->setLabel('European region: ')->setRegisterInArrayValidator(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose a region for a wide result', 'Choose region' => $region_options))->setDecorators($decorators);
$gridref = new Zend_Form_Element_Text('gridref');
$gridref->setLabel('Grid reference: ')->addFilters(array('StripTags', 'StringTrim'))->addValidators(array('NotEmpty', 'ValidGridRef'))->setDecorators($decorators);
$fourFigure = new Zend_Form_Element_Text('fourFigure');
$fourFigure->setLabel('Four figure grid reference: ')->addFilters(array('StripTags', 'StringTrim'))->addValidators(array('NotEmpty', 'ValidGridRef'))->setDecorators($decorators);
###
##Numismatic data
###
//Denomination
$denomination = new Zend_Form_Element_Select('denomination');
$denomination->setLabel('Denomination: ')->setRegisterInArrayValidator(false)->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => NULL, 'Choose denomination type' => $denomination_options))->setDecorators($decorators);
//Primary ruler
$ruler = new Zend_Form_Element_Select('ruler');
$ruler->setLabel('Ruler / issuer: ')->setRegisterInArrayValidator(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => NULL, 'Choose primary ruler' => $ruler_options))->setDecorators($decorators);
//Mint
$mint = new Zend_Form_Element_Select('mint');
$mint->setLabel('Issuing mint: ')->setRegisterInArrayValidator(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => NULL, 'Choose denomination type' => $mint_options))->setDecorators($decorators);
//Obverse inscription
$obverseinsc = new Zend_Form_Element_Text('obverseLegend');
$obverseinsc->setLabel('Obverse inscription contains: ')->setAttrib('size', 60)->addFilters(array('StripTags', 'StringTrim'))->addErrorMessage('Please enter a valid term')->setDecorators($decorators);
//Obverse description
$obversedesc = new Zend_Form_Element_Text('obverseDescription');
$obversedesc->setLabel('Obverse description contains: ')->addFilters(array('StripTags', 'StringTrim'))->setAttrib('size', 60)->addErrorMessage('Please enter a valid term')->setDecorators($decorators);
//reverse inscription
$reverseinsc = new Zend_Form_Element_Text('reverseLegend');
$reverseinsc->setLabel('Reverse inscription contains: ')->addFilters(array('StripTags', 'StringTrim'))->setAttrib('size', 60)->addErrorMessage('Please enter a valid term')->setDecorators($decorators);
//reverse description
$reversedesc = new Zend_Form_Element_Text('reverseDescription');
$reversedesc->setLabel('Reverse description contains: ')->addFilters(array('StripTags', 'StringTrim'))->setAttrib('size', 60)->addErrorMessage('Please enter a valid term')->setDecorators($decorators);
//Die axis
$axis = new Zend_Form_Element_Select('axis');
$axis->setLabel('Die axis measurement: ')->setRegisterInArrayValidator(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => NULL, 'Choose measurement' => $axis_options))->setDecorators($decorators);
$institution = new Zend_Form_Element_Select('institution');
$institution->setLabel('Recording institution: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addMultiOptions(array(NULL => NULL, 'Choose institution' => $inst_options))->setDecorators($decorators);
$objecttype = new Zend_Form_Element_Hidden('objecttype');
$objecttype->setValue('coin');
$objecttype->removeDecorator('HtmlTag')->addFilters(array('StripTags', 'StringTrim'))->removeDecorator('DtDdWrapper')->removeDecorator('label');
$broadperiod = new Zend_Form_Element_Hidden('broadperiod');
$broadperiod->setValue('Byzantine')->addFilters(array('StripTags', 'StringTrim', 'StringToUpper'))->removeDecorator('HtmlTag')->removeDecorator('DtDdWrapper')->removeDecorator('label');
// Submit button
$submit = new Zend_Form_Element_Submit('submit');
$submit->setAttrib('id', 'submitbutton')->removeDecorator('label')->removeDecorator('HtmlTag')->removeDecorator('DtDdWrapper')->setAttrib('class', 'large');
$this->addElements(array($old_findID, $description, $workflow, $rally, $rallyID, $hoard, $hoardID, $county, $regionID, $district, $parish, $fourFigure, $gridref, $denomination, $ruler, $mint, $axis, $obverseinsc, $obversedesc, $reverseinsc, $reversedesc, $objecttype, $broadperiod, $institution, $submit));
$this->addDisplayGroup(array('denomination', 'ruler', 'mint', 'moneyer', 'axis', 'obverseLegend', 'obverseDescription', 'reverseLegend', 'reverseDescription'), 'numismatics');
$this->addDisplayGroup(array('old_findID', 'description', 'rally', 'rallyID', 'hoard', 'hID', 'workflow'), 'details');
$this->addDisplayGroup(array('county', 'regionID', 'district', 'parish', 'gridref', 'fourFigure', 'institution'), 'spatial');
$this->numismatics->setLegend('Numismatic details');
$this->numismatics->removeDecorator('DtDdWrapper');
$this->numismatics->addDecorators(array('FormElements', array('HtmlTag', array('tag' => 'ul'))));
$this->details->setLegend('Artefact details');
$this->details->removeDecorator('DtDdWrapper');
$this->details->addDecorators(array('FormElements', array('HtmlTag', array('tag' => 'ul'))));
$this->spatial->setLegend('Spatial details');
$this->spatial->removeDecorator('DtDdWrapper');
$this->spatial->addDecorators(array('FormElements', array('HtmlTag', array('tag' => 'ul'))));
$this->addDisplayGroup(array('submit'), 'submit');
$this->addDecorator('FormElements')->addDecorator('Form')->addDecorator(array('ListWrapper' => 'HtmlTag'), array('tag' => 'div'));
$this->removeDecorator('DtDdWrapper');
}
public function __construct($options = null)
{
$institutions = new Institutions();
$inst_options = $institutions->getInsts();
//Get data to form select menu for discovery methods
$discs = new DiscoMethods();
$disc_options = $discs->getOptions();
//Get data to form select menu for manufacture methods
$mans = new Manufactures();
$man_options = $mans->getOptions();
//Get data to form select menu for primary and secondary material
$primaries = new Materials();
$primary_options = $primaries->getPrimaries();
//Get data to form select menu for periods
$periods = new Periods();
$period_options = $periods->getPeriodFrom();
//Get primary material list
$primaries = new Materials();
$primary_options = $primaries->getPrimaries();
//Get period list
$periods = new Periods();
$periodword_options = $periods->getPeriodFromWords();
//Get data to form select menu for cultures
$cultures = new Cultures();
$culture_options = $cultures->getCultures();
//Get data to form Surface treatments menu
$surfaces = new Surftreatments();
$surface_options = $surfaces->getSurfaces();
//Get data to form Decoration styles menu
$decorations = new Decstyles();
$decoration_options = $decorations->getStyles();
//Get data to form Decoration methods menu
$decmeths = new Decmethods();
$decmeth_options = $decmeths->getDecmethods();
//Get Find of note reason data
$reasons = new Findofnotereasons();
$reason_options = $reasons->getReasons();
//Get Preservation data
$preserves = new Preservations();
$preserve_options = $preserves->getPreserves();
//Get Rally data
$rallies = new Rallies();
$rally_options = $rallies->getRallies();
//Get Hoard data
$hoards = new Hoards();
$hoard_options = $hoards->getHoards();
//Get county dropdown
$counties = new Counties();
$county_options = $counties->getCountyName2();
//Get regions list
$regions = new Regions();
$region_options = $regions->getRegionName();
//Set up year of discovery dropdown
$current_year = date('Y');
$years = range(1950, $current_year);
$years_list = array_combine($years, $years);
parent::__construct($options);
$decorator = array('SimpleInput');
$decoratorSelect = array('SelectInput');
$decorators = array(array('ViewHelper'), array('Description', array('placement' => 'append', 'class' => 'info')), array('Errors', array('placement' => 'prepend', 'class' => 'error', 'tag' => 'li')), array('Label', array('separator' => ' ', 'requiredSuffix' => ' *')), array('HtmlTag', array('tag' => 'li')));
$decoratorsHide = array(array('ViewHelper'), array('Description', array('placement' => 'append', 'class' => 'info')), array('Errors', array('placement' => 'prepend', 'class' => 'error', 'tag' => 'li')), array('Label', array('separator' => ' ', 'class' => 'hideme')), array('HtmlTag', array('tag' => 'li')));
$decoratorsRally = array(array('ViewHelper'), array('Description', array('placement' => 'append', 'class' => 'info')), array('Errors', array('placement' => 'prepend', 'class' => 'error', 'tag' => 'li')), array('Label', array('separator' => ' ', 'class' => 'hiderally')), array('HtmlTag', array('tag' => 'li')));
$decoratorsHoard = array(array('ViewHelper'), array('Description', array('placement' => 'append', 'class' => 'info')), array('Errors', array('placement' => 'prepend', 'class' => 'error', 'tag' => 'li')), array('Label', array('separator' => ' ', 'class' => 'hidehoard')), array('HtmlTag', array('tag' => 'li')));
$decoratorsNote = array(array('ViewHelper'), array('Description', array('placement' => 'append', 'class' => 'info')), array('Errors', array('placement' => 'prepend', 'class' => 'error', 'tag' => 'li')), array('Label', array('separator' => ' ', 'class' => 'hidenote')), array('HtmlTag', array('tag' => 'li')));
$this->setName('Advanced');
$old_findID = new Zend_Form_Element_Text('old_findID');
$old_findID->setLabel('Find number: ')->addFilters(array('StringTrim', 'StripTags'))->addValidator('StringLength', false, array(3, 20))->addErrorMessage('Please enter a valid number!')->setDecorators($decorators);
$objecttype = new Zend_Form_Element_Text('objecttype');
$objecttype->setLabel('Object type: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addErrorMessage('Please enter a valid object type!')->setDecorators($decorator);
$description = new Zend_Form_Element_Text('description');
$description->setLabel('Object description contains: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addErrorMessage('Please enter a valid term')->setDecorators($decorator);
//Find of note
$findofnote = new Zend_Form_Element_Checkbox('note');
$findofnote->setLabel('Find of Note: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->setUncheckedValue(NULL)->setDecorators($decorators);
//Reason for find of note
$findofnotereason = new Zend_Form_Element_Select('reason');
$findofnotereason->setLabel('Reason for noteworthy status: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addMultiOptions(array(NULL => NULL, 'Choose reason' => $reason_options))->setDisableTranslator(true)->setDecorators($decoratorsNote);
//Institution
$institution = new Zend_Form_Element_Select('institution');
$institution->setLabel('Recording institution: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addMultiOptions(array(NULL => NULL, 'Choose institution' => $inst_options))->setDecorators($decoratorsNote);
$notes = new Zend_Form_Element_Text('notes');
$notes->setLabel('Notes: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->setDecorators($decorator);
$broadperiod = new Zend_Form_Element_Select('broadperiod');
$broadperiod->setLabel('Broad period: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addMultiOptions(array(NULL => NULL, 'Choose period from' => $periodword_options))->setDecorators($decorators);
$objdate1subperiod = new Zend_Form_Element_Select('fromsubperiod');
$objdate1subperiod->setLabel('Sub period from: ')->setRequired(false)->addMultiOptions(array(NULL => NULL, 'Choose sub-period from' => array('1' => 'Early', '2' => 'Middle', '3' => 'Late')))->addFilters(array('StringTrim', 'StripTags'))->setOptions(array('separator' => ''))->setDecorators($decorators);
//Period from: Assigned via dropdown
$objdate1period = new Zend_Form_Element_Select('periodFrom');
$objdate1period->setLabel('Period from: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addMultiOptions(array(NULL => NULL, 'Choose period from' => $period_options))->setDisableTranslator(true)->setDecorators($decorators);
$objdate2subperiod = new Zend_Form_Element_Select('tosubperiod');
$objdate2subperiod->setLabel('Sub period to: ')->addMultiOptions(array(NULL => NULL, 'Choose sub-period from' => array('1' => 'Early', '2' => 'Middle', '3' => 'Late')))->setDisableTranslator(true)->addFilters(array('StringTrim', 'StripTags'))->setOptions(array('separator' => ''))->setDecorators($decorators);
//Period to: Assigned via dropdown
$objdate2period = new Zend_Form_Element_Select('periodTo');
$objdate2period->setLabel('Period to: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addMultiOptions(array(NULL => NULL, 'Choose period to' => $period_options))->setDecorators($decorators);
$culture = new Zend_Form_Element_Select('culture');
$culture->setLabel('Ascribed culture: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addMultiOptions(array(NULL => NULL, 'Choose ascribed culture to' => $culture_options))->setDecorators($decorators);
$from = new Zend_Form_Element_Text('from');
$from->setLabel('Start date greater than: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addValidators(array('NotEmpty', 'Int'))->addErrorMessage('Please enter a valid date')->setDisableTranslator(true)->setDecorators($decorator);
$fromend = new Zend_Form_Element_Text('fromend');
$fromend->setLabel('Start date smaller than: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addValidators(array('NotEmpty', 'Int'))->addErrorMessage('Please enter a valid date')->setDecorators($decorator)->setDisableTranslator(true);
$to = new Zend_Form_Element_Text('to');
$to->setLabel('End date greater than: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addValidators(array('NotEmpty', 'Int'))->addErrorMessage('Please enter a valid date')->setDecorators($decorator);
$toend = new Zend_Form_Element_Text('toend');
$toend->setLabel('End date smaller than: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addValidators(array('NotEmpty', 'Int'))->addErrorMessage('Please enter a valid date')->setDecorators($decorator);
$workflow = new Zend_Form_Element_Select('workflow');
$workflow->setLabel('Workflow stage: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addValidator('Int')->setDecorators($decorators);
if (in_array($this->getRole(), $this->higherlevel)) {
$workflow->addMultiOptions(array(NULL => NULL, 'Choose Worklow stage' => array('1' => 'Quarantine', '2' => 'On review', '4' => 'Awaiting validation', '3' => 'Published')));
}
if (in_array($this->getRole(), $this->restricted)) {
$workflow->addMultiOptions(array(NULL => NULL, 'Choose Worklow stage' => array('4' => 'Awaiting validation', '3' => 'Published')));
}
$treasure = new Zend_Form_Element_Checkbox('treasure');
$treasure->setLabel('Treasure find: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->setUncheckedValue(NULL)->setDecorators($decorators);
$treasureID = new Zend_Form_Element_Text('TID');
$treasureID->setLabel('Treasure ID number: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->setDecorators($decoratorsHide);
//Rally details
$rally = new Zend_Form_Element_Checkbox('rally');
$rally->setLabel('Rally find: ')->setRequired(false)->addValidator('Int')->addFilters(array('StringTrim', 'StripTags'))->setUncheckedValue(NULL)->setDecorators($decorators);
$rallyID = new Zend_Form_Element_Select('rallyID');
$rallyID->setLabel('Found at this rally: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addMultiOptions(array(NULL => NULL, 'Choose rally name' => $rally_options))->setDisableTranslator(true)->setDecorators($decoratorsRally);
$hoard = new Zend_Form_Element_Checkbox('hoard');
$hoard->setLabel('Hoard find: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->setUncheckedValue(NULL)->setDecorators($decorators);
$hoardID = new Zend_Form_Element_Select('hID');
$hoardID->setLabel('Part of this hoard: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addMultiOptions(array(NULL => NULL, 'Choose rally name' => $hoard_options))->setDecorators($decoratorsHoard);
$other_ref = new Zend_Form_Element_Text('otherRef');
$other_ref->setLabel('Other reference: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->setDecorators($decorator);
//Manufacture method
$manmethod = new Zend_Form_Element_Select('manufacture');
$manmethod->setLabel('Manufacture method: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addValidator('Int')->addMultiOptions(array(NULL => NULL, 'Choose method of manufacture' => $man_options))->setDecorators($decorators);
//Decoration method
$decmethod = new Zend_Form_Element_Select('decoration');
$decmethod->setLabel('Decoration method: ')->setRequired(false)->addValidator('Int')->addFilters(array('StringTrim', 'StripTags'))->addMultiOptions(array(NULL => NULL, 'Choose decoration method' => $decmeth_options))->setDecorators($decorators);
//Surface treatment
$surftreat = new Zend_Form_Element_Select('surface');
$surftreat->setLabel('Surface Treatment: ')->setRequired(false)->addValidator('Int')->addFilters(array('StringTrim', 'StripTags'))->addMultiOptions(array(NULL => NULL, 'Choose surface treatment' => $surface_options))->setDecorators($decorators);
//decoration style
$decstyle = new Zend_Form_Element_Select('decstyle');
$decstyle->setLabel('Decorative style: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addMultiOptions(array(NULL => NULL, 'Choose decorative style' => $decoration_options))->addValidator('Int')->setDecorators($decorators);
//Preservation of object
$preservation = new Zend_Form_Element_Select('preservation');
$preservation->setLabel('Preservation: ')->setRequired(false)->addFilter('StripTags')->addFilter('StringTrim')->addValidator('Int')->addMultiOptions(array(NULL => NULL, 'Choose level of preservation' => $preserve_options))->setDecorators($decorators);
$county = new Zend_Form_Element_Select('county');
$county->setLabel('County: ')->addValidators(array('NotEmpty'))->addFilters(array('StringTrim', 'StripTags'))->addMultiOptions(array(NULL => NULL, 'Choose county' => $county_options))->setDecorators($decorators);
$district = new Zend_Form_Element_Select('district');
$district->setLabel('District: ')->addMultiOptions(array(NULL => 'Choose district after county'))->setRegisterInArrayValidator(false)->addFilters(array('StringTrim', 'StripTags'))->setDisableTranslator(true)->setDecorators($decorators);
$parish = new Zend_Form_Element_Select('parish');
$parish->setLabel('Parish: ')->setRegisterInArrayValidator(false)->addFilters(array('StringTrim', 'StripTags'))->addMultiOptions(array(NULL => 'Choose parish after county'))->setDisableTranslator(true)->setDecorators($decorators);
$regionID = new Zend_Form_Element_Select('regionID');
$regionID->setLabel('European region: ')->setRegisterInArrayValidator(false)->addValidator('Int')->addMultiOptions(array(NULL => 'Choose a region for a wide result', 'Choose region' => $region_options))->setDisableTranslator(true)->setDecorators($decorators);
$gridref = new Zend_Form_Element_Text('gridref');
$gridref->setLabel('Grid reference: ')->addValidators(array('NotEmpty'))->addFilters(array('StringTrim', 'StripTags'))->setDecorators($decorator);
$fourFigure = new Zend_Form_Element_Text('fourFigure');
$fourFigure->setLabel('Four figure grid reference: ')->addValidators(array('NotEmpty'))->addFilters(array('StringTrim', 'StripTags'))->setDecorators($decorator);
$idBy = new Zend_Form_Element_Text('idby');
$idBy->setLabel('Primary identifier: ')->addValidators(array('NotEmpty'))->addFilters(array('StringTrim', 'StripTags'))->setDecorators($decorator);
$identifierID = new Zend_Form_Element_Hidden('identifierID');
$identifierID->removeDecorator('HtmlTag')->removeDecorator('DtDdWrapper')->addFilters(array('StringTrim', 'StripTags'))->removeDecorator('Label');
$created = new Zend_Form_Element_Text('createdBefore');
$created->setLabel('Date record created on or before: ')->addValidator('Date')->addFilters(array('StringTrim', 'StripTags'))->setDecorators($decorator);
$created2 = new Zend_Form_Element_Text('createdAfter');
$created2->setLabel('Date record created on or after: ')->addValidator('Date')->addFilters(array('StringTrim', 'StripTags'))->setDecorators($decorator);
$finder = new Zend_Form_Element_Text('finder');
$finder->setLabel('Found by: ')->addFilters(array('StringTrim', 'StripTags'))->setDecorators($decorator);
$finderID = new Zend_Form_Element_Hidden('finderID');
$finderID->removeDecorator('HtmlTag')->addFilters(array('StringTrim', 'StripTags'))->removeDecorator('DtDdWrapper')->removeDecorator('Label');
$recordby = new Zend_Form_Element_Text('recordby');
$recordby->setLabel('Recorded by: ')->addValidators(array('NotEmpty'))->addFilters(array('StringTrim', 'StripTags'))->setAttrib('autoComplete', 'true')->setDecorators($decorator);
$recorderID = new Zend_Form_Element_Hidden('recorderID');
$recorderID->removeDecorator('HtmlTag')->addFilters(array('StringTrim', 'StripTags'))->removeDecorator('DtDdWrapper')->removeDecorator('Label');
$discoverydate = new Zend_Form_Element_Select('discovered');
$discoverydate->setLabel('Year of discovery')->setMultiOptions(array(NULL => 'Choose a year of discovery', 'Date range' => $years_list))->addValidator('Int')->addFilters(array('StringTrim', 'StripTags'))->setDecorators($decorators);
//Submit button
$submit = new Zend_Form_Element_Submit('submit');
$submit->setAttrib('id', 'submitbutton')->setAttrib('class', 'large')->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->setLabel('Submit your search');
$material1 = new Zend_Form_Element_Select('material');
$material1->setLabel('Primary material: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => NULL, 'Choose primary material' => $primary_options))->setDecorators($decorators);
$woeid = new Zend_Form_Element_Text('woeid');
$woeid->setLabel('Where on earth ID: ')->addValidator('Int')->addFilters(array('StripTags', 'StringTrim'))->setDecorators($decorator);
$elevation = new Zend_Form_Element_Text('elevation');
$elevation->setLabel('Elevation: ')->addValidator('Int')->addFilters(array('StripTags', 'StringTrim'))->setDecorators($decorator);
if (in_array($this->getRole(), $this->restricted)) {
$this->addElements(array($old_findID, $objecttype, $broadperiod, $description, $from, $to, $workflow, $findofnote, $findofnotereason, $rally, $rallyID, $hoard, $hoardID, $other_ref, $manmethod, $fromend, $toend, $notes, $objdate1period, $objdate2period, $county, $regionID, $district, $parish, $fourFigure, $objdate1subperiod, $objdate2subperiod, $treasure, $treasureID, $discoverydate, $created, $created2, $idBy, $recordby, $recorderID, $identifierID, $culture, $surftreat, $submit, $material1, $elevation, $woeid, $institution));
} else {
$this->addElements(array($old_findID, $objecttype, $broadperiod, $description, $from, $to, $workflow, $findofnote, $findofnotereason, $rally, $rallyID, $hoard, $hoardID, $other_ref, $manmethod, $fromend, $toend, $notes, $objdate1period, $objdate2period, $county, $regionID, $district, $parish, $fourFigure, $elevation, $woeid, $objdate1subperiod, $objdate2subperiod, $treasure, $treasureID, $discoverydate, $created, $created2, $idBy, $finder, $finderID, $recordby, $recorderID, $identifierID, $culture, $surftreat, $submit, $material1, $institution));
}
$this->addDisplayGroup(array('old_findID', 'objecttype', 'description', 'notes', 'note', 'reason', 'treasure', 'TID', 'rally', 'rallyID', 'hoard', 'hID', 'workflow', 'otherRef', 'material', 'manufacture', 'surface'), 'details')->removeDecorator('HtmlTag');
$this->details->addDecorators(array('FormElements', array('HtmlTag', array('tag' => 'ul'))));
$this->details->removeDecorator('DtDdWrapper');
$this->details->setLegend('Main details: ');
$hash = new Zend_Form_Element_Hash('csrf');
$hash->setValue($this->_config->form->salt)->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('label')->setTimeout(60);
$this->addElement($hash);
$this->addDisplayGroup(array('broadperiod', 'fromsubperiod', 'periodFrom', 'tosubperiod', 'periodTo', 'culture', 'from', 'fromend', 'to', 'toend'), 'Temporaldetails')->removeDecorator('HtmlTag');
$this->Temporaldetails->addDecorators(array('FormElements', array('HtmlTag', array('tag' => 'ul'))));
$this->Temporaldetails->removeDecorator('DtDdWrapper');
$this->Temporaldetails->setLegend('Temporal details: ');
$this->addDisplayGroup(array('county', 'regionID', 'district', 'parish', 'fourFigure', 'elevation', 'woeid'), 'Spatial')->removeDecorator('HtmlTag');
$this->Spatial->addDecorators(array('FormElements', array('HtmlTag', array('tag' => 'ul'))));
$this->Spatial->removeDecorator('DtDdWrapper');
$this->Spatial->setLegend('Spatial details: ');
if (in_array($this->getRole(), $this->restricted)) {
$this->addDisplayGroup(array('institution', 'idby', 'identifierID', 'recordby', 'recorderID', 'createdAfter', 'createdBefore', 'discovered'), 'Discovery')->removeDecorator('HtmlTag');
} else {
$this->addDisplayGroup(array('institution', 'finder', 'idby', 'identifierID', 'recordby', 'recorderID', 'createdAfter', 'createdBefore', 'discovered'), 'Discovery')->removeDecorator('HtmlTag');
}
$this->Discovery->addDecorators(array('FormElements', array('HtmlTag', array('tag' => 'ul'))));
$this->Discovery->removeDecorator('DtDdWrapper');
$this->Discovery->setLegend('Discovery details: ');
//$this->setLegend('Perform an advanced search on our database: ');
$this->addDisplayGroup(array('submit'), 'submit');
$this->submit->removeDecorator('DtDdWrapper');
$this->submit->removeDecorator('HtmlTag');
}
public function drill_down($type, $id) {
$to = $this -> input -> post('to');
$from = $this -> input -> post('from');
if ($to == false) {
$to = date("U", mktime(0, 0, 0, 1, 1, date("Y") + 1));
} else if ($to == true) {
$to = strtotime($to);
}
if ($from == false) {
$from = date("U", mktime(0, 0, 0, 1, 1, date('Y')));
} else if ($from == true) {
$from = strtotime($from);
}
$data['type'] = $type;
$data['id'] = $id;
$data['title'] = "Disbursement Management::Receipts Log For The Period Between " . date('d/m/Y', $from) . " to " . date('d/m/Y', $to);
$data['content_view'] = "view_receipts_view";
$data['vaccines'] = Vaccines::getAll_Minified();
$return_array = array();
$current_stock = array();
$population = 0;
$year = date('Y');
$balances = array();
$archive_date = date('U');
//Type 0 means we are drilling down to a region
if ($type == 0) {
$data['recipient'] = Regions::getRegionName($id);
$data['type'] = 0;
$data['store_id'] = $id;
foreach ($data['vaccines'] as $vaccine) {
$return_array[$vaccine -> id] = Disbursements::getRegionalReceipts($id, $vaccine -> id, $from, $to);
$current_stock[$vaccine -> id] = Disbursements::getRegionalPeriodBalance($id, $vaccine -> id, $archive_date);
}
$population = Regional_Populations::getRegionalPopulation($id, $year);
}
//Type 1 means we are drilling down to a district
else if ($type == 1) {
$data['recipient'] = Districts::getDistrictName($id);
$data['type'] = 1;
$data['store_id'] = $id;
foreach ($data['vaccines'] as $vaccine) {
$return_array[$vaccine -> id] = Disbursements::getDistrictReceipts($id, $vaccine -> id, $from, $to);
//$current_stock[$vaccine->id] = Disbursements::getDistrictStockAtHand($id,$vaccine->id);
$current_stock[$vaccine -> id] = Disbursements::getDistrictPeriodBalance($id, $vaccine -> id, $archive_date);
}
$population = District_Populations::getDistrictPopulation($id, $year);
}
//Type 2 means we are drilling down to the whole country
if ($type == 2) {
$data['recipient'] = "National Store";
$data['type'] = 2;
$data['store_id'] = "0";
foreach ($data['vaccines'] as $vaccine) {
$return_array[$vaccine -> id] = Disbursements::getNationalReceived($vaccine -> id, $from, $to);
$current_stock[$vaccine -> id] = Disbursements::getNationalPeriodBalance($vaccine -> id, $archive_date);
}
$population = Regional_Populations::getNationalPopulation($year);
}
$data['population'] = $population;
$data['disbursements'] = $return_array;
$data['current_stocks'] = $current_stock;
$this -> base_params_min_graph($data);
}
public function __construct($options = null)
{
//Get data to form select menu for primary and secondary material
$primaries = new Materials();
$primary_options = $primaries->getPrimaries();
//Get Rally data
$rallies = new Rallies();
$rally_options = $rallies->getRallies();
//Get Hoard data
$hoards = new Hoards();
$hoard_options = $hoards->getHoards();
$counties = new Counties();
$county_options = $counties->getCountyName2();
$denominations = new Denominations();
$denom_options = $denominations->getOptionsRoman();
$rulers = new Rulers();
$ruler_options = $rulers->getRomanRulers();
$mints = new Mints();
$mint_options = $mints->getRomanMints();
$axis = new Dieaxes();
$axis_options = $axis->getAxes();
$reece = new Reeces();
$reece_options = $reece->getReeces();
$regions = new Regions();
$region_options = $regions->getRegionName();
$moneyers = new Moneyers();
$money = $moneyers->getRepublicMoneyers();
$institutions = new Institutions();
$inst_options = $institutions->getInsts();
parent::__construct($options);
$decorator = array('SimpleInput');
$decoratorSelect = array('SelectInput');
$decorators = array(array('ViewHelper'), array('Description', array('placement' => 'append', 'class' => 'info')), array('Errors', array('placement' => 'prepend', 'class' => 'error', 'tag' => 'li')), array('Label', array('separator' => ' ', 'requiredSuffix' => ' *')), array('HtmlTag', array('tag' => 'li')));
$decoratorsHide = array(array('ViewHelper'), array('Description', array('placement' => 'append', 'class' => 'info')), array('Errors', array('placement' => 'prepend', 'class' => 'error', 'tag' => 'li')), array('Label', array('separator' => ' ', 'class' => 'hideme')), array('HtmlTag', array('tag' => 'li')));
$decoratorsRally = array(array('ViewHelper'), array('Description', array('placement' => 'append', 'class' => 'info')), array('Errors', array('placement' => 'prepend', 'class' => 'error', 'tag' => 'li')), array('Label', array('separator' => ' ', 'class' => 'hiderally')), array('HtmlTag', array('tag' => 'li')));
$decoratorsHoard = array(array('ViewHelper'), array('Description', array('placement' => 'append', 'class' => 'info')), array('Errors', array('placement' => 'prepend', 'class' => 'error', 'tag' => 'li')), array('Label', array('separator' => ' ', 'class' => 'hidehoard')), array('HtmlTag', array('tag' => 'li')));
$decoratorsNote = array(array('ViewHelper'), array('Description', array('placement' => 'append', 'class' => 'info')), array('Errors', array('placement' => 'prepend', 'class' => 'error', 'tag' => 'li')), array('Label', array('separator' => ' ', 'class' => 'hidenote')), array('HtmlTag', array('tag' => 'li')));
$this->setName('search-roman-coins');
$old_findID = new Zend_Form_Element_Text('old_findID');
$old_findID->setLabel('Find number: ')->addFilters(array('StripTags', 'StringTrim'))->addErrorMessage('Please enter a valid number!')->setDecorators($decorators);
$description = new Zend_Form_Element_Text('description');
$description->setLabel('Object description contains: ')->addFilters(array('StripTags', 'StringTrim'))->setAttrib('size', 60)->addErrorMessage('Please enter a valid term')->setDecorators($decorators);
$workflow = new Zend_Form_Element_Select('workflow');
$workflow->setLabel('Workflow stage: ')->addFilters(array('StripTags', 'StringTrim'))->setDecorators($decorators);
if (in_array($this->getRole(), $this->_higherlevel)) {
$workflow->addMultiOptions(array(NULL => NULL, 'Available worklow stage' => array('1' => 'Quarantine', '2' => 'On review', '4' => 'Awaiting validation', '3' => 'Published')));
}
if (in_array($this->getRole(), $this->_restricted)) {
$workflow->addMultiOptions(array(NULL => 'Choose a workflow stage', 'Available worklow stage' => array('4' => 'Awaiting validation', '3' => 'Published')));
}
$hash = new Zend_Form_Element_Hash('csrf');
$hash->setValue($this->_config->form->salt)->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('label')->setTimeout(4800);
$this->addElement($hash);
//Rally details
$rally = new Zend_Form_Element_Checkbox('rally');
$rally->setLabel('Rally find: ')->addFilters(array('StripTags', 'StringTrim'))->setUncheckedValue(NULL)->setDecorators($decorators);
$rallyID = new Zend_Form_Element_Select('rallyID');
$rallyID->setLabel('Found at this rally: ')->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose rally name', 'Available rallies' => $rally_options))->addValidator('InArray', false, array(array_keys($rally_options)))->setDecorators($decorators);
$hoard = new Zend_Form_Element_Checkbox('hoard');
$hoard->setLabel('Hoard find: ')->addFilters(array('StripTags', 'StringTrim'))->setUncheckedValue(NULL)->setDecorators($decorators);
$hoardID = new Zend_Form_Element_Select('hID');
$hoardID->setLabel('Part of this hoard: ')->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose hoard name', 'Available hoards' => $hoard_options))->addValidator('InArray', false, array(array_keys($hoard_options)))->setDecorators($decorators);
$county = new Zend_Form_Element_Select('county');
$county->setLabel('County: ')->addValidators(array('NotEmpty'))->addMultiOptions(array(NULL => 'Choose county first', 'Available counties' => $county_options))->addValidator('InArray', false, array(array_keys($county_options)))->setDecorators($decorators);
$district = new Zend_Form_Element_Select('district');
$district->setLabel('District: ')->addMultiOptions(array(NULL => 'Choose district after county'))->setRegisterInArrayValidator(false)->setDecorators($decorators)->disabled = true;
$parish = new Zend_Form_Element_Select('parish');
$parish->setLabel('Parish: ')->addMultiOptions(array(NULL => 'Choose parish after county'))->setDecorators($decorators)->disabled = true;
$regionID = new Zend_Form_Element_Select('regionID');
$regionID->setLabel('European region: ')->setDecorators($decorators)->addMultiOptions(array(NULL => 'Choose a region for a wide result', 'Choose region' => $region_options))->addValidator('InArray', false, array(array_keys($region_options)))->addFilters(array('StripTags', 'StringTrim'));
$gridref = new Zend_Form_Element_Text('gridref');
$gridref->setLabel('Grid reference: ')->addValidators(array('ValidGridRef'))->addFilters(array('StripTags', 'StringTrim'))->setDecorators($decorators);
$fourFigure = new Zend_Form_Element_Text('fourFigure');
$fourFigure->setLabel('Four figure grid reference: ')->addValidators(array('ValidGridRef'))->addFilters(array('StripTags', 'StringTrim'))->setDecorators($decorators);
###
##Numismatic data
###
//Denomination
$denomination = new Zend_Form_Element_Select('denomination');
$denomination->setLabel('Denomination: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose denomination type', 'Available denominations' => $denom_options))->addValidator('InArray', false, array(array_keys($denom_options)))->setDecorators($decorators);
//Primary ruler
$ruler = new Zend_Form_Element_Select('ruler');
$ruler->setLabel('Ruler / issuer: ')->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose primary ruler', 'Available rulers' => $ruler_options))->addValidator('InArray', false, array(array_keys($ruler_options)))->setDecorators($decorators);
//Mint
$mint = new Zend_Form_Element_Select('mint');
$mint->setLabel('Issuing mint: ')->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose issuing mint', 'Available mints' => $mint_options))->addValidator('InArray', false, array(array_keys($mint_options)))->setDecorators($decorators);
//Reece
$reece = new Zend_Form_Element_Select('reeceID');
$reece->setLabel('Reece period: ')->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose Reece period', 'Available Reece periods' => $reece_options))->addValidator('InArray', false, array(array_keys($reece_options)))->setDecorators($decorators);
//Reverse type
$reverse = new Zend_Form_Element_Select('revtypeID');
$reverse->setLabel('Fourth Century reverse type: ')->setDescription('This field is only applicable for fourth century AD coins.')->addFilters(array('StripTags', 'StringTrim'))->setDecorators($decorators)->addMultiOptions(array(NULL => 'Only available after choosing a 4th century issuer'));
//Moneyer
$moneyer = new Zend_Form_Element_Select('moneyer');
$moneyer->setLabel('Republican moneyers: ')->setDescription('This field is only applicable for Republican coins.')->addFilters(array('StripTags', 'StringTrim'))->setDecorators($decorators)->addMultiOptions(array(NULL => 'Only available after choosing a Republican issuer'))->addValidator('InArray', false, array(array_keys($money)));
//Obverse inscription
$obverseinsc = new Zend_Form_Element_Text('obverseLegend');
$obverseinsc->setLabel('Obverse inscription contains: ')->addFilters(array('StripTags', 'StringTrim'))->setAttrib('size', 60)->addErrorMessage('Please enter a valid term')->setDecorators($decorators);
//Obverse description
$obversedesc = new Zend_Form_Element_Text('obverseDescription');
$obversedesc->setLabel('Obverse description contains: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->setAttrib('size', 60)->addErrorMessage('Please enter a valid term')->setDecorators($decorators);
//reverse inscription
$reverseinsc = new Zend_Form_Element_Text('reverseLegend');
$reverseinsc->setLabel('Reverse inscription contains: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addErrorMessage('Please enter a valid term')->setAttrib('size', 60)->setDecorators($decorators);
//reverse description
$reversedesc = new Zend_Form_Element_Text('reverseDescription');
$reversedesc->setLabel('Reverse description contains: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addErrorMessage('Please enter a valid term')->setAttrib('size', 60)->setDecorators($decorators);
//Die axis
$axis = new Zend_Form_Element_Select('axis');
$axis->setLabel('Die axis measurement: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => NULL, 'Choose measurement' => $axis_options))->addValidator('InArray', false, array(array_keys($axis_options)))->setDecorators($decorators);
$objecttype = new Zend_Form_Element_Hidden('objecttype');
$objecttype->setValue('coin')->setAttrib('class', 'none')->removeDecorator('label')->removeDecorator('HtmlTag')->removeDecorator('DtDdWrapper');
$broadperiod = new Zend_Form_Element_Hidden('broadperiod');
$broadperiod->setValue('Roman')->setAttrib('class', 'none')->removeDecorator('label')->removeDecorator('HtmlTag')->removeDecorator('DtDdWrapper')->addFilters(array('StringToUpper', 'StripTags', 'StringTrim'))->addValidator('Alpha');
//Submit button
$submit = new Zend_Form_Element_Submit('submit');
$submit->setAttrib('id', 'submitbutton')->removeDecorator('label')->removeDecorator('HtmlTag')->removeDecorator('DtDdWrapper')->setLabel('Submit your search ..')->setAttrib('class', 'large');
$institution = new Zend_Form_Element_Select('institution');
$institution->setLabel('Recording institution: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addMultiOptions(array(NULL => NULL, 'Choose institution' => $inst_options))->setDecorators($decorators);
$this->addElements(array($old_findID, $description, $workflow, $rally, $rallyID, $hoard, $hoardID, $county, $regionID, $district, $parish, $fourFigure, $gridref, $denomination, $ruler, $mint, $axis, $reece, $reverse, $obverseinsc, $obversedesc, $reverseinsc, $reversedesc, $moneyer, $objecttype, $broadperiod, $submit, $hash, $institution));
$this->addDisplayGroup(array('denomination', 'ruler', 'mint', 'moneyer', 'axis', 'reeceID', 'revtypeID', 'obverseLegend', 'obverseDescription', 'reverseLegend', 'reverseDescription'), 'numismatics')->removeDecorator('HtmlTag');
$this->numismatics->addDecorators(array('FormElements', array('HtmlTag', array('tag' => 'ul'))));
$this->numismatics->removeDecorator('DtDdWrapper');
$this->addDisplayGroup(array('old_findID', 'description', 'rally', 'rallyID', 'hoard', 'hID', 'workflow'), 'details')->removeDecorator('HtmlTag');
$this->details->addDecorators(array('FormElements', array('HtmlTag', array('tag' => 'ul'))));
$this->details->removeDecorator('DtDdWrapper');
$this->addDisplayGroup(array('county', 'regionID', 'district', 'parish', 'gridref', 'fourFigure', 'institution'), 'spatial')->removeDecorator('HtmlTag');
$this->spatial->addDecorators(array('FormElements', array('HtmlTag', array('tag' => 'ul'))));
$this->spatial->removeDecorator('DtDdWrapper');
$this->addDisplayGroup(array('submit'), 'submit');
$this->numismatics->setLegend('Numismatic details');
$this->details->setLegend('Artefact details');
$this->spatial->setLegend('Spatial details');
}
public function __construct($options = null)
{
$primaries = new Materials();
$primary_options = $primaries->getPrimaries();
//Get data to form select menu for periods
//Get Rally data
$rallies = new Rallies();
$rally_options = $rallies->getRallies();
//Get Hoard data
$hoards = new Hoards();
$hoard_options = $hoards->getHoards();
$counties = new Counties();
$county_options = $counties->getCountyName2();
$rulers = new Rulers();
$ruler_options = $rulers->getMedievalRulers();
$denominations = new Denominations();
$denomination_options = $denominations->getOptionsMedieval();
$mints = new Mints();
$mint_options = $mints->getMedievalMints();
$axis = new Dieaxes();
$axis_options = $axis->getAxes();
$cats = new CategoriesCoins();
$cat_options = $cats->getPeriodMed();
$regions = new Regions();
$region_options = $regions->getRegionName();
$institutions = new Institutions();
$inst_options = $institutions->getInsts();
$axis = new Dieaxes();
$axis_options = $axis->getAxes();
parent::__construct($options);
$decorators = array(array('ViewHelper'), array('Description', array('placement' => 'append', 'class' => 'info')), array('Errors', array('placement' => 'prepend', 'class' => 'error', 'tag' => 'li')), array('Label', array('separator' => ' ', 'requiredSuffix' => ' *')), array('HtmlTag', array('tag' => 'li')));
$this->setName('medNumismaticsSearch');
$old_findID = new Zend_Form_Element_Text('old_findID');
$old_findID->setLabel('Find number: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addErrorMessage('Please enter a valid number!')->setDecorators($decorators);
$description = new Zend_Form_Element_Text('description');
$description->setLabel('Object description contains: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addErrorMessage('Please enter a valid term')->setDecorators($decorators);
$workflow = new Zend_Form_Element_Select('workflow');
$workflow->setLabel('Workflow stage: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => NULL, 'Choose Worklow stage' => array('1' => 'Quarantine', '2' => 'On review', '3' => 'Awaiting validation', '4' => 'Published')))->setDecorators($decorators);
//Rally details
$rally = new Zend_Form_Element_Checkbox('rally');
$rally->setLabel('Rally find: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->setUncheckedValue(NULL)->setDecorators($decorators);
$rallyID = new Zend_Form_Element_Select('rallyID');
$rallyID->setLabel('Found at this rally: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => NULL, 'Choose rally name' => $rally_options))->addValidator('InArray', false, array(array_keys($rally_options)))->setDecorators($decorators);
$hoard = new Zend_Form_Element_Checkbox('hoard');
$hoard->setLabel('Hoard find: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addValidator('Int')->setUncheckedValue(NULL)->setDecorators($decorators);
$hoardID = new Zend_Form_Element_Select('hID');
$hoardID->setLabel('Part of this hoard: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => NULL, 'Choose rally name' => $hoard_options))->addValidator('InArray', false, array(array_keys($hoard_options)))->setDecorators($decorators);
$county = new Zend_Form_Element_Select('county');
$county->setLabel('County: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => NULL, 'Choose county' => $county_options))->addValidator('InArray', false, array(array_keys($county_options)))->setDecorators($decorators);
$district = new Zend_Form_Element_Select('district');
$district->setLabel('District: ')->addMultiOptions(array(NULL => 'Choose district after county'))->setRegisterInArrayValidator(false)->setDecorators($decorators);
$parish = new Zend_Form_Element_Select('parish');
$parish->setLabel('Parish: ')->setRegisterInArrayValidator(false)->addMultiOptions(array(NULL => 'Choose parish after county'))->setDecorators($decorators);
$regionID = new Zend_Form_Element_Select('regionID');
$regionID->setLabel('European region: ')->setRegisterInArrayValidator(false)->addMultiOptions(array(NULL => 'Choose a region for a wide result', 'Choose region' => $region_options))->setDecorators($decorators);
$gridref = new Zend_Form_Element_Text('gridref');
$gridref->setLabel('Grid reference: ')->addValidators(array('NotEmpty', 'ValidGridRef'))->setDecorators($decorators);
$fourFigure = new Zend_Form_Element_Text('fourFigure');
$fourFigure->setLabel('Four figure grid reference: ')->addValidators(array('NotEmpty', 'ValidGridRef'))->setDecorators($decorators);
###
##Numismatic data
###
// Denomination
$denomination = new Zend_Form_Element_Select('denomination');
$denomination->setLabel('Denomination: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose a denomination', 'Available denominations' => $denomination_options))->addValidator('InArray', false, array(array_keys($denomination_options)))->setDecorators($decorators);
$cat = new Zend_Form_Element_Select('category');
$cat->setLabel('Category: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose a category', 'Available categories' => $cat_options))->addValidator('InArray', false, array(array_keys($cat_options)))->setDecorators($decorators);
$type = new Zend_Form_Element_Select('typeID');
$type->setLabel('Coin type: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->setDecorators($decorators);
//Primary ruler
$ruler = new Zend_Form_Element_Select('ruler');
$ruler->setLabel('Ruler / issuer: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose a ruler', 'Available issuers' => $ruler_options))->addValidator('InArray', false, array(array_keys($ruler_options)))->setDecorators($decorators);
//Mint
$mint = new Zend_Form_Element_Select('mint');
$mint->setLabel('Issuing mint: ')->setRequired(false)->addFilter('StripTags')->addFilter('StringTrim')->addMultiOptions(array(NULL => 'Choose a mint', 'Available mints' => $mint_options))->addValidator('InArray', false, array(array_keys($mint_options)))->setDecorators($decorators);
//Obverse inscription
$obverseinsc = new Zend_Form_Element_Text('obinsc');
$obverseinsc->setLabel('Obverse inscription contains: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addErrorMessage('Please enter a valid term')->setDecorators($decorators);
//Obverse description
$obversedesc = new Zend_Form_Element_Text('obdesc');
$obversedesc->setLabel('Obverse description contains: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addErrorMessage('Please enter a valid term')->setDecorators($decorators);
//reverse inscription
$reverseinsc = new Zend_Form_Element_Text('revinsc');
$reverseinsc->setLabel('Reverse inscription contains: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addErrorMessage('Please enter a valid term')->setDecorators($decorators);
//reverse description
$reversedesc = new Zend_Form_Element_Text('revdesc');
$reversedesc->setLabel('Reverse description contains: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addErrorMessage('Please enter a valid term')->setDecorators($decorators);
//Die axis
$axis = new Zend_Form_Element_Select('axis');
$axis->setLabel('Die axis measurement: ')->setRequired(false)->addFilters(array('StripTags', 'StringTrim'))->addMultiOptions(array(NULL => 'Choose an axis', 'Available measurements' => $axis_options))->addValidator('InArray', false, array(array_keys($axis_options)))->setDecorators($decorators);
$objecttype = new Zend_Form_Element_Hidden('objecttype');
$objecttype->setValue('COIN')->addFilters(array('StripTags', 'StringTrim'))->setAttrib('class', 'none')->removeDecorator('label')->removeDecorator('HtmlTag')->removeDecorator('DtDdWrapper')->addValidator('Alpha');
$broadperiod = new Zend_Form_Element_Hidden('broadperiod');
$broadperiod->setValue('MEDIEVAL')->setAttrib('class', 'none')->removeDecorator('label')->removeDecorator('HtmlTag')->removeDecorator('DtDdWrapper')->addFilters(array('StripTags', 'StringTrim'))->addValidator('Alpha');
//Submit button
$submit = new Zend_Form_Element_Submit('submit');
$submit->setAttrib('id', 'submitbutton')->removeDecorator('label')->removeDecorator('HtmlTag')->removeDecorator('DtDdWrapper')->setLabel('Submit')->setAttrib('class', 'large');
$hash = new Zend_Form_Element_Hash('csrf');
$hash->setValue($this->_config->form->salt)->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('label')->setTimeout(4800);
$this->addElement($hash);
$institution = new Zend_Form_Element_Select('institution');
$institution->setLabel('Recording institution: ')->setRequired(false)->addFilters(array('StringTrim', 'StripTags'))->addMultiOptions(array(NULL => 'Choose an institution', 'Available institutions' => $inst_options))->setDecorators($decorators);
$this->addElements(array($old_findID, $type, $description, $workflow, $rally, $rallyID, $hoard, $hoardID, $county, $regionID, $district, $parish, $fourFigure, $gridref, $denomination, $ruler, $mint, $axis, $obverseinsc, $obversedesc, $reverseinsc, $reversedesc, $objecttype, $broadperiod, $cat, $submit, $hash, $institution));
$this->addDisplayGroup(array('category', 'ruler', 'typeID', 'denomination', 'mint', 'moneyer', 'axis', 'obinsc', 'obdesc', 'revinsc', 'revdesc'), 'numismatics')->removeDecorator('HtmlTag');
$this->numismatics->addDecorators(array('FormElements', array('HtmlTag', array('tag' => 'ul'))));
$this->numismatics->removeDecorator('DtDdWrapper');
$this->numismatics->setLegend('Numismatic details: ');
$this->addDisplayGroup(array('old_findID', 'description', 'rally', 'rallyID', 'hoard', 'hID', 'workflow'), 'details')->removeDecorator('HtmlTag');
$this->details->setLegend('Object details:');
$this->details->addDecorators(array('FormElements', array('HtmlTag', array('tag' => 'ul'))));
$this->details->removeDecorator('DtDdWrapper');
$this->addDisplayGroup(array('county', 'regionID', 'district', 'parish', 'gridref', 'fourFigure', 'institution'), 'spatial')->removeDecorator('HtmlTag');
$this->spatial->addDecorators(array('FormElements', array('HtmlTag', array('tag' => 'ul'))));
$this->spatial->removeDecorator('DtDdWrapper');
$this->spatial->setLegend('Spatial details: ');
$this->setLegend('Perform an advanced search on our database: ');
$this->addDisplayGroup(array('submit'), 'submit');
}
