addLocale("housekeeping.vouchers"); $data = new housekeeping_sql; $page['name'] = $lang->loc['pagename.vouchers']; $page['category'] = "tools"; require_once('./templates/housekeeping_header.php'); if(isset($_POST['search'])){ $sql = $data->select6($input->FilterText($_POST['query'])); $search_results = "\n"; $i = 0; while($row = $db->fetch_row($sql)){ if($input->IsEven($i)){ $even = "even"; }else{ $even = "odd"; } $search_results .= "\n"; $i++; } $search_results .= "
".$row[1]."".$row[0]."
"; }else{ $search_results = "\n
".$lang->loc['search.desc']."
"; } if(isset($_GET['do']) && $_GET['do'] == "save"){ $row = $_POST; $correct = $input->stringToURL($row['voucher'],false); if($row['type'] == "1"){ $row['type_s'] = "credits"; $selected[1] = ' selected="true"'; }else{ $row['type_s'] = "item"; $selected[0] = ' selected="true"'; } if(empty($row['voucher']) || strlen($row['voucher']) > 50 || $row['voucher'] != $correct){ $error = $lang->loc['error.invalid.voucher']."
"; } if($serverdb->num_rows($data->select10($row['voucher'])) > 0){ $error = $lang->loc['error.duplicate.voucher']."
"; } if(empty($row['value'])){ $error = $lang->loc['error.no.value']; } if(empty($error)){ if(!empty($row['id'])){ $data->update1($row['id'],$row['voucher'],$row['type_s'],$row['value']); $message = $lang->loc['message.voucher.modified']; }else{ $data->insert1($row['voucher'],$row['type_s'],$row['value']); $message = $lang->loc['message.voucher.created']; } unset($_POST); unset($_GET); }else{ $_GET['do'] = "create"; } }elseif($_GET['do'] == "remove"){ if(isset($_POST['id']) && isset($_POST['remove'])){ $data->delete1($input->FilterText($_POST['id'])); unset($_POST); unset($_GET); $message = $lang->loc['message.voucher.removed']; } } if((isset($_GET['id']) || isset($_POST['id'])) && empty($row)){ $sql = $data->select10($input->FilterText($_GET['id'])); $row = $serverdb->fetch_row($sql); $row['id'] = $row[0]; $row['voucher'] = $row[0]; $row['type'] = $row[1]; $row['value'] = $row[2]; if($row['type'] == "1"){ $selected[1] = ' selected="true"'; }else{ $selected[0] = ' selected="true"'; } }elseif(empty($row)){ if(!empty($_GET['furniid'])){ $selected[0] = ' selected="true"'; $row['value'] = $input->HoloText($_GET['furniid']); }else{ $selected[1] = ' selected="true"'; $row['value'] = "1000"; } } switch($_GET['do']){ case "create": $lang->addLocale("housekeeping.vouchers.create"); $icon = "vouchers_create.png"; $description = $lang->loc['vouchers.create.desc']; $content = ""; if(!empty($error)){ $content .= '
'.$error.'
'; } $content .= '
'; if(!empty($row['id'])){ $content .= ''; } $content .= '





'; break; case "remove": $lang->addLocale("housekeeping.vouchers.remove"); $icon = "vouchers_remove.png"; $description = $lang->loc['vouchers.remove.desc']; $content = '
'.$lang->loc['confirm.remove'].' "'.$input->HoloText($row['voucher']).'"?
'; break; default: $lang->addLocale("housekeeping.vouchers.display"); $icon = "vouchers.png"; $description = $lang->loc['vouchers.display.desc']; $content = ""; if(isset($message) && !empty($message)){ $content .= '
'.$message.'
'; } $content .= '
'; $sql = $data->select9(); $i = 0; while($row = $serverdb->fetch_row($sql)){ $i++; if($input->IsEven($i)){ $even = ' class="even"'; }else{ $even = ''; } $content .= ' '; } $content .= '
'.$lang->loc['type'].' '.$lang->loc['voucher'].' '.$lang->loc['data'].' '.$lang->loc['actions'].'
'.$row[1].' '.$row[0].' '.$row[2].' '.$lang->loc['edit'].''.$lang->loc['remove'].'
'; break; } ?>
loc['pagename.vouchers']; ?> loc['pagename.vouchers']; ?>