function employment_form(&$node) { global $user; $output = ''; if (function_exists('taxonomy_node_form')) { $output .= implode('', taxonomy_node_form('employment', $node)); } if(!empty($node->nid)) { //Load The Node In $sql = 'SELECT *, UNIX_TIMESTAMP(closing_date) as closing_date FROM {employment} where nid ="'.$node->nid.'"'; $sqlResult = db_query($sql); while($employment_result = db_fetch_assoc($sqlResult)) { $employment = $employment_result; } $employment['web'] = explode(",",$employment['web']); $employment['print'] = explode(",",$employment['print']); } //Select List Options $Places = new Places(); $Places->getPlacesArray(); $places = $Places->item_array; foreach($places as $place) { $place_list[$place['nid']] = $place['SiteName']; } $query = db_query("SELECT * FROM {users}"); $user_list['0'] = '-- Please Select'; while($users = mysql_fetch_assoc($query)) { $user_list[$users['uid']] = $users['name']; } $query = db_query('SELECT * FROM {user_sites} WHERE uid = "'.$user->uid.'"'); $user_sites['0'] = '-- Please Select --'; while($userlink = mysql_fetch_assoc($query)) { $user_sites[$userlink['sid']] = $place_list[$userlink['sid']]; } //Form $output .= form_select(t('Centre'), 'centre', $employment['centre'], $place_list, '', 0, '', ''); $output .= form_textarea(t('Details'), 'details', $employment['details'], 25, 100, '', '', ''); $output .= form_textfield(t('Salary'), 'salery', $employment['salery'], 25, 255, '', '', ''); $output .= form_item(t('Closing Date'), _employment_date('closing_date', $employment['closing_date']), '', '', ''); $contact_group1 = form_textfield(t('Name'), 'contact_name', $employment['contact_name'], 25, 255, '', '', ''); $contact_group1 .= form_textfield(t('Email'), 'contact_email', $employment['contact_email'], 25, 255, '', '', ''); $contact_group1 .= form_textfield(t('Postal Address Line 1'), 'contact_address1', $employment['contact_address1'], 25, 255, '', ''); $contact_group1 .= form_textfield(t('Postal Address Line 2'), 'contact_address2', $employment['contact_address2'], 25, 255, '', ''); $contact_group1 .= form_textfield(t('Postal Address Line 3'), 'contact_address3', $employment['contact_address3'], 25, 255, '', ''); $contact_group2 = form_select(t('Name'), 'enquirie_name', $employment['enquirie_name'], $user_list, '', 0, '', ''); $contact_group = form_group(t('Send applications to'), $contact_group1, ''); $contact_group .= form_group(t('Enquiries to'), $contact_group2, ''); //Check Box Options $web_options = array('Staff News' => 'Staff News', 'Public website' => 'Public website (victoria.ymca.org.au)', 'YNet' => 'YNet', 'My Career' => 'My Career (mycareer.com.au)', 'Seek' => 'Seek (seek.com.au)', 'Other' => 'Other'); $print_options = array('The Age Wednesday' => 'The Age . Wednesday', 'The Age Saturday' => 'The Age . Saturday', 'Herald Sun' => 'Herald Sun', 'Local Paper' => 'Local Paper'); $advertising_group = form_checkboxes(t('Web'), 'web', $employment['web'], $web_options, '', '', ''); $advertising_group .= form_textfield(t('Other'), 'web_other', $employment['web_other'], 25, 255, 'If other is selected', '', ''); $advertising_group .= form_checkboxes(t('Print'), 'print', $employment['print'], $print_options, '', '', ''); $advertising_group .= form_textfield(t('Local Paper'), 'print_local', $employment['print_local'], 25, 255, 'If local paper is selected', '', ''); $advertising_group .= form_item(t('Find your local Leader'),'http://www.community.newsmedianet.com.au/home/groups/group/index.jsp?groupid=2'); $advertising_group .= form_select(t('Invoice to'), 'invoice', $employment['invoice'], $user_sites, '', '', ''); $output .= form_group(t('Contact'), $contact_group, ''); $output .= form_group(t('Advertising'), $advertising_group, ''); return $output; }