140 lines
3.2 KiB
PHP
140 lines
3.2 KiB
PHP
<?php if(!defined('BASEPATH')) exit('No direct script access allowed');
|
|
|
|
|
|
/**
|
|
* This function is used to print the content of any data
|
|
*/
|
|
function pre($data)
|
|
{
|
|
echo "<pre>";
|
|
print_r($data);
|
|
echo "</pre>";
|
|
}
|
|
|
|
/**
|
|
* 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 OpeningStock<reorder" ;
|
|
|
|
$subQuery ="SELECT DISTINCT(p.MaterialCode),mm.MaterialName,opens.CurrentStock,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 CurrentStock,
|
|
|
|
SUM(
|
|
CASE WHEN date(stockdate) > '".$Fin_year."'
|
|
THEN stock
|
|
ELSE 0
|
|
END
|
|
) as OpeningStock
|
|
|
|
FROM T_Material_stock_history AS pp
|
|
left join T_MaterialMaster mm on mm.MaterialCode = pp.MaterialCode
|
|
GROUP BY pp.MaterialCode
|
|
) as opens on opens.mc = p.MaterialCode
|
|
|
|
|
|
where (CurrentStock+OpeningStock)<reorder";
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$query=$CI->db->query($subQuery,array());
|
|
//print_r($this->db->last_query());
|
|
|
|
return $query->result();
|
|
}
|
|
|
|
?>
|