"; print_r($data); echo ""; } /** * This function used to get the CI instance */ if(!function_exists('get_instance')) { function get_instance() { $CI = &get_instance(); } } /** * This function used to generate the hashed password * @param {string} $plainPassword : This is plain text password */ if(!function_exists('getHashedPassword')) { function getHashedPassword($plainPassword) { return password_hash($plainPassword, PASSWORD_DEFAULT); } } /** * This function used to generate the hashed password * @param {string} $plainPassword : This is plain text password * @param {string} $hashedPassword : This is hashed password */ if(!function_exists('verifyHashedPassword')) { function verifyHashedPassword($plainPassword, $hashedPassword) { return password_verify($plainPassword, $hashedPassword) ? true : false; } } function get_fav($user) { $CI = &get_instance(); $CI->load->database(); $user = (int)$user; $CI->db->reconnect(); $CI->db->where('Created_BY',$user); $CI->db->where('Status',1); return $CI->db->get('T_fav_add')->result(); } function reOrderListing() { $CI = &get_instance(); $CI->load->database(); $CI->db->reconnect(); //$subQuery='SELECT * from T_MaterialMaster where Current_stock < reorder?'; $today= date("Y-m-d"); $today_month = date('F', strtotime($today)); $today_year = date('Y', strtotime($today)); $pre_year = $today_year -1; $Fin_year =''; if($today_month <=3) { $Fin_year = '01-04-'.$pre_year; } else { $Fin_year = '01-04-'.$today_year; } // $subQuery="SELECT DISTINCT(p.MaterialCode),mm.MaterialName,opens.OpeningStock // FROM T_Material_stock_history AS p // left join T_MaterialMaster mm on mm.MaterialCode = p.MaterialCode // left join (select StockId,pp.MaterialCode mc, // SUM((IF(pp.Transaction_type='Add',Quantity,0))-(IF(pp.Transaction_type='Reduce',Quantity,0))) // AS OpeningStock // FROM T_Material_stock_history AS pp // GROUP BY pp.MaterialCode // ) as opens on opens.mc = p.MaterialCode // where OpeningStockdb->query($subQuery,array()); //print_r($this->db->last_query()); return $query->result(); } ?>