/** * Chart Type column2d - CUSTOMER_PER_ITEM * DAILY - All Stock customer per Item * @type GET * @author ptrnov <*****@*****.**> * @since 1.1 */ protected function wh_customer_item() { return Rpt001::find()->where("MODUL_NM='ESM_WAREHOUSE_CUSTOMER_PER_ITEM' and MODUL_GRP=7")->one()->VAL_VALUE; }
/** * Chart Type column2d - ESM_SALES_OTHERS_PER_ITEM * DAILY - All Sell-Out per Item * @type GET * @author ptrnov <*****@*****.**> * @since 1.1 */ protected function sales_others_item() { return Rpt001::find()->where("MODUL_NM='ESM_SALES_OTHER_PER_ITEM' and MODUL_GRP=8")->one()->VAL_VALUE; }
/** * Employee Summary * @type GET * @author ptrnov <*****@*****.**> * @since 1.1 */ protected function emp_summay() { /* $emp_summary=' "Employe_Summary":[ {"emp_total":"120"}, {"emp_probation":"110"}, {"emp_contract":"110"}, {"emp_tetap":"110"} ] '; return $emp_summary; */ return Rpt001::find()->where("MODUL_NM='HRM_PERSONALIA_SUMMARY'")->one()->VAL_VALUE; }
/** * Vaues chart,from database * Chart Type column2d - support_dataset * @type GET * @author ptrnov <*****@*****.**> * @since 1.1 */ protected function support_dataset() { /** * MODUL_NM ='HRM_PERSONALIA_TURNOVER_SUPPORT' * Group [1 = HRM_PERSONALIA] */ return Rpt001::find()->where("MODUL_NM='HRM_PERSONALIA_TURNOVER_SUPPORT' and MODUL_GRP=1")->one()->VAL_VALUE; }