<?php
// ##############################################################################
// ASTPP - Open Source VoIP Billing Solution
//
// Copyright (C) 2016 iNextrix Technologies Pvt. Ltd.
// Samir Doshi <samir.doshi@inextrix.com>
// ASTPP Version 3.0 and above
// License https://www.gnu.org/licenses/agpl-3.0.html
//
// This program is free software: you can redistribute it and/or modify
// it under the terms of the GNU Affero General Public License as
// published by the Free Software Foundation, either version 3 of the
// License, or (at your option) any later version.
//
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU Affero General Public License for more details.
//
// You should have received a copy of the GNU Affero General Public License
// along with this program. If not, see <http://www.gnu.org/licenses/>.
// ##############################################################################
class Frauddetection extends CI_Controller
{
function __construct()
{
parent::__construct();
$this->load->helper('template_inheritance');
$this->load->library('session');
$this->load->library("frauddetection_form");
// $this->load->library('astpp/form');
$this->load->library('astpp/form',"frauddetection_form");
$this->load->model('frauddetection_model');
$this->load->library('csvreader');
$this->load->library('ASTPP_Sms');
if ($this->session->userdata('user_login') == FALSE)
redirect(base_url() . '/astpp/login');
}
function frauddetection_list()
{
$data['page_title'] = gettext('Fraud Detection'); $data['search_flag'] = true;
$this->session->set_userdata('advance_search', 0);
$data['grid_fields'] = $this->frauddetection_form->build_frauddetection_list_for_admin();
$data["grid_buttons"] = $this->frauddetection_form->build_grid_buttons();
$data['form_search'] = $this->form->build_serach_form($this->frauddetection_form->get_search_frauddetection_form());
$this->load->view('view_frauddetection_list', $data);
}
function frauddetection_list_json()
{
$count_all = $this->frauddetection_model->get_frauddetection_list(false);
$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
$json_data = $paging_data["json_paging"];
$query = $this->frauddetection_model->get_frauddetection_list(true, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
//print_r($this->db->last_query()); die;
$grid_fields = json_decode($this->frauddetection_form->build_frauddetection_list_for_admin()); $json_data['rows'] = $this->form->build_grid($query, $grid_fields);
}
function frauddetection_add($type = "")
{
$data['username'] = $this->session->userdata('user_name');
$data['flag'] = 'create';
$data['page_title'] = gettext('Create Fraud Detection'); $data['form'] = $this->form->build_form($this->frauddetection_form->get_frauddetection_form_fields(), '');
$country_array = array(); $this->db->select('id,country,countrycode');
$country_array=$this->db->get('countrycode')->result_array();
$data['CountryListArr'] = $country_array;
$this->load->view('view_frauddetection_add_edit', $data);
}
function frauddetection_edit($edit_id = '')
{
$accountinfo = $this->session->userdata('accountinfo');
if ($accountinfo['type'] == - 1 || $accountinfo['type'] == 2) {
$data['page_title'] = gettext('Edit Fraud Detection'); 'id' => $edit_id
);
$account = $this->db_model->getSelect("*", "fraud_conf", $where);
$edit_data = $account->row_array();
$data['form'] = $this->form->build_form($this->frauddetection_form->get_frauddetection_form_fields($edit_id), $edit_data);
$data['filter'] = $edit_data['filter'];
$this->load->view('view_frauddetection_add_edit', $data);
} else {
$this->session->set_flashdata('astpp_notification', gettext('Permission Denied!')); redirect(base_url() . 'frauddetection/frauddetection_list/');
}
}
function frauddetection_save()
{
$add_array = $this->input->post();
$data['form'] = $this->form->build_form($this->frauddetection_form->get_frauddetection_form_fields($add_array['id']), $add_array);
if ($add_array['id'] != '') {
$data['page_title'] = gettext('Edit Frauddetection'); if ($this->form_validation->run() == FALSE) {
$data['validation_errors'] = validation_errors();
echo $data['validation_errors'];
} else {
$filter='';
if($add_array['filter_by'] == 'PER_COUNTRY' || $add_array['filter_by'] == 'GRP_BY_COUNTRY'){
foreach ($add_array['filter'] as $key => $value) {
$filter .= $value . ',';
}
}else{
foreach ($add_array['filter'] as $key => $value) {
$filter .= '^'. $value . '.*,';
}
}
$filter=rtrim($filter,','); $add_array['filter']=$filter;
$this->frauddetection_model->edit_frauddetection($add_array, $add_array['id']);
"SUCCESS" => $add_array["access_number"] . gettext("Frauddetection Updated Successfully!") ));
}
} else {
$data['page_title'] = gettext('frauddetection Details'); if ($this->form_validation->run() == FALSE) {
$data['validation_errors'] = validation_errors();
echo $data['validation_errors'];
} else {
$filter='';
if($add_array['filter_by'] == 'PER_COUNTRY' || $add_array['filter_by'] == 'GRP_BY_COUNTRY'){
foreach ($add_array['filter'] as $key => $value) {
$filter .= $value . ',';
}
}else{
foreach ($add_array['filter'] as $key => $value) {
$filter .= '^'. $value . '.*,';
}
}
$filter=rtrim($filter,','); $add_array['filter']=$filter;
$this->frauddetection_model->add_frauddetection($add_array);
"SUCCESS" => $add_array["access_number"] . gettext("Frauddetection Added Successfully!") ));
}
}
}
function frauddetection_list_search()
{
$ajax_search = $this->input->post('ajax_search', 0);
// echo 123122;exit;
if ($this->input->post('advance_search', TRUE) == 1) {
$this->session->set_userdata('advance_search', $this->input->post('advance_search'));
$action = $this->input->post();
// print_r($action['name']);exit;
unset($action['action']); unset($action['advance_search']); $this->session->set_userdata('frauddetection_list_search', $action);
}
if (@$ajax_search != 1) {
redirect(base_url() . 'frauddetection/frauddetection_list/');
}
}
function frauddetection_list_clearsearchfilter()
{
$this->session->set_userdata('advance_search', 0);
$this->session->set_userdata('frauddetection_list_search', "");
}
function frauddetection_remove($id)
{
$this->frauddetection_model->remove_frauddetection($id);
$this->session->set_flashdata('astpp_notification', gettext('Frauddetection Removed Successfully!')); redirect(base_url() . 'frauddetection/frauddetection_list/');
}
function frauddetection_multiple_delete()
{
$ids = $this->input->post("selected_ids", true);
$where = "id IN (" . $ids . ")";
$this->db->where($where);
echo $this->db->delete("fraud_conf");
}
/*function frauddetection_filter_by()
{
$filter_value = $_POST['filter'];
$filter_array = explode(',',$filter_value);
$filter_by = $_POST['filter_by'];
$filter = array();
if(!empty($filter_array)){
foreach($filter_array as $key => $value) {
$filter[$key] = ltrim(rtrim($value,'.*'),'^');
}
}
if($filter_by != '' ) {
if($filter_by == "PER_DST_PREFIX" || $filter_by == "GRP_BY_PREFIX" ) {
$this->db->where('status',0);
$this->db->where('id',1);
$this->db->select('pattern');
$this->db->group_by('pattern');
$accounts_arrays=$this->db->get('routes')->result_array();
foreach($accounts_arrays as $key => $accounts_array) {
$accounts[ltrim(rtrim($accounts_array['pattern'],'.*'),'^')] = ltrim(rtrim($accounts_array['pattern'],'.*'),'^');
}
$did_info = array("name" => "filter[]", "id" => "filter_value_new", "class" => "form-control");
echo form_dropdown_multiselect($did_info, $accounts, $filter);
exit;
} else {
$this->db->select('id,country');
$this->db->group_by('countrycode');
$accounts_arrays=$this->db->get('countrycode')->result_array();
$accounts = array();
foreach($accounts_arrays as $key => $accounts_array) {
$accounts[$accounts_array['id']] = $accounts_array['country'];
}
$did_info = array("name" => "filter[]", "id" => "filter_value_new", "class" => "form-control");
echo form_dropdown_multiselect($did_info, $accounts, $filter);
exit;
}
return false;
}
}*/
function frauddetection_filter_by()
{
$filter_value = $_POST['filter'];
$filter_array = explode(',',$filter_value); $filter_by = $_POST['filter_by'];
if(!empty($filter_array)){ foreach($filter_array as $key => $value) {
}
}
if($filter_by != '' ) {
if($filter_by == "PER_DST_PREFIX" || $filter_by == "GRP_BY_PREFIX" ) {
$where = array("status"=>0, "pricelist_id"=>1); $this->db->where($where);
$this->db->select("pattern");
$this->db->group_by('pattern');
$accounts_arrays=$this->db->get('routes')->result_array();
//echo "<pre>"; print_r($accounts_arrays); exit;
//echo $this->db->last_query(); exit;
/*foreach($accounts_arrays as $key => $accounts_array) {
$accounts[ltrim(rtrim($accounts_array['pattern'],'.*'),'^')] = ltrim(rtrim($accounts_array['pattern'],'.*'),'^');
}*/
$did_info = array("name" => "filter[]", "id" => "filter_value_new", "class" => "form-control"); echo $this->build_dropdown_pattern($did_info, $accounts_arrays, $filter);
} else {
$this->db->select('id,country');
//$this->db->group_by('countrycode');
$accounts_arrays=$this->db->get('countrycode')->result_array();
foreach($accounts_arrays as $key => $accounts_array) {
$accounts[$accounts_array['id']] = $accounts_array['country'];
}
//echo "<pre>"; print_r($accounts); exit;
$did_info = array("name" => "filter[]", "id" => "filter_value_new", "class" => "form-control"); echo $this->build_dropdown_pattern($did_info, $accounts, $filter,"","country");
}
return false;
}
}
function build_dropdown_pattern
($name = '', $options = array(), $selected = array(), $extra = '', $flag='') {
{
$selected = array($selected); }
//echo "<pre>"; print_r($selected); exit;
if ($extra != '') {
$extra = ' '.$extra;
}
$multiple = (count($selected) > 1 && strpos($extra, 'multiple') === FALSE) ?
' multiple="multiple"' : ''; $form = '<select name="filter[]"'." id='filter_value_new' multiple='multiple' class='orm-control selectpicker select field multiselectable col-md-12 form-control form-control-lg' data-hide-disabled='true' data-actions-box='true'>\n";
foreach ($options as $key => $val)
{
//echo "<pre>"; print_r($val); exit;
if(isset($val['pattern']) && $val['pattern'] != ""){ $key = (string)$val['pattern'];
$final_val=ltrim(rtrim($val['pattern'],'.*'),'^'); $sel = (in_array($final_val, $selected)) ?
' selected="selected"' : ''; //$final_val=ltrim(rtrim($val['pattern'],'.*'),'^');
$form .= "<option value='".$final_val."'".$sel.">".$final_val."</option>\n";
}else{
if($flag != ''){
$sel = (in_array($key, $selected)) ?
' selected="selected"' : ''; $form .= "<option value='".$val."'".$sel.">".$val."</option>\n";
}else{
$key = $val;
$sel = (in_array($key, $selected)) ?
' selected="selected"' : ''; $form .= "<option value='".$val."'".$sel.">".$val."</option>\n";
}
}
/*
$sel = (in_array($key, $selected)) ? ' selected="selected"' : '';
$final_val=ltrim(rtrim($val['pattern'],'.*'),'^');
$form .= "<option value='".$final_val."'".$sel.">".$final_val."</option>\n";
*/
}
$form .= '</select>';
return $form;
}
}
?>