コード例 #1
0
    function showOpeToolBatchUI()
    {
        $db = Database::getInstance();
        $cxn = $db->getConnection();
        $q = "SELECT * From Ope_Tool_Batch WHERE Batch_ID={$this->batchid} AND Ope_Drawing_ID={$this->operevid}";
        if (!($res = $cxn->query($q))) {
            exit("error (showOpeToolBatchUI) {$q} : {$cxn->error}");
        }
        $r = $res->num_rows;
        print '<table>';
        if ($r == 0) {
            print '<thead><tr><th class="v">Ope Tool ID</th><th class="v">Tool Description</th><th>Tool Used</th><th class="v">Tool Body Description</th><th>Tool Body Used</th><th class="v">Holder Description</th><th width:"25">Holder Used</th></tr></thead><tbody>';
            $qs = "SELECT * FROM Ope_Tool WHERE Ope_Drawing_ID={$this->operevid} AND Deleted!=1";
            if (!($ress = $cxn->query($qs))) {
                echo "error :", $cxn->error;
            }
            $i = 0;
            while ($row = mysqli_fetch_assoc($ress)) {
                $id = $row['Ope_Tool_ID'];
                $qt = "SELECT Tool_Desc,Brand_Description From Tool as t inner join Tool_Brand as tb on tb.Brand_ID=t.Brand_ID WHERE Tool_ID={$row['Tool_ID_1']}";
                if (!($rest = $cxn->query($qt))) {
                    echo "error :", $cxn->error;
                }
                $t = mysqli_fetch_assoc($rest);
                $qh = "SELECT Holder_Description From Holder WHERE Holder_ID={$row['Holder_ID_1']}";
                if (!($resh = $cxn->query($qh))) {
                    echo "error :", $cxn->error;
                }
                $h = mysqli_fetch_assoc($resh);
                $qb = "SELECT Tool_Desc,Brand_Description,Mfg_Part_NO From ToolBody as t inner join Tool_Brand as tb on tb.Brand_ID=t.Brand_ID WHERE ToolBody_ID={$row['ToolBody_ID_1']}";
                if (!($resb = $cxn->query($qb))) {
                    echo "error :", $cxn->error;
                }
                $tb = mysqli_fetch_assoc($resb);
                $optid = new Form(array('type' => 'hidden', 'id' => 'opetoolid[' . $i . ']', 'name' => 'opetoolid[' . $i . ']', 'value' => $row['Ope_Tool_ID']));
                $tsid = new Form(array('id' => 'toolstockid[' . $i . ']', 'name' => 'toolstockid[' . $i . ']', 'class' => 'required', 'unique' => 'toolstockid'));
                $tbsid = new Form(array('id' => 'toolbodystockid[' . $i . ']', 'name' => 'toolbodystockid[' . $i . ']'));
                $hsid = new Form(array('id' => 'holderstockid[' . $i . ']', 'name' => 'holderstockid[' . $i . ']', 'class' => 'required number'));
                echo <<<_END

\t\t\t\t\t\t\t<tr><th class="v">{$optid->ip} {$row['Ope_Tool_ID']}</th>
\t\t\t\t\t\t\t\t<th class="v">{$t['Brand_Description']} Make {$t['Tool_Desc']}</th><td>{$tsid->ip}</td>
\t\t\t\t\t\t\t\t<th class="v">{$tb['Brand_Description']} Make {$tb['Tool_Desc']}</th><td>{$tbsid->ip}</td>
\t\t\t\t\t\t\t\t<th class="v">{$h['Holder_Description']}</th><td>{$hsid->ip}</td></tr>
_END;
                $i++;
            }
        } else {
            ///we are either changing a tool to returning back all tools
            print '<thead><tr><th class="v">Ope Tool ID</th><th class="v">Tool Description</th><th>Tool Used</th><th>No Of Jobs</th><th>Storage Location</th>
							<th class="v">Tool Body Description</th><th>Tool Body Used</th><th>Body Storage Location</th>
							<th class="v">Holder Description</th><th width:"25">Holder Used</th><th>Holder Storage Location</th><th>Remarks</th></tr></thead><tbody>';
            $qs = "SELECT * FROM Ope_Tool WHERE Ope_Drawing_ID={$this->operevid} AND Deleted!=1";
            if (!($ress = $cxn->query($qs))) {
                exit("error (showOpeToolBatchUI 2) {$qs} : {$cxn->error}");
            }
            $any = new Anylist();
            $i = 0;
            while ($row = mysqli_fetch_assoc($ress)) {
                $qt = "SELECT Tool_Desc,Brand_Description From Tool as t inner join Tool_Brand as tb on tb.Brand_ID=t.Brand_ID WHERE Tool_ID={$row['Tool_ID_1']}";
                if (!($rest = $cxn->query($qt))) {
                    echo "error :", $cxn->error;
                }
                $t = mysqli_fetch_assoc($rest);
                $qtt = "SELECT * FROM Ope_Tool_Batch WHERE Ope_Tool_ID={$row['Ope_Tool_ID']} AND Cutting_Mins=0 AND Qty=0";
                if (!($restt = $cxn->query($qtt))) {
                    echo "error :", $cxn->error;
                }
                $tt = mysqli_fetch_assoc($restt);
                $qt = "SELECT Tool_Desc,Brand_Description From Tool as t inner join Tool_Brand as tb on tb.Brand_ID=t.Brand_ID WHERE Tool_ID={$row['Tool_ID_1']}";
                if (!($rest = $cxn->query($qt))) {
                    echo "error :", $cxn->error;
                }
                $t = mysqli_fetch_assoc($rest);
                $qh = "SELECT Holder_Description From Holder WHERE Holder_ID={$row['Holder_ID_1']}";
                if (!($resh = $cxn->query($qh))) {
                    echo "error :", $cxn->error;
                }
                $h = mysqli_fetch_assoc($resh);
                $qb = "SELECT Tool_Desc,Brand_Description,Mfg_Part_NO From ToolBody as t inner join Tool_Brand as tb on tb.Brand_ID=t.Brand_ID WHERE ToolBody_ID={$row['ToolBody_ID_1']}";
                if (!($resb = $cxn->query($qb))) {
                    echo "error :", $cxn->error;
                }
                $tb = mysqli_fetch_assoc($resb);
                if ($tt['Ope_Tool_Batch_ID'] != '') {
                    $optbid = new Form(array('type' => 'hidden', 'id' => 'opetoolbatchid[' . $i . ']', 'name' => 'opetoolbatchid[' . $i . ']', 'value' => $tt['Ope_Tool_Batch_ID']));
                } else {
                    //if there in no tool associated with entry in tool list
                    $optbid = new Form(array('type' => 'hidden', 'id' => 'opetoolid[' . $i . ']', 'name' => 'opetoolid[' . $i . ']', 'value' => $row['Ope_Tool_ID']));
                }
                $tsid = new Form(array('id' => 'toolstockid[' . $i . ']', 'name' => 'toolstockid[' . $i . ']', 'class' => 'required', 'value' => $tt['Tool_Stock_ID'], 'unique' => 'toolstockid', 'size' => "10"));
                $tbsid = new Form(array('id' => 'toolbodystockid[' . $i . ']', 'name' => 'toolbodystockid[' . $i . ']', 'value' => $tt['Tool_Body_Stock_ID'], 'size' => "10"));
                $hsid = new Form(array('id' => 'holderstockid[' . $i . ']', 'name' => 'holderstockid[' . $i . ']', 'class' => 'required number', 'value' => $tt['Holder_Stock_ID'], 'unique' => 'holderstockid', 'size' => "10"));
                $tqty = new Form(array('id' => 'jobqty[' . $i . ']', 'name' => 'jobqty[' . $i . ']', 'class' => 'number', 'value' => '0', 'size' => "10"));
                $trem = new Form(array('id' => 'remarks[' . $i . ']', 'name' => 'remarks[' . $i . ']'));
                echo <<<_END

\t\t\t\t\t\t\t<tr><th class="v" style="width:30px">{$optbid->ip} {$row['Ope_Tool_ID']}</th>
\t\t\t\t\t\t\t\t<th class="v" style="width:100px">{$t['Brand_Description']} Make {$t['Tool_Desc']}</th><td>{$tsid->ip}</td><td>{$tqty->ip}</td>
\t\t\t\t\t\t\t\t<td>
_END;
                $any->createList('Tool_Storage');
                $sel = new selectlist('Tool_Storage_ID[' . $i . ']', $any->getValue('anylist'), 'Storage Location', 'Tool_Storage_ID', 'Cur_Location', 'class="required"', 2, null);
                echo <<<_END
\t\t\t\t\t\t\t\t</td><th class="v">{$tb['Brand_Description']} Make {$tb['Tool_Desc']}</th><td>{$tbsid->ip}</td><td>
_END;
                $any->createList('Tool_Storage');
                $sel = new selectlist('ToolBody_Storage_ID[' . $i . ']', $any->getValue('anylist'), 'Storage Location', 'Tool_Storage_ID', 'Cur_Location', 'class="required"', 2, null);
                echo <<<_END
\t\t\t\t\t\t\t\t</td><th class="v" style="width:50px">{$h['Holder_Description']}</th><td>{$hsid->ip}</td><td>
_END;
                $any->createList('Tool_Storage');
                $sel = new selectlist('Holder_Storage_ID[' . $i . ']', $any->getValue('anylist'), 'Storage Location', 'Tool_Storage_ID', 'Cur_Location', 'class="required"', 2, null);
                echo <<<_END
\t\t\t\t\t\t\t\t</td><td>{$trem->ip}</td></tr>
_END;
                $i++;
            }
        }
        $bt = new Form(array('id' => 'save', 'name' => 'save', 'type' => 'button', 'value' => 'Save', 'class' => 'submit'));
        echo '<tr><td colspan="4" style="text-align:center;">' . $bt->ip . '</td></tr>';
        echo '</tbody></table>';
    }
