cc_var_phonelist.inc

来自「asterisk用 的voip记费软件」· INC 代码 · 共 253 行

<?php
include("CC_var_base.inc");
if (isset($id)) $old_id = $id; 

getpost_ifset(array('id', 'numbertodial', 'id_cc_campaign', 'name', 'activated', 'last_attempt', 'inuse', 'additionalinfo'));

//require (LANGUAGE_DIR.FILENAME_PREDICTIVEDIALER);

// this variable specifie the debug type (0 => nothing, 1 => sql result, 2 => boucle checking, 3 other value checking)
$FG_DEBUG = 0;


$type_access=1;

// The variable FG_TABLE_NAME define the table name to use
$FG_TABLE_NAME="cc_phonelist";

// name used to descripbe the instance of this module
$FG_INSTANCE_NAME="PhoneList";

// name used to reffer to this class, used by the link AT_var_customers.inc
$FG_CLASS_NAME="phonelist";



$actived_list = array(); $actived_list["1"]  = array( "Active", "1"); $actived_list["0"]  = array( "Inactive", "0");
$yesno_list = array(); $yesno_list["1"]  = array( "Yes", "1"); $yesno_list["0"]  = array( "No", "0");


		
// The variable Var_col would define the col that we want show in your table
// First Name of the column in the html page, second name of the field
$FG_TABLE_COL = array();



$FG_TABLE_COL[]=array (gettext("PHONENUMBER"), "numbertodial", "20%", "center", "sort", "26");
$FG_TABLE_COL[]=array (gettext("NAME"), "name", "20%", "center", "sort", "26");
$FG_TABLE_COL[]=array (gettext("LAST ATTEMPT"), "last_attempt", "15%", "center", "sort", "16", "", "", "", "", "", "display_dateformat");
$FG_TABLE_COL[]=array (gettext("CONNECTED TO"), "inuse", "10%", "center", "sort", "", "list", $yesno_list);
$FG_TABLE_COL[]=array (gettext("NUM TRIALS"), "num_trials_done", "5%", "center", "sort");
$FG_TABLE_COL[]=array (gettext("CALLED MINUTE"), "secondusedreal", "10%", "center", "SORT", "30", "", "", "", "", "", "display_minute");


// This Variable store the argument for the SQL query
$FG_COL_QUERY='numbertodial, name, last_attempt, inuse, num_trials_done, secondusedreal';


$FG_TABLE_DEFAULT_ORDER = "inuse";
$FG_TABLE_DEFAULT_SENS = "DESC, last_attempt DESC";

// Number of column in the html table
$FG_NB_TABLE_COL=count($FG_TABLE_COL);


//Clause to execute on the table
//$FG_TABLE_CLAUSE = "site_id IN (select id from site where webmaster_id='$webmaster_id')";
$FG_TABLE_CLAUSE = "";


// The variable FG_TABLE_ID define the database field to use for the deletion and edition
$FG_TABLE_ID="id";

//ADD AUTOMATICLY THE ID TO YOUR SELECTED FIELDS
$FG_COL_QUERY.=", $FG_TABLE_ID";



// The variable  Where the edition will target (link)
$FG_EDITION_LINK="CC_entity_edit_phonelist.php?form_action=ask-edit&atmenu=$FG_CLASS_NAME&id=";

$FG_EDITION=false;

// The variable  Where the edition will target (link)
$FG_DELETION_LINK="CC_entity_edit_phonelist.php?form_action=ask-delete&atmenu=$FG_CLASS_NAME&id=";

// The variable  would define we want process to the deletion of this record
$FG_DELETION=false;



// The variable LIMITE_DISPLAY define the limit of record to display by page
$FG_LIMITE_DISPLAY=10;


// The variable  would define if you want have a link for the insert page in the view/edit page
$FG_LINK_ADD=false;

// The variable  Where the edition will target (link)
$FG_INSERT_LINK="P2E_entity_edit.php?form_action=ask-add&atmenu=$FG_CLASS_NAME";


// The variable  would define if you want use a search engine in this module
$FG_SEARCH_ENGINE=false;




//This variable will store the total number of column
$FG_TOTAL_TABLE_COL = $FG_NB_TABLE_COL;
if ($FG_DELETION || $FG_EDITION) $FG_TOTAL_TABLE_COL++;


//This variable define the Title of the HTML table
$FG_HTML_TABLE_TITLE=gettext("- PHONELIST List -");


//This variable define a text that you should put over the table list.
//To introduce the module working and utility ;)
$FG_INTRO_TEXT = gettext("You can browse through our ".$FG_INSTANCE_NAME." and modify their different properties<br>");


// TEXT
$FG_DELETE_ALT = gettext("Delete this ".$FG_INSTANCE_NAME);
$FG_EDIT_ALT = gettext("Edit this ".$FG_INSTANCE_NAME);



