public function edit($list_id, $lpq_id = '')
{
$ObjQuery = new queryModel();
$ObjPreQualify = new preQualifyModel();
$data = array('list_id' => $list_id);
$details = array('lpq_id' => '', 'list_id' => $list_id, $ObjPreQualify->tblpref . 'organization_date' => '', $ObjPreQualify->tblpref . 'business_type' => '', $ObjPreQualify->tblpref . 'fed_tax_id' => '', $ObjPreQualify->tblpref . 'disadvantaged_status' => '', $ObjPreQualify->tblpref . 'financial_company_secure_bond' => '', $ObjPreQualify->tblpref . 'financial_surety_company' => '', $ObjPreQualify->tblpref . 'financial_agents_fullname' => '', $ObjPreQualify->tblpref . 'financial_agents_email' => '', $ObjPreQualify->tblpref . 'financial_available_bonding_capacity' => '', $ObjPreQualify->tblpref . 'financial_available_bonding_rate' => '', $ObjPreQualify->tblpref . 'bank' => '', $ObjPreQualify->tblpref . 'bank_agents_fullname' => '', $ObjPreQualify->tblpref . 'bank_agents_email' => '', $ObjPreQualify->tblpref . 'insurance_com' => '', $ObjPreQualify->tblpref . 'insurance_com_agents_fullname' => '', $ObjPreQualify->tblpref . 'insurance_com_agents_email' => '', $ObjPreQualify->tblpref . 'insurance_com_gen_liability_limit' => '', $ObjPreQualify->tblpref . 'insurance_com_workers_comp_limit' => '', $ObjPreQualify->tblpref . 'safety_drug_free_workplace' => '', $ObjPreQualify->tblpref . 'safety_workers_comp_experience' => '', $ObjPreQualify->tblpref . 'ref_vendors_company_name1' => '', $ObjPreQualify->tblpref . 'ref_vendors_contact_name1' => '', $ObjPreQualify->tblpref . 'ref_vendors_email1' => '', $ObjPreQualify->tblpref . 'ref_vendors_company_name2' => '', $ObjPreQualify->tblpref . 'ref_vendors_contact_name2' => '', $ObjPreQualify->tblpref . 'ref_vendors_email2' => '', $ObjPreQualify->tblpref . 'ref_vendors_company_name3' => '', $ObjPreQualify->tblpref . 'ref_vendors_contact_name3' => '', $ObjPreQualify->tblpref . 'ref_vendors_email3' => '', $ObjPreQualify->tblpref . 'ref_contractors_company_name1' => '', $ObjPreQualify->tblpref . 'ref_contractors_contact_name1' => '', $ObjPreQualify->tblpref . 'ref_contractors_email1' => '', $ObjPreQualify->tblpref . 'ref_contractors_company_name2' => '', $ObjPreQualify->tblpref . 'ref_contractors_contact_name2' => '', $ObjPreQualify->tblpref . 'ref_contractors_email2' => '', $ObjPreQualify->tblpref . 'ref_contractors_company_name3' => '', $ObjPreQualify->tblpref . 'ref_contractors_contact_name3' => '', $ObjPreQualify->tblpref . 'ref_contractors_email3' => '');
if ($lpq_id) {
$details = $ObjPreQualify->get_record_join(array('`j`.`lpq_id`=' => $lpq_id));
}
$data = $ObjQuery->array_to_data($data, $details);
$year = FDateTime::fdate($details->lpq_organization_date, 'Y');
$month = FDateTime::fdate($details->lpq_organization_date, 'm');
$day = FDateTime::fdate($details->lpq_organization_date, 'd');
$data['select_year'] = $ObjPreQualify->select_year($year);
$data['select_month'] = $ObjPreQualify->select_month($month);
$data['select_day'] = $ObjPreQualify->select_day($day);
return View::make('pre_qualify_form', $data);
}