Changeset 485 for trunk/phpbms/modules/bms/invoices_notes.php
- Timestamp:
- 04/07/09 11:44:18 (3 years ago)
- Files:
-
- 1 modified
-
trunk/phpbms/modules/bms/invoices_notes.php (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/phpbms/modules/bms/invoices_notes.php
r285 r485 1 <?php 1 <?php 2 2 /* 3 3 $Rev$ | $LastChangedBy$ … … 39 39 40 40 include("../../include/session.php"); 41 41 42 42 43 43 require_once("../../include/search_class.php"); 44 44 45 45 46 46 //set the table passing stuff … … 53 53 54 54 $refquery="SELECT 55 invoices.id, if(clients.lastname!=\"\",concat(clients.lastname,\", \",clients.firstname,if(clients.company!=\"\",concat(\" (\",clients.company,\")\"),\"\")),clients.company) as name 56 FROM invoices INNER JOIN clients ON invoices.clientid=clients.id 55 invoices.id, if(clients.lastname!=\"\",concat(clients.lastname,\", \",clients.firstname,if(clients.company!=\"\",concat(\" (\",clients.company,\")\"),\"\")),clients.company) as name 56 FROM invoices INNER JOIN clients ON invoices.clientid=clients.id 57 57 WHERE invoices.id=".$refid; 58 58 $refquery=$db->query($refquery); 59 $refrecord=$db->fetchArray($refquery); 60 61 $pageTitle="Notes/Tasks/Events: ".$refrecord["id"].", ".$refrecord["name"]; 59 $refrecord=$db->fetchArray($refquery); 60 61 $pageTitle="Notes/Tasks/Events: ".$refrecord["id"]; 62 if($refrecord["name"] !== "") 63 $pageTitle .= ", ".$refrecord["name"]; 62 64 63 65 $tabgroup="invoices entry"; 64 66 $selectedtabid=18; 65 67 66 68 include("../base/notes_records.php"); 67 69 //=================================================================================== 68 70 //== THAT's IT == 69 71 //=================================================================================== 70 72 71 73 ?>
