PHP Supplier::getSupplierList方法代码示例

 function showMachineUI()
 {
     $db = Database::getInstance();
     $cxn = $db->getConnection();
     $selc = '<option value="1">Yes</option><option value="0">No</option></select>';
     if ($this->machineid != '') {
         $q = "SELECT *,DATE_FORMAT(Install_Date,'%d-%m-%Y') as id FROM Machine WHERE Machine_ID={$this->machineid}";
         if (!($res = $cxn->query($q))) {
             exit("error (showMachineUI : {$q}) : {$cxn->error}");
         }
         $r = mysqli_fetch_assoc($res);
         $this->machinename = $r['Machine_Name'];
         $this->machineslno = $r['Machine_SLNO'];
         $this->ncserialno = $r['NC_Serial_NO'];
         $this->installdatedb = $r['Install_Date'];
         $this->installdate = $r['id'];
         $this->showinlogentry = $r['Show_In_Logentry'];
         $this->supplierid = $r['Supplier_ID'];
         $this->machinedesc = $r['Machine_Desc'];
         $this->spindletaper = $r['Spindle_Taper'];
         $this->atcsize = $r['ATC_Size'];
         $this->maxrpm = $r['Max_RPM'];
         $this->tablesize = $r['Table_Size'];
         $this->stroke = $r['Stroke'];
         $this->toolclampingforce = $r['Tool_Clamping_Force'];
         $this->torque = $r['Torque'];
         $this->typeid = $r['Type_ID'];
         if ($this->showinlogentry == 1) {
             $selc = '<option value="1" selected >Yes</option><option value="0">No</option></select>';
         } else {
             $selc = '<option value="1">Yes</option><option value="0" selected>No</option></select>';
         }
     }
     echo '<fieldset><legend>Machine Details</legend>';
     $any = new Anylist();
     $any->createList('Machine_Type');
     $supp = new Supplier();
     $supp->createSupplierList();
     $sel = new selectlist('Supplier_ID', $supp->getSupplierList(), 'Select Supplier', 'Supplier_ID', 'Supplier_Name', 'class="required"', $this->supplierid, '1');
     $sel2 = new selectlist('Type_ID', $any->anylist, 'Select Equipment Type', 'Type_ID', 'Type_Description', 'class="required"', $this->typeid, '1');
     echo '<p><label>Machine Name</label><input id="machinename" name="machinename" class="required" value="' . $this->machinename . '"></p>';
     echo '<p><label>Machine Description</label><input id="machinedesc" name="machinedesc" class="required" value="' . $this->machinedesc . '"></p>';
     echo '<p><label>Machine Serial Number</label><input id="machineslno" name="machineslno" value="' . $this->machineslno . '"></p>';
     echo '<p><label>NC Serial Number</label><input id="ncserialno" name="ncserialno" value="' . $this->ncserialno . '"></p>';
     echo '<p><label>Spindle Taper</label><input id="spindletaper" name="spindletaper" value="' . $this->spindletaper . '"></p>';
     echo '<p><label>ATC Size</label><input id="atcsize" name="atcsize" value="' . $this->atcsize . '"></p>';
     echo '<p><label>Maximum RPM</label><input id="maxrpm" name="maxrpm" value="' . $this->maxrpm . '"></p>';
     echo '<p><label>Table Size</label><input id="tablesize" name="tablesize" value="' . $this->tablesize . '"></p>';
     echo '<p><label>Axis Strokes</label><input id="stroke" name="stroke" value="' . $this->stroke . '"></p>';
     echo '<p><label>Tool Clamping force</label><input id="toolclampingforce" name="toolclampingforce" value="' . $this->toolclampingforce . '"></p>';
     echo '<p><label>Torque</label><input id="torque" name="torque" value="' . $this->torque . '"></p>';
     echo '<p><label>Date OF Installation</label><input id="installdate" name="installdate" value="' . $this->installdate . '"><input id="installdatedb" type="hidden" name="installdatedb" value="' . $this->installdatedb . '"></p>';
     echo '<p><label>Show Machine In Log Entry Page?</label><select id="showinlogentry" name="showinlogentry">' . $selc;
     echo '</fieldset>';
     echo '<input type="submit" class="submit" value="Save Machine Details">';
 }

     if (isset($_GET['bid'])) {
         $supp->setBrandID($_GET['bid']);
     }
     if (isset($_GET['scopeid'])) {
         $supp->setValue('scopeidl', $_GET['scopeid']);
     }
     if (isset($_GET['onlyapproved'])) {
         $supp->setValue('onlyapproved', $_GET['onlyapproved']);
     }
     if (isset($_GET['class'])) {
         $class = 'class="required"';
     } else {
         $class = '';
     }
     $supp->createSupplierList();
     $sel = new selectlist('Supplier_ID', $supp->getSupplierList(), 'Select Supplier', 'Supplier_ID', 'Supplier_Name', $class, '');
     break;
 case 'brand':
     $brand = new Brand();
     $brand->createBrandList();
     $sel = new selectlist('Brand_ID', $brand->getBrandList(), 'Select Brand', 'Brand_ID', 'Brand_Description', '', '');
     break;
 case 'ttype':
     $ttype = new TType();
     $ttype->createTypeList();
     if (isset($_GET['ttypeid'])) {
         $sid = $_GET['ttypeid'];
     } else {
         $sid = '';
     }
     $sel = new selectlist('Tool_Type_ID', $ttype->getTypeList(), 'Select Tool Type', 'Tool_Type_ID', 'Tool_Type', '', $sid);

 function showSpareInwardUI()
 {
     $supp = new Supplier();
     $supp->createSupplierList();
     echo '<fieldset><legend>Enter Spare Purcjase Details</legend>';
     $sel = new selectlist('Supplier_ID', $supp->getSupplierList(), 'Select Supplier', 'Supplier_ID', 'Supplier_Name', 'class="required"', '', '1');
     echo '<div id="poid"></div>';
     echo '<p><label>Enter Price</label><input id="price" name="price" class="required"></p>';
     echo '<p><label>Enter Quantity Purchased</label><input id="qty" name="qty" class="required"></p>';
     echo '<p><label>Date Received</label><input id="datereceived" name="datereceived" class="required"><input id="datereceiveddb" name="datereceiveddb" type="hidden"></p>';
     echo '<input type="button" id="receive" value="Save Quantity"> ';
 }