/**
* function to get the prospect wins
* @param string $where
* @param integer $iduser
* @param integer $date_filter_type
* @param string $start_date
* @param string $date_end
* @return array
*/
public function get_detailed_win_data($where = '', $iduser = 0, $date_filter_type, $start_date = '', $end_date = '')
{
$do_potentials = new Potentials();
$do_potentials->get_list_query();
if ($where == '') {
$user_where = $this->get_report_where($iduser, 'potentials', 'pot_to_grp_rel');
$date_where = $this->get_date_filter_where('potentials', 'expected_closing_date', $date_filter_type, $start_date = '', $end_date = '');
$additonal_where = " AND\n\t\t\t`potentials`.`sales_stage` = 'Close Win'\n\t\t\t";
$where = $user_where . $date_where . $additonal_where;
}
$qry = $do_potentials->getSqlQuery();
$qry .= $where;
$this->query($qry);
}
/**
* function to get the detailed forcasting data
* @param string $where
* @param integer $iduser
* @return void
*/
public function get_detailed_forecast_data($where = '', $iduser = 0)
{
$do_potentials = new Potentials();
$do_potentials->get_list_query();
if ($where == '') {
$user_where = $this->get_report_where($iduser, 'potentials', 'pot_to_grp_rel');
}
$date_where = '';
$start_date = TimeZoneUtil::get_user_timezone_date();
$date_obj = new DateTime($start_date);
$add_89 = $date_obj->modify('+89 day');
$end_date = $add_89->format('Y-m-d');
$date_where = " and `potentials`.`expected_closing_date` >= '{$start_date}' \n\t\tand `potentials`.`expected_closing_date` <= '{$end_date}' \n\t\t";
$qry = $do_potentials->getSqlQuery();
$qry .= $user_where . $date_where . " order by `potentials`.`expected_closing_date`";
$this->query($qry);
}
/**
* function to get the detailed funnel data
* @param string $where
* @param integer $iduser
* @param integer $date_filter_type
* @param string $start_date
* @param string $date_end
* @return array
*/
public function get_detailed_funnel_data($where = '', $iduser = 0, $date_filter_type, $start_date = '', $end_date = '')
{
$do_potentials = new Potentials();
$do_potentials->get_list_query();
if ($where == '') {
$user_where = $this->get_report_where($iduser, 'potentials', 'pot_to_grp_rel');
$date_where = $this->get_date_filter_where('potentials', 'expected_closing_date', $date_filter_type, $start_date = '', $end_date = '');
$where = $user_where . $date_where;
}
$qry = $do_potentials->getSqlQuery();
$qry .= $where;
$this->query($qry);
}