* GPL v2 or above * * Website: * http://www.simpleinvoices.org */ checkLogin(); $smarty->display("../templates/default/menu.tpl"); $smarty->display("../templates/default/main.tpl"); echo <<<EOD \t<div> \t<form action="index.php?module=customers&view=search" method="post"> \t<input type="text" name="name" /> \t<input type="submit" value="Search"> \t</form> EOD; $customers = searchCustomers($_POST['name']); echo "<table> <br />"; foreach ($customers as $customer) { echo <<<EOD \t\t \t\t<tr> \t\t\t<td>{$customer['name']} </td> \t\t\t<td><a href="index.php?module=invoices&view=itemised&customer_id={$customer['id']}">Itemised</a> |</td> \t\t\t<td><a href="index.php?module=invoices&view=consulting&customer_id={$customer['id']}"> Consulting</a> |</td> \t\t\t<td><a href="index.php?module=invoices&view=total&customer_id={$customer['id']}"> Total</a></td> \t\t</tr> EOD; } echo "</table></div>"; //getMenuStructure(); exit;
function printlistofCustomers($Terms, $AID) { $array = searchCustomers($Terms); $arrayN = count($array); $Viewable = getPermittedIndexV($AID); $Editable = getPermittedIndexE($AID); $EN = count($Editable); $VN = count($Viewable); echo "<div class='SearchResults'>"; echo "<table><tr>"; for ($v = 0; $v < $VN; $v++) { $v++; echo "<td>{$Viewable[$v]}</td>"; } for ($x = 0; $x < $arrayN; $x++) { $CusID = $array[$x]; $sql = "SELECT * FROM cusfields INNER JOIN cusindex ON cusfields.IndexID=cusindex.IDKey WHERE cusfields.CusID='{$array[$x]}'"; $result = mysqli_query($conn, $sql); while ($row = $result->fetch_assoc()) { $indexID = $row["IndexID"]; $view = 0; for ($x = 0; $x < $EN; $x++) { if ($indexID = $Editable[$x]) { $view = 2; $x = $EN; } } if ($view == 0) { for ($x = 0; $x < $VN; $x++) { if ($indexID = $Viewable[$x]) { $view = 1; $x = $VN; } } } if ($view > 0) { } } } echo "</div>"; }