當前位置: 首頁>>代碼示例>>PHP>>正文


PHP DbUtils::selectQuery方法代碼示例

本文整理匯總了PHP中DbUtils::selectQuery方法的典型用法代碼示例。如果您正苦於以下問題:PHP DbUtils::selectQuery方法的具體用法?PHP DbUtils::selectQuery怎麽用?PHP DbUtils::selectQuery使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在DbUtils的用法示例。


在下文中一共展示了DbUtils::selectQuery方法的15個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的PHP代碼示例。

示例1: UpdateCounterCache

 function UpdateCounterCache($department_id)
 {
     $sql = 'SELECT count(*) FROM USER WHERE user_department=' . $department_id;
     $count = parent::selectQuery($sql);
     $sql = "UPDATE departments  \n\t\t\t\tSET department_user_count = {$count} \n\t\t\t\tWHERE department_id={$department_id}";
     parent::updateQuery($sql);
 }
開發者ID:rajibahmed,項目名稱:IIMS,代碼行數:7,代碼來源:department.class.php

示例2: RetriveQuotationDetailsInfoByIndendId

 public function RetriveQuotationDetailsInfoByIndendId($quot_ms_id)
 {
     $sql = "SELECT qud.*, stki.stock_item_name \n \t\t\t\tFROM quotation_details qud, quotation_master qum, stock_item stki \n \t\t\t\tWHERE qud.quot_master_id='{$quot_ms_id}' \n \t\t\t\tAND stki.stock_item_id= qud.stock_item_id \n \t\t\t\tGROUP BY qud.stock_item_id ";
     return parent::selectQuery($sql);
 }
開發者ID:rajibahmed,項目名稱:IIMS,代碼行數:5,代碼來源:indent.class.php

示例3:

 function updateSta_len($Sta_Lent_id, $Sta_Len_name)
 {
     $sql = "UPDATE staple_length SET sta_len_name='{$Sta_Len_name}' WHERE sta_len_id = '{$Sta_Lent_id}'";
     return parent::selectQuery($sql);
 }
開發者ID:rajibahmed,項目名稱:IIMS,代碼行數:5,代碼來源:staple_length.class.php

示例4: FindDetailsOfGatePass

 public function FindDetailsOfGatePass($id)
 {
     $sql = "\tSELECT cd.*,si.* ,gpm.*,cm.consumption_num,siu.* ,\n\t \t\t\tGROUP_CONCAT(scd.stock_code,' ') stock_code, \n\t\t\t\tGROUP_CONCAT(spd.stock_part,' ') stock_part \n\t\t\t\t\t\n\t\t\t\tFROM gate_pass_master gpm,gate_pass_details cd, \n\t\t\t\tstock_item si, stock_code_details scd, stock_part_details spd,consumptions_master cm,stock_item_units siu\n\t\t\t\tWHERE \n\t\t\t\t\tcd.stock_item_id = si.stock_item_id\n\t\t\t\tAND \n\t\t\t\t\tsi.stock_code_m_id = scd.stock_code_m_id \n\t\t\t\tAND\n\t\t\t\t\tcd.gate_pass_m_id=1\n\t\t\t\tAND\n\t\t\t\t\tsi.stock_part_m_id= spd.stock_part_m_id \n\t\t\t\tAND \n\t\t\t\t\tgpm.gate_pass_id = cd.gate_pass_m_id\n\t\t\t\tAND \n\t\t\t\t\tcm.cm_id = gpm.ref_id \n\t\t\t\tAND\n\t\t\t\t\tsi.stock_item_unit_id =siu.stock_item_unit_id\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t GROUP BY si.stock_item_id";
     return parent::selectQuery($sql);
 }
開發者ID:rajibahmed,項目名稱:IIMS,代碼行數:5,代碼來源:gatePass.class.php

示例5: PrintDetailsOfStockReturn

 public function PrintDetailsOfStockReturn($id)
 {
     $sql = "\tSELECT srd.*,si.* ,srm.*,siu.*, GROUP_CONCAT(scd.stock_code,' ') stock_code\n\t\t\t\tFROM \n\t\t\t\t\tstock_return_details srd,stock_return_master srm, stock_item si, \n\t\t\t\t\tstock_code_details scd, stock_item_units siu\n\t\t\t\tWHERE \n\t\t\t\t\tsrd.stock_item_id = si.stock_item_id\n\t\t\t\tAND \n\t\t\t\t\tsi.stock_code_m_id = scd.stock_code_m_id \n\t\t\t\tAND\n\t\t\t\t\tsrd.stk_return_m_id={$id}\n\t\t\t\tAND\n\t\t\t\t\tsi.stock_item_unit_id =siu.stock_item_unit_id \t\n\t\t\t\tAND\n\t\t\t\t\tsrm.stock_retun_m_id=srd.stk_return_m_id\n\t\t\t\t GROUP BY si.stock_item_id";
     return parent::selectQuery($sql);
 }