///////////////////////////////////////////////////////////////////////
//		   INFORMATION ABOUT THE EDITION		     //
///////////////////////////////////////////////////////////////////////


// THE VARIABLE $FG_TABLE_EDITION WOULD DEFINE THE COL THAT WE WANT SHOW IN YOUR EDITION TABLE 
// 0. NAME OF THE COLUMN IN THE HTML PAGE, 
// 1. NAME OF THE FIELD
// 2. VALUE OF THE FIELD
// 3. THE TYPE OF THE FIELD (INPUT/SELECT/TEXTAREA)
	// 4. THE PROPERTY OF THIS FIELD
	// 5. REGEXPRES TO CHECK THE VALUE
	//    "^.{3}$": A STRING WITH EXACTLY 3 CHARACTERS. 
	//     ^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*$  : EMAIL ADRESSE
	// 6. ERROR MASSAGE

// 7.  IF THE FIELD TYPE IS A SELECT,  DEFINE LIST OR SQL
// 8.  IF SQL,		THE TABLE NAME
// 9. IF SQL,		THE FIELDS  : Three MAXIMUM IN ORDER (NAME, VALUE, ...other that we need for the display) ;)
// 10. IF SQL,		THE CLAUSE
// 11. IF LIST,		THE NAME OF THE LIST
// 12. IF LIST,		DISPLAY : %1 : (%2)


$FG_TABLE_EDITION = array ();
$FG_TABLE_COMMENT = array ();


    

$FG_TABLE_EDITION[]=array (gettext("Phone Number"),
			   "numbertodial",		
			   '$value',	
			   "INPUT",	
			   "size=30 maxlength=40",	
			   "0",	
			   gettext("Insert the phonenumber"),
			   "" , "", "",	"", "" );
$FG_TABLE_COMMENT[]= gettext("Enter here the phonenumber you want to call");


$FG_TABLE_EDITION[]=array (gettext("CAMPAIGN"),
			   "id_cc_campaign",
			   '$value',	
			   "SELECT",	
			   "", "", "",	
			   "sql",		
			   "cc_campaign",	
			   "campaign_name, id",		
			   "", "", "%1");
			   
$FG_TABLE_COMMENT[]= "";


$FG_TABLE_EDITION[]=array (gettext("NAME"),
			   "name",		
			   '$value',	
			   "INPUT",	
			   "size=30 maxlength=20",	
			   "",	
			   gettext("Insert the name "),
			   "" , "", "",	"", "" );
$FG_TABLE_COMMENT[]= "";




if ($form_action=="ask-add"){	
	$begin_date = date("Y");
	$begin_date_plus = date("Y")+25;	
	$end_date = date("-m-d H:i:s");
	$comp_date = "value='".$begin_date.$end_date."'";
	$comp_date_plus = "value='".$begin_date_plus.$end_date."'";
}

$FG_TABLE_EDITION[]=array (gettext("LAST ATTEMPT DATE"),
			   "last_attempt",		
			   '$value',	
			   "INPUT",	
			   "size=40 maxlength=40  $comp_date",	
			   "10",	
			   gettext("Insert the last attempt date"),
			   "" , "", "",	"", "", "", "", "res_display_dateformat" ); // , "", "res_display_dateformat"
$FG_TABLE_COMMENT[]= gettext("please respect the format YYYY-MM-DD HH:MM:SS. For instance, '2004-12-31 00:00:00'");




$FG_TABLE_EDITION[]=array (gettext("ENABLE"),
				   "enable",		
				   't',
				   "RADIOBUTTON",	
				   "",	
				   "",	
				   gettext("Choose if this phonenumber would be enable or not"),
				   "" , "", "Yes :1, - No:0",	"", "" );
$FG_TABLE_COMMENT[]= "";



$FG_TABLE_EDITION[]=array (gettext("ADDITIONALINFO"),
			   "additionalinfo",		
			   '',	
			   "TEXTAREA",	
			   "cols=50 rows=4",
			   "",	
			   gettext("Insert additional information"),
			   "" , "", "",	"", "" );
$FG_TABLE_COMMENT[]= "";


if ($form_action!="ask-add" && $form_action!="add"){	

$FG_TABLE_EDITION[]=array (gettext("INUSE"),
				   "inuse",		
				   't',
				   "RADIOBUTTON",	
				   "",	
				   "",	
				   gettext("Choose the status of this phonenumber"),
				   "" , "", "In use :1, - Not in use :0",	"", "" );
$FG_TABLE_COMMENT[]= "";

}


// 0 : nom de la table qui fait le liens entre les deux
// 1 : foreign key
// 2 : external table name which with we do the link
// 3 :				the field of this table which will appear
// 4 : sql to select all the instance of this external table correspong to the id of the current table
//
// 6 : how to display in the select form

// 7 : si on a encore une cl