SimpleDialer

SimpleDialer

This is alfa version.Simple dialer is a system for automatic dialing of subscribers using an asterisk.

• Used only by AMI
• Simple configuration
• Progressive mode
• Autoinforming mode

In future releases

• Predictive mode
• Webphone
• Realtime statistics and more

Software requirements

Asterisk:

• Asterisk 16.X

Databases that can be used:

• Postegresql 12.X
• MariaDB 10.3.X

Usage

• Install
  • Database
    • Create dialer tables
      • Сolumn description
    • Create dialer cases
• Dialer management

Install

• Create tables in database
• Configure asterisk and dialer configuration files
• Create cases for calling
• Send Get query for start

Dialer management

• A get request is used to control the dialer
• Parameters used: action and projectid where action can be start or stop

Example:http://127.0.0.1:8080/?action=start&projectid=test

Configuration files

-/config/asteriks.json

-/config/dbconfig.json 

-/config/dialer.json

-/config/http.json 

Database

Create dialer tables

• For Postgresql

  CREATE TABLE <Scheme>.dialer_clients (
  
	case_name varchar NOT NULL,
	project_id varchar NOT NULL,
	phone_number varchar NOT NULL,
	priority int8 NOT NULL DEFAULT 1,
	utc varchar NULL,
	used bool NOT NULL DEFAULT false,
	call_back bool NOT NULL DEFAULT false,
	allowed_start varchar NOT NULL DEFAULT '00:00:00'::character varying,
	allowed_stop varchar NOT NULL DEFAULT '00:00:00'::character varying,
	checked bool NOT NULL DEFAULT false,
	call_back_period varchar NULL,
	deferred_time timestamp NULL,
	deferred_done bool NOT NULL DEFAULT false,
	created timestamp NOT NULL DEFAULT now(),
	id serial NOT NULL
  
);

CREATE TABLE <Scheme>.dialer_params (
	project_id varchar NULL,
	lines int8 NULL,
	dial_time int8 NOT NULL DEFAULT 20,
	case_limit int8 NULL,
	sort varchar NULL,
	id bigserial NOT NULL,
	"type" varchar NULL,
	exten varchar NULL,
	context varchar NOT NULL DEFAULT 'default'::character varying
);

CREATE TABLE <Scheme>.dialer_stat (
	id int4 NOT NULL,
	case_name varchar NULL,
	project_id varchar NULL,
	phone_number varchar NULL,
	dial_count int4 NOT NULL DEFAULT 0,
	ended timestamp NULL,
	state varchar NULL
);

• For Mariadb

CREATE TABLE `<Scheme>.dialer_clients` (
  `case_name` varchar(100) NOT NULL,
  `project_id` varchar(100) NOT NULL,
  `phone_number` varchar(100) NOT NULL,
  `priority` int(11) DEFAULT 1,
  `utc` varchar(100) DEFAULT NULL,
  `used` tinyint(1) NOT NULL DEFAULT 0,
  `call_back` tinyint(1) DEFAULT 0,
  `allowed_start` varchar(100) NOT NULL DEFAULT '00:00:00',
  `allowed_stop` varchar(100) NOT NULL DEFAULT '00:00:00',
  `checked` tinyint(1) NOT NULL DEFAULT 0,
  `deferred_done` tinyint(1) NOT NULL DEFAULT 0,
  `call_back_period` varchar(100) DEFAULT NULL,
  `deferred_time` timestamp NULL DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8

CREATE TABLE `<Scheme>.dialer_params` (
  `project_id` varchar(100) COLLATE utf8_estonian_ci NOT NULL,
  `lines` int(11) NOT NULL DEFAULT 0,
  `dial_time` int(11) NOT NULL DEFAULT 20000,
  `case_limit` int(11) NOT NULL DEFAULT 500,
  `sort` varchar(100) COLLATE utf8_estonian_ci NOT NULL DEFAULT '2:1',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(100) COLLATE utf8_estonian_ci NOT NULL DEFAULT 'progressive',
  `exten` varchar(100) COLLATE utf8_estonian_ci NOT NULL,
  `context` varchar(100) COLLATE utf8_estonian_ci NOT NULL DEFAULT 'default',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_estonian_ci

CREATE TABLE `<Scheme>.dialer_stat` (
  `id` int(11) NOT NULL,
  `case_name` varchar(100) DEFAULT NULL,
  `project_id` varchar(100) DEFAULT NULL,
  `phone_number` varchar(100) DEFAULT NULL,
  `dial_count` int(11) NOT NULL DEFAULT 0,
  `ended` timestamp NULL DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Сolumn description

-dialer_clients

-dialer_params

-dialer_stat

Add dialer cases and params(Example)

INSERT INTO nc.dialer_clients (case_name, project_id, phone_number, priority, utc,recall, allowed_start, allowed_stop, recall_period) VALUES('Name', 'test', '1111', 1 , '+03.00h',true, '10:00:00', '18:00:00','1,1' );

INSERT INTO nc.dialer_params (project_id, lines, call_time, case_limit, type, exten, context) VALUES('test', 0, 20000, 500, 'progressive', '2222', 'default');