開發者ID:rajibahmed,項目名稱:IIMS,代碼行數:5,代碼來源:stkReturn.class.php

示例6: PrintDetailsOfQC

 public function PrintDetailsOfQC($id)
 {
     $sql = "\tSELECT qcd.*,si.* ,qcm.*, mrr.*,pr.* , sp.* \n\t\t\t\tFROM \n\t\t\t\t\tqc_details qcd,qc_master qcm, stock_item si, mrr_master mrr, \n\t\t\t\t\t purchase_master pr, supplier sp\n\t\t\t\tWHERE \n\t\t\t\t\tqcd.stock_item_id = si.stock_item_id\n\t\t\t\t\n\t\t\t\tAND\n\t\t\t\t\tqcd.qc_m_id={$id}\n\t\t\t\t\t\n\t\t\t\tAND\n\t\t\t\t\tqcm.qc_id=qcd.qc_m_id\n\t\t\t\tAND\n\t\t\t\t\tqcm.mrr_m_id=mrr.mrr_id \n\t\t\t\tAND\n\t\t\t\t\tqcm.purchase_m_id=pr.pm_id \n\t\t\t\t\n\t\t\t\tAND\n\t\t\t\t\tqcm.supplier_id=sp.sup_id\t\t\t\n\t\t\t\t\t\n\t\t\t\t GROUP BY si.stock_item_id";
     return parent::selectQuery($sql);
 }
開發者ID:rajibahmed,項目名稱:IIMS,代碼行數:5,代碼來源:qc.class.php

示例7: retriveMRRInfo

 public function retriveMRRInfo()
 {
     $sql = "SELECT  mrr_id ,mrr_number   \n\t\t\t\tFROM mrr_master";
     return parent::selectQuery($sql);
 }
開發者ID:rajibahmed,項目名稱:IIMS,代碼行數:5,代碼來源:mrr.class.php

示例8: UpadteRawItemByID

 function UpadteRawItemByID($stock_item_id, $stkName, $stkGrp, $unitId, $altUnitId, $unitRel1, $unitRel2, $length, $txtStkcode, $desc, $opQnty, $OpRate, $opValue)
 {
     $sql = "UPDATE raw_item \n\t\tSET stock_item_name='{$stkName}',\n\t\tstock_item_grp_id ='{$stkGrp}',\n\t\tstock_item_unit_id='{$unitId}',\n\t\t stock_alt_unit='{$altUnitId}',\n\t\t unit_relation1='{$unitRel1}',\n\t\t unit_relation2 ='{$unitRel2}',\n\t\t length='{$length}',\n\t\t stock_code_m_id='{$txtStkcode}',\n\t\t stock_item_desc ='{$desc}',\n\t\t stock_item_op_balance='{$opQnty}', \n\t\t stock_item_op_rate='{$OpRate}',\n\t\t stock_item_op_value='{$opValue}' \n\t\t WHERE stock_item_id='{$stock_item_id}'";
     return parent::selectQuery($sql);
 }
開發者ID:rajibahmed,項目名稱:IIMS,代碼行數:5,代碼來源:raw_item.class.php

示例9: FindDetailsOfConsumption

 public function FindDetailsOfConsumption($id)
 {
     $sql = "\tSELECT cd.*, si.*, cm.*, siu.* ,\n\t\t\t\t\tGROUP_CONCAT(scd.stock_code,' ') stock_code,\n\t\t\t\t\tGROUP_CONCAT(spd.stock_part,' ') stock_part \n\t\t\t\t\t\t\n\t\t\t\tFROM consumptions_master cm, consumption_details cd, stock_item si,stock_item_units siu,\n\t\t\t\t stock_code_details scd, stock_part_details spd\n\t\t\t\t\n\t\t\t\tWHERE \n\t\t\t\t\tcd.stock_item_id = si.stock_item_id\n\t\t\t\tAND \n\t\t\t\t\tsi.stock_code_m_id = scd.stock_code_m_id \n\t\t\t\tAND\n\t\t\t\t\tcd.consumptions_master_id={$id}\n\t\t\t\tAND\n\t\t\t\t\tsi.stock_part_m_id= spd.stock_part_m_id \n\t\t\t\tAND \n\t\t\t\t\tcd.consumptions_master_id =cm.cm_id\n\t\t\t\tAND\n\t\t\t\t\tsi.stock_item_unit_id =siu.stock_item_unit_id\n\t\t\t\t\t\n\t\t\t\t GROUP BY si.stock_item_id";
     return parent::selectQuery($sql);
 }
