function new_bag_transaction_date($clientid, $date) { $client = get_family_by_id($clientid); $s = q("insert into transaction values('', '" . clean_query($clientid) . "', '" . clean_query($client['delivery']) . "', '" . clean_query($date) . "');"); if (a() == 0) { return false; } $id = i(); $sources = get_all_bag_food_sources($client['bagid']); foreach ($sources as $source) { $s = q("insert into transaction_to_food_source values('" . $id . "', '" . $source['sourceid'] . "', '" . $source['weight'] . "', '" . $source['price'] . "');"); } if (a() == 0) { $s = q("delete from transaction where transaction.transactionid = '" . clean_query($id) . "' limit 1;"); return false; } return true; }
function render_edit($clientid) { global $client_framework_render; global $parameters; foreach ($parameters as $parameter) { global ${$parameter}; } $family = get_family_by_id($clientid); $content = ''; $bag_list = ''; $bags = get_all_bags(); foreach ($bags as $bag) { $bag_list .= "<option value='" . $bag['bagid'] . "'" . ($bag['bagid'] == $family['bagid'] ? ' selected' : '') . ">" . $bag['name'] . "</option>"; } $toggle = true; $rows = ''; $client_edit_aid = new Template(); $client_edit_aid->load('client_edit_aid'); $aids = get_all_financial_aids_client($clientid); foreach ($aids as $aid) { $client_edit_aid_render['row'] = $toggle ? '1' : '2'; $client_edit_aid_render['name'] = $aid['name']; $client_edit_aid_render['field'] = clean_url($aid['name']); $client_edit_aid_render['checked'] = $aid['clientid'] > 0 ? ' checked="true"' : ''; $client_edit_aid_render['amount'] = $aid['amount']; $client_edit_aid->set_vars($client_edit_aid_render); $client_edit_aid->parse(); $rows .= $client_edit_aid->final; $toggle = !$toggle; } $client_edit = new Template(); $client_edit->load('client_edit'); $client_edit_render['id'] = $family['clientid']; $client_edit_render['bags'] = $bag_list; $client_edit_render['active'] = $family['active'] == '1' ? 'checked' : ''; $client_edit_render['first_name'] = $family['first_name']; $client_edit_render['last_name'] = $family['last_name']; $client_edit_render['male'] = $family['gender'] == '1' ? ' selected' : ''; $client_edit_render['female'] = $family['gender'] == '0' ? ' selected' : ''; $client_edit_render['address'] = $family['address']; $client_edit_render['telephone'] = $family['telephone']; $client_edit_render['dob'] = $family['dob']; $client_edit_render['fuel'] = $family['fuel_assistance'] ? ' checked' : ''; $client_edit_render['usda'] = $family['usda_assistance'] ? ' checked' : ''; $client_edit_render['delivery'] = $family['delivery'] ? ' checked' : ''; $client_edit_render['dietary'] = $family['dietary'] ? ' checked' : ''; $client_edit_render['second'] = $family['pickup_second'] ? ' checked' : ''; $client_edit_render['fourth'] = $family['pickup_fourth'] ? ' checked' : ''; $client_edit_render['cooking'] = $family['cooking_facilities'] ? ' checked' : ''; $client_edit_render['start'] = $family['start_date']; $client_edit_render['comments'] = $family['comments']; $client_edit_render['aids'] = $rows; $client_edit->set_vars($client_edit_render); $client_edit->parse(); $content .= $client_edit->final; $client_framework_render['content'] = $content; render_all(); }
function render_usda_sheet($mode) { global $reporting_framework_render; global $parameters; foreach ($parameters as $parameter) { global ${$parameter}; } $content = ""; // Get transactions of last month $start_date = date('Y-m-d', mktime(0, 0, 0, date('m') - 1, date('d'), date('Y'))); $end_date = date('Y-m-d', mktime(0, 0, 0, date('m'), date('d'), date('Y'))); $aids = get_all_aids(); $num_aids = 0; $aid_columns = ""; foreach ($aids as $aid) { if ($aid['usda_qualifier'] == '1') { $aid_columns .= "<th style=\"vertical-align: bottom;\">" . $aid['name'] . "</th>"; $num_aids++; } } $reporting_list = new Template(); $reporting_list->load('report_usda_list'); $reporting_list_render['num_aids'] = $num_aids; $reporting_list_render['aid_columns'] = $aid_columns; $reporting_list_render['clients'] = ''; $report_row = new Template(); $report_row->load('report_usda_row'); $report_row_render['name'] = ''; $report_row_render['address'] = ''; $report_row_render['size'] = ''; $report_row_render['client_aids'] = ''; if ($mode == "active") { $clients = get_active_families(); } else { $clients = get_all_client_transactions($start_date, $end_date); } if ($clients != null) { foreach ($clients as $client) { $fam = get_family_by_id($client['clientid']); $report_row_render['id'] = $fam['clientid']; $report_row_render['name'] = $fam['last_name'] . ", " . $fam['first_name']; $report_row_render['address'] = $client['address']; $report_row_render['size'] = count(get_all_family_members($client['clientid'])) + 1; $report_row_render['fuel'] = $fam['fuel_assistance'] == '1' ? "Yes" : "No"; //$report_row_render['sig'] = $fam['usda_assistance'] == '1' ? "Yes" : "No"; $report_row_render['sig'] = ""; // Get and Render Client Aids $report_row_render['client_aids'] = ''; $aids = get_family_usda_aids($client['clientid']); foreach ($aids as $aid) { $report_row_render['client_aids'] .= "<td>" . ($aid['amount'] == NULL ? "No" : "Yes") . "</td>"; } $report_row->set_vars($report_row_render); $report_row->parse(); $content .= $report_row->final; } } $reporting_list_render['clients'] = $content; $reporting_list->set_vars($reporting_list_render); $reporting_list->parse(); $reporting_framework_render['content'] = $reporting_list->final; render_all(); }