a2b_entity_card_multi.php

asterisk用 的voip记费软件

<?php
include ("../lib/defines.php");
include ("../lib/module.access.php");
include ("../lib/Form/Class.FormHandler.inc.php");
include ("./form_data/FG_var_card.inc");
include ("../lib/smarty.php");


if (! has_rights (ACX_CUSTOMER)){ 
	   Header ("HTTP/1.0 401 Unauthorized");
	   Header ("Location: PP_error.php?c=accessdenied");	   
	   die();	   
}

$HD_Form -> FG_FILTER_SEARCH_FORM = false;
$HD_Form -> FG_EDITION = false;
$HD_Form -> FG_DELETION = false;
$HD_Form -> FG_OTHER_BUTTON1 = false;
$HD_Form -> FG_OTHER_BUTTON2 = false;
$HD_Form -> FG_FILTER_APPLY = false;

getpost_ifset(array('choose_list', 'creditlimit', 'cardnum', 'addcredit', 'choose_tariff', 'gen_id', 'cardnum', 'choose_simultaccess', 'choose_currency', 'choose_typepaid', 'creditlimit', 'enableexpire', 'expirationdate', 'expiredays', 'runservice', 'sip', 'iax','cardnumberlenght_list'));


/***********************************************************************************/

$HD_Form -> setDBHandler (DbConnect());


// GENERATE CARDS


$nbcard = $choose_list;