コード例 #2
0
ファイル: class.Operator.php プロジェクト: sknagesh/divyaeng2
 function leaveUI()
 {
     $db = Database::getInstance();
     $cxn = $db->getConnection();
     if (isset($_SESSION['operatorid'])) {
         $this->operatorid = $_SESSION['operatorid'];
     } else {
         exit('Not Logged In!!');
     }
     $any = new Anylist();
     $any->createList('Leave_Reasons');
     echo '<fieldset><legend>Enter Leave Details</legend>';
     echo '<p><label>From</label><input id="leavefrom" name="leavefrom" class="required"><input id="leavefromdb" name="leavefromdb" type="hidden"></p>';
     echo '<p><label>To</label><input id="leaveto" name="leaveto" class="required"><input id="leavetodb" name="leavetodb" type="hidden"></p>';
     $sel = new selectlist('Leave_Reason', $any->getValue('anylist'), 'Select Leave Reason', 'Reason', 'Reason', 'class="required"', '', 1);
     echo '</fieldset>';
 }
コード例 #3
0
    function showToolBodyStockUI()
    {
        if ($this->toolbodystockid == '') {
            echo <<<_END
\t\t\t<fieldset>
\t\t\t\t<legend>Tool Details</legend>
   \t\t\t\t<p>
\t\t\t     <label>New Tool Body Quantity</label>
\t\t\t     <input id="qty" name="qty" size="25" class="number"/>
\t\t\t   </p>
   \t\t\t\t<p>
\t\t\t     <label>Price of Each New Tool</label>
\t\t\t     <input id="price" name="price" size="25" class="number"/>
\t\t\t   </p>
   \t\t\t\t<p>
\t\t\t     <label>Storage Bin ID</label>
\t\t\t     <input id="binid" name="binid" size="25" />
\t\t\t   </p>

\t\t\t\t</fieldset>
\t\t\t   <p>
\t\t\t     <input class="submit" type="submit" value="Save"/>
\t\t\t   </p>


_END;
        } else {
            $db = Database::getInstance();
            $cxn = $db->getConnection();
            $q = "SELECT * FROM ToolBody_Stock WHERE ToolBody_Stock_ID={$this->toolbodystockid}";
            if (!($res = $cxn->query($q))) {
                echo "error :", $cxn->error;
            } else {
                $row = mysqli_fetch_assoc($res);
                $any = new Anylist();
                echo <<<_END
\t\t\t<fieldset>
\t\t\t\t<legend>Tool Details</legend>

_END;
                if ($this->typeid != 18) {
                    echo <<<_END
   \t\t\t\t<p>
\t\t\t     <label>Cutting Dia (Dc)</label>
\t\t\t     <input id="cdiameter" name="cdiameter" size="25" class="number" value="{$row['Cutting_Dia']}"/>
\t\t\t   </p>
\t\t\t   <p>
\t\t\t     <label>Shank Diameter (Ds)</label>
\t\t\t     <input id="sdiameter" name="sdiameter" size="25" class="number" value="{$row['Shank_Dia']}"/>
\t\t\t   </p>
\t\t\t   <p>
\t\t\t     <label>Flute Length (FL)</label>
\t\t\t     <input id="flutelength" name="flutelength" size="25"  class="required number" value="{$row['Tool_FL']}"/>
\t\t\t   </p>

_END;
                    if ($this->typeid != 3) {
                        echo <<<_END

   \t\t\t\t<p>
\t\t\t     <label>Neck Diameter (Dn)</label>
\t\t\t     <input id="ndiameter" name="ndiameter" size="25" class="number" value="{$row['Neck_Dia']}"/>
\t\t\t   </p>
_END;
                    }
                    echo <<<_END
\t\t\t   <p>
\t\t\t     <label>Neck Length/Reach (NL)</label>
\t\t\t     <input id="reach" name="reach" size="25" class="number greaterThan" data-min="flutelength" value="{$row['Neck_Length']}"/>
\t\t\t   </p>



\t\t\t   <p>
\t\t\t   <p>
\t\t\t     <label>Overall Length (OAL)</label>
\t\t\t     <input id="tooloal" name="tooloal" size="25" class="number greaterThan" data-min="flutelength" data-min="reach" value="{$row['Tool_OAL']}"/>
\t\t\t   </p>
_END;
                    if ($this->typeid == 9) {
                        echo <<<_END
\t\t\t   <p>
\t\t\t     <label>Max Radial Depth (Tmax)</label>
\t\t\t     <input id="tmax" name="tmax" size="25" class="number" class="required" value="{$row['T_Max']}"/>
\t\t\t   </p>
_END;
                    }
                }
                echo <<<_END
\t\t\t     <label>Price</label>
\t\t\t     <input id="price" name="price" size="25" class="number" value="{$row['Price']}"/>
\t\t\t   </p>
   \t\t\t\t<p>
\t\t\t     <label>Storage Bin ID</label>
\t\t\t     <input id="binid" name="binid" size="25" value="{$row['Bin_ID']}"/>
\t\t\t   </p>
\t\t\t   <p>
\t\t\t     <label>Current Location</label>
_END;
                $any->createList('Tool_Storage');
                $sel = new selectlist('Tool_Storage_ID', $any->getValue('anylist'), 'Storage Location', 'Tool_Storage_ID', 'Cur_Location', 'class="required"', $row['Cur_Location'], null);
                echo <<<_END
\t\t\t   </p>
   \t\t\t\t<p>
\t\t\t     <label>Remarks</label>
\t\t\t     <input id="remarks" name="remarks" size="25" value="{$row['Remarks']}"/>
\t\t\t   </p>

\t\t\t\t</fieldset>
\t\t\t   <p>
\t\t\t     <input class="submit" type="submit" value="Save"/>
\t\t\t   </p>


_END;
            }
        }
    }