開發者ID:rajibahmed,項目名稱:IIMS,代碼行數:5,代碼來源:consumption.class.php

示例10: PrintPurchaseOrderById

 public function PrintPurchaseOrderById($id)
 {
     $sql = "SELECT p_d.*,st.*,pm.*,im.indent_id, im.indent_code,\n\t\t\t\tsup.sup_id,\tsup.sup_name, sup.sup_address,\n\t\t\t\tsiu.stock_item_unit_id,\tsiu.stock_item_unit_name,\n\t\t\t\tGROUP_CONCAT(scd.stock_code,' ') stock_code, \n\t\t\t\tGROUP_CONCAT(spd.stock_part,' ') stock_part  \n\t\tFROM \n\t\t\tpurchase_details p_d,  stock_item st , purchase_master pm, supplier sup,\n\t\t\tstock_code_details scd, stock_part_details spd,indents_master im,stock_item_units siu\n\t\twhere \n\t\t\tp_d.pm_id='{$id}' \n\t\tAND\n\t\t\tp_d.pm_id=pm.pm_id\n\t\tAND \n\t\t\tim.indent_id=pm.indent_id\n\t\tAND\n\t\t\tsup.sup_id=pm.sup_id\n\t\tAND\n\t\t\tsiu.stock_item_unit_id=st.stock_item_unit_id\n\t\tAnd \n\t\t\tst.stock_item_id= p_d.stock_item_id\n\t\tAND \n\t\t\tst.stock_code_m_id = scd.stock_code_m_id \n\t\tAND\n\t\t\tst.stock_part_m_id= spd.stock_part_m_id\n\t\t\n\t\tGROUP BY st.stock_item_id \t\n\t\t ";
     return parent::selectQuery($sql);
 }
開發者ID:rajibahmed,項目名稱:IIMS,代碼行數:5,代碼來源:purchaseOrder.class.php

示例11: GetSectionByID

 function GetSectionByID($id)
 {
     $sql = "SELECT usr_sec . * ,depmnt .* , ofic.* \n\t\t\t\t\tFROM user_section usr_sec, departments depmnt, offices ofic \t\n\t\t\t\t\tWHERE  usr_sec.sec_id= '{$id}' \n\t\t\t\t\tAND usr_sec.dep_id=depmnt.department_id\t\n\t\t\t\t\tAND usr_sec.office_id=ofic.office_id ";
     return parent::selectQuery($sql);
 }
開發者ID:rajibahmed,項目名稱:IIMS,代碼行數:5,代碼來源:section.class.php

示例12: updateCount

 function updateCount($count_id, $count_name)
 {
     $sql = "UPDATE count SET count_name='{$count_name}' WHERE count_id = '{$count_id}'";
     return parent::selectQuery($sql);
 }
開發者ID:rajibahmed,項目名稱:IIMS,代碼行數:5,代碼來源:count.class.php

示例13: FindDetailsOfQoutation

 function FindDetailsOfQoutation($id)
 {
     $sql = "SELECT qd.* , si.*   \n\t\t\t\tFROM \n\t\t\t\t\tquotation_details qd,\n\t\t\t\t\tstock_item si \n\t\t\t\tWHERE \n\t\t\t\t\tqd.stock_item_id=si.stock_item_id \n\t\t\t\t\tAND qd.quot_master_id = {$id} \n\t\t\t\t\t";
     //echo $sql;
     return parent::selectQuery($sql);
 }
開發者ID:rajibahmed,項目名稱:IIMS,代碼行數:6,代碼來源:quotation.class.php

示例14: retriveRawItemReport

 public function retriveRawItemReport()
 {
     $sql = 'SELECT * FROM raw_item';
     return parent::selectQuery($sql);
 }
開發者ID:rajibahmed,項目名稱:IIMS,代碼行數:5,代碼來源:report.class.php

示例15: retriveStockCatUnderInfo

 function retriveStockCatUnderInfo()
 {
     $sql = "select  stock_cat_name,stock_cat_id from stock_catagory ";
     return parent::selectQuery($sql);
 }
開發者ID:rajibahmed,項目名稱:IIMS,代碼行數:5,代碼來源:c.class.php


注:本文中的DbUtils::selectQuery方法示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台,相關代碼片段篩選自各路編程大神貢獻的開源項目,源碼版權歸原作者所有,傳播和使用請參考對應項目的License;未經允許,請勿轉載。