if ($nbcard>0){
/*
'2465773443', '331', 'a', 't', 'LASTNAME', 'FIRSTNAME', '[e-mail]', 'adresse', 'city', 'state', 'countr', '1000', '65000000', '2465773443'
INSERT INTO card (myusername, credit, tariff, activated, lastname, firstname, email, address, city, state, 
country, zipcode, phone, userpass) values ('2465773443', '331', 'a', 't', 'LASTNAME', 'FIRSTNAME', '[e-mail]', 
'adresse', 'city', 'state', 'country', '1000', '0000000000', '2465773443')
*/
		$FG_ADITION_SECOND_ADD_TABLE  = "cc_card";		
		$FG_ADITION_SECOND_ADD_FIELDS = "username, useralias, credit, tariff, activated, lastname, firstname, email, address, city, state, country, zipcode, phone, userpass, simultaccess, currency, typepaid , creditlimit, enableexpire, expirationdate, expiredays, uipass, runservice";

		if (DB_TYPE != "postgres"){
		        $FG_ADITION_SECOND_ADD_FIELDS .= ",creationdate ";
		}
				
		$FG_TABLE_SIP_NAME="cc_sip_buddies";
		$FG_TABLE_IAX_NAME="cc_iax_buddies";
		//$FG_QUERY_ADITION_SIP_IAX_FIELDS = "name, accountcode, regexten, amaflags, callerid, context, dtmfmode, host, type, username, allow, secret";
		$FG_QUERY_ADITION_SIP_IAX_FIELDS = "name, accountcode, regexten, amaflags, callerid, context, dtmfmode, host, type, username, allow, secret, id_cc_card, nat,  qualify";
		if (isset($sip)){
			$FG_ADITION_SECOND_ADD_FIELDS .= ", sip_buddy"; 
			$instance_sip_table = new Table($FG_TABLE_SIP_NAME, $FG_QUERY_ADITION_SIP_IAX_FIELDS);
		}
		
		if (isset($iax)){
			$FG_ADITION_SECOND_ADD_FIELDS .= ", iax_buddy";	
			$instance_iax_table = new Table($FG_TABLE_IAX_NAME, $FG_QUERY_ADITION_SIP_IAX_FIELDS);
		}	
		
		if ( (isset($sip)) ||  (isset($iax)) ){
			$list_names = explode(",",$FG_QUERY_ADITION_SIP_IAX);
			$type = FRIEND_TYPE;
			$allow = FRIEND_ALLOW;
			$context = FRIEND_CONTEXT;
			$nat = FRIEND_NAT;
			$amaflags = FRIEND_AMAFLAGS;
			$qualify = FRIEND_QUALIFY;
			$host = FRIEND_HOST;   
			$dtmfmode = FRIEND_DTMFMODE;
		}	
		
		
		$instance_sub_table = new Table($FG_ADITION_SECOND_ADD_TABLE, $FG_ADITION_SECOND_ADD_FIELDS);
				
		$gen_id = time();
		$_SESSION["IDfilter"]=$gen_id;
		
		
		$creditlimit = is_numeric($creditlimit) ? $creditlimit : 0;
		//echo "::> $choose_simultaccess, $choose_currency, $choose_typepaid, $creditlimit";
		for ($k=0;$k<$nbcard;$k++){
			 $arr_card_alias = gen_card_with_alias("cc_card", 0, $cardnumberlenght_list);
			 $cardnum = $arr_card_alias[0];
			 $useralias = $arr_card_alias[1];
			if (!is_numeric($addcredit)) $addcredit=0;
			$passui_secret = MDP_NUMERIC(10);
			$FG_ADITION_SECOND_ADD_VALUE  = "'$cardnum', '$useralias', '$addcredit', '$choose_tariff', 't', '$gen_id', '', '', '', '', '', '', '', '', '$cardnum', $choose_simultaccess, '$choose_currency', $choose_typepaid, $creditlimit, $enableexpire, '$expirationdate', $expiredays, '$passui_secret', '$runservice'";
			
			
			if (DB_TYPE != "postgres") $FG_ADITION_SECOND_ADD_VALUE .= ",now() ";
					
					
			if (isset($sip)) $FG_ADITION_SECOND_ADD_VALUE .= ", 1";
			if (isset($iax)) $FG_ADITION_SECOND_ADD_VALUE .= ", 1";

			$id_cc_card = $instance_sub_table -> Add_table ($HD_Form -> DBHandle, $FG_ADITION_SECOND_ADD_VALUE, null, null, $HD_Form -> FG_TABLE_ID);
			
			// Insert data for sip_buddy
			if (isset($sip)){
				//$FG_QUERY_ADITION_SIP_IAX_VALUE = "'$cardnum', '$cardnum', '$cardnum', '$amaflag', '$cardnum', '$context', 'RFC2833','dynamic', 'friend', '$cardnum', 'g729,ulaw,alaw,gsm','".$passui_secret."'";
				$FG_QUERY_ADITION_SIP_IAX_VALUE = "'$cardnum', '$cardnum', '$cardnum', '$amaflags', '$cardnum', '$context', '$dtmfmode','$host', '$type', '$cardnum', '$allow', '".$passui_secret."', '$id_cc_card', '$nat', '$qualify'";
				$result_query1 = $instance_sip_table -> Add_table ($HD_Form ->DBHandle, $FG_QUERY_ADITION_SIP_IAX_VALUE, null, null, null);
				
				$_SESSION["is_sip_iax_change"]=1;
				$_SESSION["is_sip_changed"]=1;
			}
			// Insert data for iax_buddy
			if (isset($iax)){
				//$FG_QUERY_ADITION_SIP_IAX_VALUE = "'$cardnum', '$cardnum', '$cardnum', '$amaflag', '$cardnum', '$context', 'RFC2833','dynamic', 'friend', '$cardnum', 'g729,ulaw,alaw,gsm','".$passui_secret."'";
				$FG_QUERY_ADITION_SIP_IAX_VALUE = "'$cardnum', '$cardnum', '$cardnum', '$amaflags', '$cardnum', '$context', '$dtmfmode','$host', '$type', '$cardnum', '$allow', '".$passui_secret."', '$id_cc_card', '$nat', '$qualify'";
				$result_query2 = $instance_iax_table -> Add_table ($HD_Form ->DBHandle, $FG_QUERY_ADITION_SIP_IAX_VALUE, null, null, null);
				
				$_SESSION["is_sip_iax_change"]=1;
				$_SESSION["is_iax_changed"]=1;
			}
		}


		// Save Sip accounts to file
		if (isset($sip)){
			$buddyfile = BUDDY_SIP_FILE;

			$instance_table_friend = new Table($FG_TABLE_SIP_NAME,'id, '.$FG_QUERY_ADITION_SIP_IAX);
			$list_friend = $instance_table_friend -> Get_list ($HD_Form ->DBHandle, '', null, null, null, null);
			if (is_array($list_friend)){
				$fd=fopen($buddyfile,"w");
				if (!$fd){
					$error_msg= "</br><center><b><font color=red>".gettext("Could not open buddy file")." ". $buddyfile."</font></b></center>";
				}else{
					foreach ($list_friend as $data){
						$line="\n\n[".$data[1]."]\n";
						if (fwrite($fd, $line) === FALSE) {
							echo "Impossible to write to the file ($buddyfile)";
							break;
						}else{
							for ($i=1;$i<count($data)-1;$i++){
								if (strlen($data[$i+1])>0){
									if (trim($list_names[$i]) == 'allow'){
										$codecs = explode(",",$data[$i+1]);
										$line = "";
										foreach ($codecs as $value)
											$line .= trim($list_names[$i]).'='.$value."\n";
									} else    $line = (trim($list_names[$i]).'='.$data[$i+1]."\n");
	
									if (fwrite($fd, $line) === FALSE){
										echo gettext("Impossible to write to the file")." ($buddyfile)";
										break;
									}
								}
							}
							}
					}	
					fclose($fd);
				}
			}//end if is_array
		} // END SAVE SIP ACCOUNTS 


		// Save IAX accounts to file
		if (isset($iax)){
			$buddyfile = BUDDY_IAX_FILE;

			$instance_table_friend = new Table($FG_TABLE_IAX_NAME,'id, '.$FG_QUERY_ADITION_SIP_IAX);
			$list_friend = $instance_table_friend -> Get_list ($HD_Form ->DBHandle, '', null, null, null, null);	
			
			if (is_array($list_friend)){
				$fd=fopen($buddyfile,"w");
				if (!$fd){
					$error_msg= "</br><center><b><font color=red>".gettext("Could not open buddy file"). $buddyfile."</font></b></center>";
				}else{
					foreach ($list_friend as $data){
						$line="\n\n[".$data[1]."]\n";
						 if (fwrite($fd, $line) === FALSE) {
							echo "Impossible to write to the file ($buddyfile)";
							break;
						}else{
							for ($i=1;$i<count($data)-1;$i++){
								if (strlen($data[$i+1])>0){
									if (trim($list_names[$i]) == 'allow'){
										$codecs = explode(",",$data[$i+1]);
										$line = "";
										foreach ($codecs as $value)
											$line .= trim($list_names[$i]).'='.$value."\n";
									} else    $line = (trim($list_names[$i]).'='.$data[$i+1]."\n");
	
									if (fwrite($fd, $line) === FALSE){
										echo gettext("Impossible to write to the file")." ($buddyfile)";
										break;
									}
								}
							}
						}
					}
					fclose($fd);
				}
			}// end if is_array
		} // END SAVE IAX ACCOUNTS


}
if (!isset($_SESSION["IDfilter"])) $_SESSION["IDfilter"]='NODEFINED';