<tr> <td>Production:</td> <td>'; if ($countProduction > 0) { $appointments_table .= '<a href="appointment_search.php?stage=1&action=advanced_search&keyword=^' . $dea_id . '&type=Production&searchLink=' . $_SERVER['SCRIPT_NAME'] . urlencode('?' . replaceQueryString($_SERVER['QUERY_STRING'], 'viewForm') . '&viewForm=5') . '">' . $countProduction . '</a>'; } else { $appointments_table .= "0"; } $appointments_table .= '</td> <td><a href="production_add.php?stage=vendor&dea_id=' . $dea_id . '">[ New ]</a></td> </tr> <tr> <td>Inspections:</td> <td>'; if ($countInspection > 0) { $appointments_table .= '<a href="appointment_search.php?stage=1&action=advanced_search&keyword=^' . $dea_id . '&type=Inspection&searchLink=' . $_SERVER['SCRIPT_NAME'] . urlencode('?' . replaceQueryString($_SERVER['QUERY_STRING'], 'viewForm') . '&viewForm=5') . '">' . $countInspection . '</a>'; } else { $appointments_table .= "0"; } $appointments_table .= '</td> <td><a href="inspection_add.php?dea_id=' . $dea_id . '">[ New ]</a></td> </tr> </table> <table id="detailTable" width="50%" style="margin-left:10px"> <tr> <td>' . $dea_hits . '</td> </tr> </table>'; // build data arrays for editable tabs // summary page, no array /*
function renderNotes($not_type, $not_row, $options = array()) { if ($options["label"]) { $label = $options["label"]; } else { $label = 'Notes'; } if ($options["order"] == "ASC") { $order = $options["order"]; } else { $order = 'DESC'; } $querystring = $_SERVER['QUERY_STRING']; if ($options["viewform"]) { $querystring = replaceQueryString($querystring, 'viewForm'); $querystring .= '&viewForm=' . $options["viewform"]; } $return = $_SERVER['PHP_SELF'] . urlencode('?' . $querystring); $_sql = "SELECT note.*,\n\tDATE_FORMAT(note.not_edited,'%d/%m/%y') AS date,\n\tCONCAT(use_fname,' ',use_sname) AS use_name\n\tFROM note,user\n\tWHERE not_type = '{$not_type}' AND not_row = {$not_row} AND not_user = user.use_id\n\tORDER BY not_status, not_edited {$order} "; $_result = mysql_query($_sql); $numRows = mysql_num_rows($_result); if (!$_result) { die("MySQL Error: " . mysql_error() . "<pre>db_query: " . $_sql . "</pre>"); } while ($row = mysql_fetch_array($_result)) { if ($row["not_status"] == 'Deleted') { $class = 'note_deleted'; } else { $class = 'note'; } // wrap each note in a div for mouseover highlight if ($options["layout"] == "readonly") { $notes .= '<div class="noteOff" onMouseOver="this.className=\'noteOn\';" onMouseOut="this.className=\'noteOff\';">'; $notes .= ' <div class="noteInfo"><img src="/images/sys/admin/icons/note.gif" />' . $row["use_name"] . ' ' . $row["date"] . '</div> <div class="' . $class . '">' . nl2br($row["not_blurb"]) . '</div> '; } elseif ($options["layout"] == "simple") { $notes .= '<div class="noteOff" onMouseOver="this.className=\'noteOn\';" onMouseOut="this.className=\'noteOff\';">'; $notes .= ' <div class="' . $class . '">' . nl2br($row["not_blurb"]) . '</div> '; } else { $notes .= '<div class="noteOff" onMouseOver="this.className=\'noteOn\';" onMouseOut="this.className=\'noteOff\';" onClick="document.location.href = \'note.php?not_id=' . $row["not_id"] . '&return=' . $return . '\'">'; $notes .= ' <div class="noteInfo"><a href="note.php?not_id=' . $row["not_id"] . '&return=' . $return . '"><img src="/images/sys/admin/icons/note.gif" />' . $row["use_name"] . ' edited: ' . $row["date"] . '</a></div> <div class="' . $class . '">' . nl2br($row["not_blurb"]) . '</div> '; } $notes .= '</div>'; } if ($notes) { if ($numRows > 0) { $numRows = ' (' . $numRows . ')'; } $notes = ' <div class="noteLabel">' . $label . $numRows . '</div> <div class="noteWrapper">' . $notes . '</div> '; } return $notes; }
$numRows = $q->numRows(); while ($row = $q->fetchRow()) { if ($row["use_colour"]) { $use_colour = '<span class="use_col" style="background-color: #' . $row["use_colour"] . ';"><img src="/images/sys/admin/blank.gif" width="10" height="10" alt="' . $row["use_name"] . '"></span> '; } else { // unnassigned $use_colour = '<span class="use_col" style="background-color: #FFFFFF;"><img src="/images/sys/admin/blank.gif" width="10" height="10" alt="' . $row["use_name"] . '"></span> '; } $use_name = $use_colour . $row["use_initial"]; $appointments .= ' <tr> <td width="15%" valign="top">' . $row["app_date"] . '</td> <td valign="top"><strong>' . $row["pro_addr"] . '</strong></td> <td width="10%" valign="top">' . $use_name . '</td> <td width="5%" align="right" valign="top"> <a href="appointment_edit.php?app_id=' . $row["app_id"] . '&searchLink=' . $_SERVER['SCRIPT_NAME'] . urlencode('?' . replaceQueryString($_SERVER['QUERY_STRING'], 'viewForm') . '&viewForm=0') . '"><img src="/images/sys/admin/icons/edit-icon.png" width="16" height="16" border="0" alt="View/Edit Appointment"/></a> </td> </tr>'; } if ($appointments) { $render_summary .= ' <hr /> <table cellpadding="2" cellspacing="2" border="0" width="95%" align="center"> <tr> <td><table width="100%">' . $appointments . '</table></td> </tr> </table>'; } #overwrite database values with POST values (probably empty) foreach ($_POST as $key => $val) {
$terms["cli_email"] = trim($_GET["cli_email"]); } $sql_2 = $sql; $sql = ''; # build data arrays $formData1 = array('cli_salutation' => array('type' => 'select', 'group' => 'Full Name', 'label' => 'Salutation', 'value' => $cli_salutation, 'required' => 2, 'options' => db_enum("client", "cli_salutation", "array"), 'attributes' => array('style' => 'width:60px')), 'cli_fname' => array('type' => 'text', 'group' => 'Full Name', 'label' => 'Forename', 'value' => $cli_fname, 'init' => 'Forename(s)', 'required' => 2, 'attributes' => array('style' => 'width:100px', 'onFocus' => 'javascript:clearField(this,\'Forename(s)\')'), 'function' => 'format_name'), 'cli_sname' => array('type' => 'text', 'group' => 'Full Name', 'last_in_group' => 1, 'label' => 'Surname', 'value' => $cli_sname, 'init' => 'Surname', 'required' => 2, 'attributes' => array('style' => 'width:152px', 'onFocus' => 'javascript:clearField(this,\'Surname\')'), 'function' => 'format_name'), 'cli_tel' => array('type' => 'tel', 'label' => 'Telephone 1', 'required' => 2, 'value' => $_GET["telnew"]), 'cli_email' => array('type' => 'text', 'label' => 'Email', 'value' => $cli_email, 'required' => 3, 'attributes' => array('style' => 'width:320px', 'maxlength' => 255)), 'cli_preferred' => array('type' => 'radio', 'label' => 'Preferred Contact', 'value' => $cli_preferred, 'required' => 2, 'options' => db_enum("client", "cli_preferred", "array"))); // we will only have a pro_pro_id in the GET when returning from error message // so build a form that is read-only populated with the data, and give button to change, which shows ajax screen again if ($_GET["pro_pro_id"]) { $sqlP = "SELECT * FROM property WHERE pro_id = " . $_GET["pro_pro_id"] . " LIMIT 1"; $qP = $db->query($sqlP); if (DB::isError($qP)) { die("db error: " . $q->getMessage() . "sqlP<br>" . $sqlP); } while ($row = $qP->fetchRow()) { $formData2 = array('pro_pro_id' => array('type' => 'hidden', 'value' => $row["pro_id"]), 'pro_pcid' => array('type' => 'hidden', 'value' => $row["pro_pcid"]), 'pro_addr1' => array('type' => 'text', 'label' => 'House Number', 'value' => $row["pro_addr1"], 'required' => 1, 'attributes' => array('class' => 'addr', 'readonly' => 'readonly'), 'function' => 'format_street'), 'pro_addr2' => array('type' => 'text', 'label' => 'Building Name', 'value' => $row["pro_addr2"], 'required' => 1, 'attributes' => array('class' => 'addr', 'readonly' => 'readonly'), 'function' => 'format_street'), 'pro_addr3' => array('type' => 'text', 'label' => 'Street', 'value' => $row["pro_addr3"], 'required' => 1, 'attributes' => array('class' => 'addr', 'readonly' => 'readonly'), 'function' => 'format_street'), 'pro_addr5' => array('type' => 'text', 'label' => 'City or County', 'value' => $row["pro_addr5"], 'required' => 1, 'attributes' => array('class' => 'addr', 'readonly' => 'readonly'), 'function' => 'format_street'), 'pro_postcode' => array('type' => 'text', 'label' => 'Postcode', 'value' => $row["pro_postcode"], 'required' => 1, 'attributes' => array('class' => 'pc', 'maxlength' => 9, 'readonly' => 'readonly'), 'function' => 'format_postcode', 'group' => 'Postcode'), 'pro_postcode_change' => array('type' => 'button', 'label' => 'Postcode', 'value' => 'Change Address', 'group' => 'Postcode', 'attributes' => array('class' => 'button', 'onClick' => 'javascript:document.location.href = \'' . $_SERVER['SCRIPT_NAME'] . '?' . replaceQueryString($_SERVER['QUERY_STRING'], 'pro_pro_id') . '\';'), 'last_in_group' => 1)); } // manually inputted address } else { $formData2 = array('pro_addr1' => array('type' => 'text', 'label' => 'House Number', 'value' => $pro_addr1, 'required' => 2, 'attributes' => array('class' => 'addr'), 'function' => 'format_street'), 'pro_addr2' => array('type' => 'text', 'label' => 'Building Name', 'value' => $pro_addr2, 'required' => 1, 'attributes' => array('class' => 'addr'), 'function' => 'format_street'), 'pro_addr3' => array('type' => 'text', 'label' => 'Street', 'value' => $pro_addr3, 'required' => 2, 'attributes' => array('class' => 'addr'), 'function' => 'format_street'), 'pro_addr4' => array('type' => 'text', 'label' => 'Town or Area', 'value' => $pro_addr4, 'required' => 3, 'attributes' => array('class' => 'addr'), 'function' => 'format_street'), 'pro_addr5' => array('type' => 'text', 'label' => 'City or County', 'value' => $pro_addr5, 'required' => 2, 'attributes' => array('class' => 'addr'), 'function' => 'format_street'), 'pro_postcode' => array('type' => 'text', 'label' => 'Postcode', 'value' => $pro_postcode, 'required' => 2, 'attributes' => array('class' => 'pc', 'maxlength' => 9), 'function' => 'format_postcode'), 'pro_country' => array('type' => 'select', 'label' => 'Country', 'value' => $pro_country, 'required' => 2, 'options' => db_lookup("cli_country", "country", "array"), 'attributes' => array('class' => 'addr'))); } if (!$_POST["action"]) { $sql_1 = remove_lastchar(trim($sql_1), "OR"); $sql_2 = remove_lastchar(trim($sql_2), "OR"); if (!$_GET["return"]) { $return = $_SERVER['SCRIPT_NAME'] . '?' . http_build_query(array('cli_name' => $_GET["cli_name"], 'cli_email' => $_GET["cli_email"], 'dest' => $_GET["dest"], 'dea_id' => $_GET["dea_id"])); } else { $return = $_GET["return"]; } if ($sql_1) { // first, match both first AND surnames and put at top of list
// cancelled overwrites above feedback text if ($row["app_status"] == 'Cancelled') { $feedback = '(cancelled)'; } if ($row["use_colour"]) { $use_colour = '<span class="use_col" style="background-color: #' . $row["use_colour"] . ';"><img src="' . GLOBAL_URL . 'img/blank.gif" width="10" height="10" alt="' . $row["use_name"] . '"></span> '; } $use_name = $use_colour . $row["use_initial"]; $viewings_table .= ' <tr> <td width="13%" valign="top">' . $row["app_date"] . '</td> <td width="10%" valign="top">' . $use_name . '</td> <td width="57%" valign="top">' . $row["pro_addr"] . '</td> <td width="15%" valign="top">' . $feedback . '</td> <td width="5%" align="right" valign="top"> <a href="appointment_edit.php?app_id=' . $row["app_id"] . '&searchLink=' . $_SERVER['PHP_SELF'] . urlencode('?' . replaceQueryString($_SERVER['QUERY_STRING'], 'viewForm') . '&viewForm=3.1') . '"><img src="' . GLOBAL_URL . '/img/icons/page_edit.gif" width="16" height="16" border="0" alt="View/Edit Appointment"/></a> </td> </tr>'; } } $appointments_table = ' <div style="width:97%;height:210px;overflow:auto;margin-left:10px"> <table id="detailTable" width="97%" cellpadding="2" cellspacing="2" align="center"> <tr> <th>Date</th> <th>Neg</th> <th>Property</th> <th colspan="2">Feedback</th> </tr> ' . $viewings_table . ' </table>';
//$special_background = ' background-image:url(img/anibg.gif)'; $div['colour'] = 'FFFFFF'; } else { //$special_background = ''; } // private appointments are only visible to bookedby //if ($div['private'] == 'Yes' && $_SESSION['auth']['use_id'] <> $div['bookedby']) { // } else { // variable style values from database, rest is in css class if ($div['DIT']) { $class .= ' DIT-property'; } $render .= ' <div id="app' . $div['id'] . '" class="' . $class . '" style="position: absolute; height: ' . $app_height . 'px; left: ' . $left . 'px; top:' . $div['start_pixel'] . 'px; width:' . ($width - 18) . 'px; border: 1px solid #' . $div['colour'] . '; border-left: 10px solid #' . $div['colour'] . '; z-index:1; overflow: hidden;' . $special_background . '" '; // href targetted at parent of parent. remove hightlight var from querystring // parent.parent.frames[\'mainFrame\'].window.location.href= $render .= 'onClick="javascript:parent.window.location.href=\'' . GLOBAL_URL . 'appointment_edit.php?app_id=' . $div['id'] . '&searchLink=calendar.php?' . urlencode(replaceQueryString($_SERVER['QUERY_STRING'], 'app_highlight')) . '\'" '; // js actions $render .= 'onMouseOver="' . $div_mouseover . '" onMouseOut="' . $div_mouseout . '" onMouseDown="nd();">' . "\n"; // text displayed within appointment $render .= $title . "\n" . ' </div>' . "\n"; // } } // the current appointment ends in this interval if ($div['end_stamp'] >= $interval && $div['end_stamp'] < $interval + $default_calendar_interval) { // remove column reference from master array unset($divs[$div_id]['column']); } } } unset($left, $column); $counter++;
function source($_source = NULL, $_querystring) { // if a source is supplied, don't show the muti drop downs. if ($_source) { $ref = '?' . replaceQueryString($_querystring, 'cli_source'); $sql = "SELECT sou_id,sou_title,sou_type FROM source WHERE sou_id = {$_source} LIMIT 1"; $_result = mysql_query($sql); if (!$_result) { die("MySQL Error: " . mysql_error() . "<pre>source: " . $sql . "</pre>"); } while ($row = mysql_fetch_array($_result)) { $output['dd1'] = '<input type="text" readonly="readonly" value="' . $row["sou_title"] . ' (' . $row["sou_type"] . ')" class="inputInvisible">' . "\n"; $output['dd1'] .= '<input type="button" value="Change" class="button" onClick="javascript:document.location.href=\'' . $ref . '\';">' . "\n"; $output['dd1'] .= '<input type="hidden" name="cli_source" value="' . $row["sou_id"] . '">'; } } else { // only add onload statement if source is not specified $output['onload'] = 'init(document.forms[0].cli_source)'; // get source types to populate javascript drop downs $sql = "SELECT sou_id,sou_title,sou_type FROM source ORDER BY sou_title"; $_result = mysql_query($sql); if (!$_result) { die("MySQL Error: " . mysql_error() . "<pre>source: " . $sql . "</pre>"); } while ($row = mysql_fetch_array($_result)) { if (!$row["sou_type"]) { $render_source .= '<option value="' . $row["sou_id"] . '"'; if ($cli_source1 == $row["sou_id"]) { $render_source .= ' selected'; } $render_source .= '>' . $row["sou_title"] . '</option>' . "\n"; // array of types to loop through later $types[] = $row["sou_id"]; } else { ${'_js' . $row["sou_type"]} .= "'" . $row["sou_title"] . "','" . $row["sou_id"] . "',"; } /*~ elseif ($row["sou_type"] == "Portal") { $_js1 .= "'".$row["sou_title"]."','".$row["sou_id"]."',"; } elseif ($row["sou_type"] == "Press") { $_js2 .= "'".$row["sou_title"]."','".$row["sou_id"]."',"; } elseif ($row["sou_type"] == "Search Engine") { $_js3 .= "'".$row["sou_title"]."','".$row["sou_id"]."',"; } elseif ($row["sou_type"] == "Referral") { $_js4 .= "'".$row["sou_title"]."','".$row["sou_id"]."',"; }*/ } // create master type drop down $output['dd1'] = '<select name="cli_source1" style="width:200px" onchange="populate(document.forms[0].cli_source1,document.forms[0].cli_source)">' . "\n"; $output['dd1'] .= '<option value="0">(click here)</option>' . "\n"; $output['dd1'] .= $render_source; $output['dd1'] .= '</select>' . "\n"; $output['dd2'] = '<select name="cli_source" style="width:200px;display:none;">' . "\n"; $output['dd2'] .= '<option></option>' . "\n"; $output['dd2'] .= '</select>' . "\n"; // format javascript arrays (add "other" option to each?) foreach ($types as $type) { if (${'_js' . $type}) { ${'_js' . $type} = "'(select)',''," . remove_lastchar(${'_js' . $type}, ","); $render_js .= 'thelist[' . $type . '] = new Array(' . ${'_js' . $type} . ');' . "\n"; } } $output['js'] = ' var thelist = new Array(); thelist[0] = new Array(); ' . $render_js . ' function init(dd1) { optionTest = true; lgth = dd1.options.length; dd1.options[lgth] = null; if (dd1.options[lgth]) optionTest = false; } // dd1 is the first drop down, dd2 is the second function populate(dd1,dd2) { if (!optionTest) return; dd2.style.display = ""; /* dd1.style.display = "none"; */ var box = dd1; var number = box.options[box.selectedIndex].value; if (!number) return; var list = thelist[number]; var box2 = dd2; box2.options.length = 0; for(i=0;i<list.length;i+=2) { box2.options[i/2] = new Option(list[i],list[i+1]); } dd2.focus(); } '; } return $output; }
$width = round(100 / $perRow); $allDayDivHeight = ceil($numRowsAllDay / $perRow) * $allDayDivHeight; $alldayapps = '<table width="100%"><tr>'; while ($row = $q->fetchRow()) { // trim subject if (strlen($row["app_subject"]) > 25) { $subject = substr($row["app_subject"], 0, 25) . "..."; } else { $subject = $row["app_subject"]; } // variable style values from database, rest is in css class $alldayapps .= '<td style="white-space: nowrap;width:' . $width . '%;border:1px solid #' . $row["use_colour"] . ';border-left: 10px solid #' . $row["use_colour"] . ';background-color: #FFFFFF; cursor:pointer; font-size:9px; overflow: hidden;" '; //<div style="width:300px;border:1px solid #'.$row["use_colour"].';display:block;" '; display:inline; margin: 2px; border: 1px solid #'.$row["use_colour"].'; // href targetted at parent of parent. remove hightlight var from querystring // parent.parent.frames[\'mainFrame\'].window.location.href= $alldayapps .= 'onClick="javascript:window.location.href=\'appointment_edit.php?app_id=' . $row["app_id"] . '&searchLink=calendar.php?' . urlencode(replaceQueryString($_SERVER['QUERY_STRING'], 'app_highlight')) . '\'" '; // js actions $alldayapps .= 'onMouseOver="return overlib(\'' . $row["app_subject"] . '<br />' . format_overdiv($row["note"]) . '<br /><br />' . $row["use_name"] . '\',CAPTION,\'' . $row["app_type"] . '\');" onMouseOut="nd();" onMouseDown="nd();"'; // text displayed within appointment $alldayapps .= '>' . $subject . '</td>' . "\n"; //' - '.$row["use_name"]. if ($counter % $perRow == 0) { $alldayapps .= ' </tr> <tr>'; } $counter++; } $alldayapps .= '</tr></table>'; } if ($alldayapps) {
<p> <a href="http://angeles-print/condorwiki/" title="Get help on Condor">Wiki</a> | <a href="../rrdtool/" title="Visualize pool usage" target="main">Usage</a> <?php if (isset($_REQUEST['admin']) && !empty($_REQUEST['admin'])) { ?> | <a href="index.php?<?php echo replaceQueryString("admin", ""); ?> " target="_top" title="Toggle to simple mode">Simple</a> <?php } else { ?> | <a href="index.php?<?php echo replaceQueryString("admin", "1"); ?> " target="_top" title="Toggle to advanced mode">Advanced</a> <?php } ?> </p> <hr> <p> <a href="condor_status.php?value=" target="main">condor_status</a> <ul> <li><a href="command.php?command=condor_status -submitters" target="main">-submitters</a></li> <li><a href="command.php?command=condor_status -schedd" target="main">-schedd</a></li> <li><a href="command.php?command=condor_status -master" target="main">-master</a></li>
$next = "»"; } else { $next = $links['next']; } if (!$links['last']) { $last = "»"; } else { $last = $links['last']; } if ($n_pages) { $results .= '<div id="loading"><h1 style="padding-left: 20px;"><img src="/images/sys/admin/ajax-loader.gif" /> Loading</h1></div>'; for ($i = 1; $i <= $n_pages; ++$i) { $pageNum = $i; $results .= '<div class="page" id="page' . $pageNum . '" style="display: none">'; $nav[$pageNum] = str_replace(array('<b><u>1</u></b>', '>' . $pageNum . '</a>', " ", "page"), array('<a href="javascript:showResultPage(1)" title="page 1">1</a>', '><b>' . $pageNum . '</b></a>', " ", "Page"), $links["pages"]); $return = 'property_search.php?' . replaceQueryString($_SERVER['QUERY_STRING'], 'action'); $results .= ' <div id="header"> <table> <tr> <td>' . $numRows . ' records found'; if ($nav[$pageNum]) { $results .= ' - Page: ' . $nav[$pageNum]; } $results .= '</td> </tr> </table> </div> ';
</form>'; */ //$links is an ordered+associative array with 'back'/'pages'/'next'/'first'/'last'/'all' links. //(page '.$pager->getCurrentPageID().' of '.$pager->numPages().') if (!$links['back']) { $back = "«"; } else { $back = $links['back']; } if (!$links['next']) { $next = "»"; } else { $next = $links['next']; } if ($pager->numItems()) { $return = 'appointment_search.php?' . replaceQueryString($_SERVER['QUERY_STRING'], 'action'); $header = ' <div id="header"> <table> <tr> <td>' . $pager->numItems() . ' records found'; if ($pager->numPages() > 1) { $header .= ' - Page: ' . $back . ' ' . str_replace(" ", " ", $links['pages']) . ' ' . $next . ''; } $header .= '</td> <td align="right"><a href="' . $return . '">Modify Search</a> / <a href="appointment_search.php">New Search</a></td> </tr> </table> </div> '; $results = '
$page->addBodyContent('<div id="content">'); $page->addBodyContent($navbar); $page->addBodyContent($form->renderForm()); $page->addBodyContent('</div>'); $page->display(); exit; } else { if ($_POST["med_measurement"] == "feet") { $_POST["med_dims"] = ft2mtr($_POST["med_dims"]); } unset($_POST["med_measurement"]); $result = new Validate(); $results = $result->process($formData, $_POST); $db_data = $results['Results']; if ($results['Errors']) { if (is_array($results['Results'])) { $return .= http_build_query($results['Results']); } echo error_message($results['Errors'], urlencode($return)); exit; } $med_id = db_query($db_data, "UPDATE", "media", "med_id", $med_id); #header("Location:".urldecode($_POST["searchLink"])); if ($_POST["searchLink"]) { $tmpurl = $_POST["searchLink"]; } else { $tmpurl = $_GET["searchLink"]; } header("Location:" . replaceQueryString(urldecode($tmpurl), 'viewForm') . '&viewForm=' . $viewForm); exit; }
function columnHeader($column_headers, $query_string) { global $global_url; /* order by requires two variables, the field name and direction. to make querystring we ned to remove both varbailes from the given query string and replace them with new values. */ # get existing values (orderby and direction) or set defaults parse_str($query_string, $qs); // order by first column in array if (!$qs['orderby']) { $orderby = $column_headers[0]['column']; } else { $orderby = $qs['orderby']; } if (!$qs['direction']) { $direction = "ASC"; } else { $direction = $qs['direction']; } # remove values from querystring $query_string = replaceQueryString($query_string, '&orderby'); $query_string = replaceQueryString($query_string, '&direction'); /* if current direction is ASC, we need to show icon and link to DESC, and visa-versa only show the icons on the column we are sorting on */ foreach ($column_headers as $column_title => $column_params) { # $column_params['title'] # $column_params['column'] # $column_params['direction'] // default direction if (!$column_params['direction']) { $column_params['direction'] = "ASC"; } if ($column_params['column']) { if ($direction == "ASC") { $column_direction = "DESC"; $direction_image = '<img src="/images/sys/admin/asc.gif" width="16" height="16" border="0" align="absmiddle">'; } else { $column_direction = "ASC"; $direction_image = '<img src="/images/sys/admin/desc.gif" width="16" height="16" border="0" align="absmiddle">'; } $title = '<a href="?' . $query_string . '&orderby=' . $column_params['column'] . '&direction='; if ($orderby == $column_params['column']) { $title .= $column_direction; } else { $title .= 'ASC'; } $title .= '" title="Sort by ' . $column_params['title'] . '">' . $column_params['title'] . '</a>'; // only show image on column we are sorting by if ($orderby == $column_params['column']) { $title .= $direction_image; } $column_params['title'] = $title; } if ($column_params['colspan']) { $colspan = ' colspan="' . $column_params['colspan'] . '"'; } $columns .= '<th' . $colspan . '>' . $column_params['title'] . '</th> '; $colspan = ''; $column_links = ''; $direction_image = ''; $column_title = ''; $title = ''; } # end array loop return $columns; }
} else { $new_order[$comparison_key] = array('id' => $row["med_id"], 'title' => $row["med_title"]); } } } ksort($new_order); //print_r($new_order); //echo "<hr>"; $count = 1; foreach ($new_order as $key => $val) { $sql = "UPDATE media SET med_order = {$count} WHERE med_id = " . $val["id"]; $q = $db->query($sql); $count++; } //exit; header("Location:" . replaceQueryString(urldecode($_GET["return"]), 'viewForm') . '&viewForm=' . $viewForm); } elseif ($_GET["do"] == "feature_add") { $dea_id = $_GET["dea_id"]; $featureId = $_GET["featureId"]; $sql = "DELETE FROM link_instruction_to_feature WHERE dealId = {$dea_id} AND featureId = {$featureId}"; $q = $db->query($sql); $db_data["dealId"] = $dea_id; $db_data["featureId"] = $featureId; db_query($db_data, "INSERT", "link_instruction_to_feature", "f2d_id"); header("Location:" . $_GET["return"] . "&viewForm=" . str_replace('form', '', $_GET["viewForm"])); } elseif ($_GET["do"] == "feature_remove") { $dea_id = $_GET["dea_id"]; $featureId = $_GET["featureId"]; $sql = "DELETE FROM link_instruction_to_feature WHERE dealId = {$dea_id} AND featureId = {$featureId}"; $q = $db->query($sql); header("Location:" . $_GET["return"] . "&viewForm=" . str_replace('form', '', $_GET["viewForm"]));
function source($_source = NULL, $_querystring, $_readonly = NULL) { $otherText = '>> create new'; // if a source is supplied, don't show the muti drop downs. if ($_source && $_source != 'x') { $ref = '?' . replaceQueryString($_querystring, 'cli_source'); $sql = "SELECT \n\t\tsource.sou_id,source.sou_title,source.sou_type,source2.sou_title AS sou_title2 \n\t\tFROM source \n\t\tLEFT JOIN source AS source2 ON source2.sou_id = source.sou_type\n\t\tWHERE source.sou_id = {$_source} LIMIT 1"; $_result = mysql_query($sql); if (!$_result) { die("MySQL Error: " . mysql_error() . "<pre>source: " . $sql . "</pre>"); } while ($row = mysql_fetch_array($_result)) { $output['dd1'] = '<input type="text" readonly="readonly" value="' . $row["sou_title"] . ' (' . $row["sou_title2"] . ')" class="inputInvisible">' . "\n"; if (!$_readonly) { $output['dd1'] .= '<input type="button" value="Change" class="button" onClick="javascript:document.location.href=\'' . $ref . '\';">' . "\n"; } $output['dd1'] .= '<input type="hidden" name="cli_source" value="' . $row["sou_id"] . '">'; } } else { // only add onload statement if source is not specified $output['onload'] = 'init(document.forms[0].cli_source)'; // get source types to populate javascript drop downs $sql = "SELECT sou_id,sou_title,sou_type FROM source ORDER BY sou_title"; $_result = mysql_query($sql); if (!$_result) { die("MySQL Error: " . mysql_error() . "<pre>source: " . $sql . "</pre>"); } while ($row = mysql_fetch_array($_result)) { if ($row["sou_type"] == 0) { // types $render_source .= '<option value="' . $row["sou_id"] . '"'; if ($cli_source1 == $row["sou_id"]) { $render_source .= ' selected'; } $render_source .= '>' . $row["sou_title"] . '</option>' . "\n"; // array of types to loop through later $types[] = $row["sou_id"]; } else { // sub-types ${'_js' . $row["sou_type"]} .= "'" . $row["sou_title"] . "','" . $row["sou_id"] . "',"; } } // create master type drop down $output['dd1'] = '<select name="cli_source1" id="source1" onchange="populate(document.forms[0].cli_source1,document.forms[0].cli_source)">' . "\n"; $output['dd1'] .= '<option value="0"></option>' . "\n"; $output['dd1'] .= $render_source; $output['dd1'] .= '</select>' . "\n"; $output['dd2'] = '<select name="cli_source" id="source" style="width:200px" onChange="sourceOther(this);">' . "\n"; $output['dd2'] .= '<option></option>' . "\n"; $output['dd2'] .= '</select>' . "\n"; $output['dd2'] .= '<input type="text" name="sourceNew" id="sourceNew" style="display:none" />' . "\n"; // format javascript arrays (add "other" option to each?) foreach ($types as $type) { if (${'_js' . $type}) { ${'_js' . $type} .= "'{$otherText}','x',"; ${'_js' . $type} = "'(select)',''," . remove_lastchar(${'_js' . $type}, ","); $render_js .= 'thelist[' . $type . '] = new Array(' . ${'_js' . $type} . ');' . "\n"; } } $output['js'] = ' var thelist = new Array(); thelist[0] = new Array(); ' . $render_js . ' function init(dd1) { optionTest = true; lgth = dd1.options.length; dd1.options[lgth] = null; if (dd1.options[lgth]) optionTest = false; } // dd1 is the first drop down, dd2 is the second function populate(dd1,dd2) { if (!optionTest) return; var box = dd1; var number = box.options[box.selectedIndex].value; if (!number) return; var list = thelist[number]; var box2 = dd2; // make sure dd2 is visible if (box2.style.display == "none") { box2.style.display = ""; var sourceNew = document.getElementById(\'sourceNew\'); sourceNew.style.display = "none"; } box2.options.length = 0; for(i=0;i<list.length;i+=2) { box2.options[i/2] = new Option(list[i],list[i+1]); } dd2.focus(); } // replaced dd2 with text field and hidden field for type function sourceOther(selectedItem) { if (selectedItem.value == \'x\') { var source = document.getElementById(\'source\'); source.style.display = "none"; var sourceNew = document.getElementById(\'sourceNew\'); sourceNew.style.display = ""; sourceNew.focus(); } } '; } return $output; }