コード例 #4
0
    function showHolderStockUI()
    {
        if ($this->holderstockid == '') {
            echo <<<_END
\t\t\t<fieldset>
\t\t\t\t<legend>Tool Holder Details</legend>
   \t\t\t\t<p>
\t\t\t     <label>New Tool Holder Quantity</label>
\t\t\t     <input id="qty" name="qty" size="25" class="number"/>
\t\t\t   </p>
   \t\t\t\t<p>
\t\t\t     <label>Price of Each New Holder</label>
\t\t\t     <input id="price" name="price" size="25" class="number"/>
\t\t\t   </p>
\t\t\t\t</fieldset>
\t\t\t   <p>
\t\t\t     <input class="submit" type="submit" value="Save"/>
\t\t\t   </p>


_END;
        } else {
            $db = Database::getInstance();
            $cxn = $db->getConnection();
            $q = "SELECT * FROM Holder_Stock WHERE Holder_Stock_ID={$this->holderstockid}";
            if (!($res = $cxn->query($q))) {
                echo "error :", $cxn->error;
            } else {
                $row = mysqli_fetch_assoc($res);
                $any = new Anylist();
                echo <<<_END
\t\t\t<fieldset>
\t\t\t\t<legend>Holder Location Details</legend>
\t\t\t   <p>
\t\t\t     <label>Current Location</label>
_END;
                $any->createList('Tool_Storage');
                $sel = new selectlist('Tool_Storage_ID', $any->getValue('anylist'), 'Storage Location', 'Tool_Storage_ID', 'Cur_Location', 'class="required"', $row['Cur_Location'], null);
                echo <<<_END

\t\t\t   </p>
   \t\t\t\t<p>
\t\t\t     <label>Remarks</label>
\t\t\t     <input id="remarks" name="remarks" size="25" value="{$row['Remarks']}"/>
\t\t\t   </p>

\t\t\t\t</fieldset>
\t\t\t   <p>
\t\t\t     <input class="submit" type="submit" value="Save"/>
\t\t\t   </p>


_END;
            }
        }
    }