PageRenderTime 55ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 0ms

/A2BCustomer_UI/CC_entity_edit_speeddial.php

https://github.com/xrg/a2billing
PHP | 1063 lines | 886 code | 170 blank | 7 comment | 158 complexity | 8da2de483dfe6459571bd4de68f654c1 MD5 | raw file
Possible License(s): AGPL-1.0 
    

  1. <?php
    2. 

  2. include ("lib/defines.php");
    3. 

  3. include ("lib/module.access.php");
    4. 

  4. //require (LANGUAGE_DIR.FILENAME_EDIT_SPEEDDIAL);
    5. 

  5. include ("frontoffice_data/CC_var_speeddial.inc");
    6. 

  6. include ("lib/regular_express.inc");
    7. 

  7. 

  8. 

  9. if (! has_rights (ACX_ACCESS)){ 
    10. 

  10. 	   Header ("HTTP/1.0 401 Unauthorized");
    11. 

  11. 	   Header ("Location: PP_error.php?c=accessdenied");	   
    12. 

  12. 	   die();	   
    13. 

  13. }
    14. 

  14. 

  15. 

  16. if (!$A2B->config["webcustomerui"]['speeddial']) exit();
    17. 

  17. 

  18. $FG_DEBUG = 0;
    19. 

  19. 

  20. 

  21. if ( (!isset ($id) || (is_numeric($id)  == "")) && ( $form_action != "ask-add" && $form_action != "add") ){	
    22. 

  22. 		exit ("<center><b>Error : ID <br> ($PHP_SELF)</b>");
    23. 

  23. 	}
    24. 

  24. 

  25. $VALID_SQL_REG_EXP = true;
    26. 

  26. 

  27. $DBHandle  = DbConnect();
    28. 

  28. 

  29. 

  30. $instance_table = new Table($FG_TABLE_NAME, $FG_QUERY_EDITION);
    31. 

  31. if ($id!="" || !is_null($id)){
    32. 

  32. 	$FG_EDITION_CLAUSE = str_replace("%id", "$id", $FG_EDITION_CLAUSE);
    33. 

  33. }
    34. 

  34. 

  35. 

  36. 

  37. if ($form_action == "edit"){
    38. 

  38. 

  39. 	for($i=0;$i<$FG_NB_TABLE_EDITION;$i++){ 
    40. 

  40. 		
    41. 

  41. 		$pos = strpos($FG_TABLE_EDITION[$i][1], ":");		
    42. 

  42. 		if (!$pos){
    43. 

  43. 		
    44. 

  44. 				$fields_name = $FG_TABLE_EDITION[$i][1];								
    45. 

  45. 

  46. 				$regexp = $FG_TABLE_EDITION[$i][5];
    47. 

  47. 				
    48. 

  48. 				if (is_numeric($regexp) && !($FG_TABLE_ADITION[$i][12]=="no" && $$fields_name=="") ){									
    49. 

  49. 					$fit_expression[$i] = ereg( $regular[$regexp][0] , $$fields_name);
    50. 

  50. 					if ($FG_DEBUG == 1)  echo "<br>->  ".$regular[$regexp][0]." , ".$$fields_name;
    51. 

  51. 					if (!$fit_expression[$i]){
    52. 

  52. 						$VALID_SQL_REG_EXP = false;
    53. 

  53. 						$form_action="ask-edit";						
    54. 

  54. 					}
    55. 

  55. 				}
    56. 

  56. 				
    57. 

  57. 				if ($FG_DEBUG == 1) echo "<br>$fields_name : ".$$fields_name;
    58. 

  58. 				if ($i>0) $param_update .= ", ";				
    59. 

  59. 				$param_update .= $sp . "$fields_name".$sp." = '".addslashes(trim($$fields_name))."'";
    60. 

  60. 

  61. 		}
    62. 

  62. 		
    63. 

  63. 	}
    64. 

  64. 	if ($FG_DEBUG == 1)  echo "<br><hr> $param_update";	
    65. 

  65. 	
    66. 

  66. 	
    67. 

  67. 	if ($VALID_SQL_REG_EXP) $instance_table -> Update_table ($DBHandle, $param_update, $FG_EDITION_CLAUSE, $func_table = null);
    68. 

  68. 		
    69. 

  69. 	if ( ($VALID_SQL_REG_EXP) && (isset($FG_GO_LINK_AFTER_ACTION))){
    70. 

  70. 		Header ("Location: $FG_GO_LINK_AFTER_ACTION".$id);
    71. 

  71. 	}
    72. 

  72. 	
    73. 

  73. }
    74. 

  74. 

  75. 

  76. if ($form_action == "delete"){
    77. 

  77. 	
    78. 

  78. 		
    79. 

  79. 	$res_delete = $instance_table -> Delete_table ($DBHandle, $FG_EDITION_CLAUSE, $func_table = null);
    80. 

  80. 	if (!$res_delete){  echo "error deletion";
    81. 

  81. 	}else{
    82. 

  82. 		  
    83. 

  83. 		  
    84. 

  84. 	}
    85. 

  85. 	
    86. 

  86. 	$FG_INTRO_TEXT_DELETION = str_replace("%id", "$id", $FG_INTRO_TEXT_DELETION);
    87. 

  87. 	$FG_INTRO_TEXT_DELETION = str_replace("%table", "$FG_TABLE_NAME", $FG_INTRO_TEXT_DELETION);
    88. 

  88. 	
    89. 

  89. 	if (isset($FG_GO_LINK_AFTER_ACTION)){
    90. 

  90. 		Header ("Location: $FG_GO_LINK_AFTER_ACTION_DELETE".$id);
    91. 

  91. 	}
    92. 

  92. 	
    93. 

  93. }
    94. 

  94. 

  95. if ( $form_action == "edit" || $form_action == "ask-delete" || $form_action == "ask-edit" || $form_action == "add-content" || $form_action == "del-content" ){
    96. 

  96. 	
    97. 

  97. 	if ($FG_DEBUG >= 2) { echo "FG_EDITION_CLAUSE:$FG_EDITION_CLAUSE"; }
    98. 

  98. 	$list = $instance_table -> Get_list ($DBHandle, $FG_EDITION_CLAUSE, null, null, null, null, 1, 0);
    99. 

  99. 	if ($FG_DEBUG >= 2) { echo "<br>"; print_r ($list);}
    100. 

  100. 	
    101. 

  101. }
    102. 

  102. ?>
    103. 

  103. 

  104. <?php
    105. 

  105. 	include("PP_header.php");
    106. 

  106. ?>
    107. 

  107. <script language="JavaScript" type="text/JavaScript">
    108. 

  108. <!--
    109. 

  109. function MM_openBrWindow(theURL,winName,features) { //v2.0
    110. 

  110.   window.open(theURL,winName,features);
    111. 

  111. }
    112. 

  112. 

  113. function sendto(action, record, field_inst, instance){
    114. 

  114.   document.myForm.form_action.value = action;
    115. 

  115.   document.myForm.sub_action.value = record;
    116. 

  116.   if (field_inst != null) document.myForm.elements[field_inst].value = instance;
    117. 

  117.   myForm.submit();
    118. 

  118. }
    119. 

  119. 

  120. function sendtolittle(direction){
    121. 

  121.   myForm.action=direction;
    122. 

  122.   myForm.submit();
    123. 

  123. 

  124. }
    125. 

  125. 

  126. //-->
    127. 

  127. </script>
    128. 

  128. 

  129.           
    130. 

  130. <?php
    131. 

  131. 	echo $CC_help_speeddial;
    132. 

  132. ?>
    133. 

  133. 	  <?php if ($form_action=="ask-edit" || $form_action=="edit" || $form_action == "add-content" || $form_action == "del-content"){ ?>
    134. 

  134. 	  
    135. 

  135.       <blockquote>
    136. 

  136.         <div align="center"><b>
    137. 

  137. 		  <?php  if ($FG_ADITION_GO_EDITION == "yes-done") echo '<font color="#FF0000">'.$FG_ADITION_GO_EDITION_MESSAGE.'</font><br><br>'; ?>
    138. 

  138.           <?php  if ($alarm_db_error_duplication){ 
    139. 

  139. 		  			echo '<font color="#FF0000">'.$FG_TEXT_ERROR_DUPLICATION.'</font>';
    140. 

  140. 			 }else{	
    141. 

  141. 			 		//echo $FG_INTRO_TEXT_EDITION;
    142. 

  142. 			 }
    143. 

  143. 		  ?>
    144. 

  144.           </b></div>
    145. 

  145. </blockquote>      
    146. 

  146. 

  147.     		
    148. 

  148. 			<TABLE width="95%" border=0 align="center" cellPadding=2 cellSpacing=2>
    149. 

  149.                 <FORM action=<?php echo $PHP_SELF?> method=post name="myForm"> 
    150. 

  150.                   <INPUT type="hidden" name="id" value="<?php echo $id?>">
    151. 

  151.                   <INPUT type="hidden" name="form_action" value="edit">
    152. 

  152. 				  <INPUT type="hidden" name="sub_action" value="">
    153. 

  153.                   <INPUT type="hidden" name="atmenu" value="<?php echo $atmenu?>">
    154. 

  154. 				  <INPUT type="hidden" name="stitle" value="<?php echo $stitle?>">	
    155. 

  155. 				  <?php
    156. 

  156. 						if (!is_null($FG_QUERY_ADITION_HIDDEN_FIELDS) && $FG_QUERY_ADITION_HIDDEN_FIELDS!=""){
    157. 

  157. 							
    158. 

  158. 							$split_hidden_fields = split(",",trim($FG_QUERY_ADITION_HIDDEN_FIELDS));
    159. 

  159. 							$split_hidden_fields_value = split(",",trim($FG_QUERY_ADITION_HIDDEN_VALUE));
    160. 

  160. 

  161. 							for ($cur_hidden=0;$cur_hidden<count($split_hidden_fields);$cur_hidden++){
    162. 

  162. 									echo "<INPUT class=\"form_enter\" type=\"hidden\" name=\"".trim($split_hidden_fields[$cur_hidden])."\" value=\"".trim($split_hidden_fields_value[$cur_hidden])."\">\n";
    163. 

  163. 							}
    164. 

  164. 							
    165. 

  165. 						}
    166. 

  166. 					?>			  
    167. 

  167.                   <TBODY>
    168. 

  168.                     <?php for($i=0;$i<$FG_NB_TABLE_EDITION;$i++){ 
    169. 

  169. 						$pos = strpos($FG_TABLE_EDITION[$i][1], ":");
    170. 

  170. 						
    171. 

  171. 						
    172. 

  172. 						if (!$pos){
    173. 

  173. 

  174. 					?>
    175. 

  175.                     <TR> 
    176. 

  176. 					
    177. 

  177.                       <TD width="%25" valign="top" class="form_head"><strong><?php echo $FG_TABLE_EDITION[$i][0]?></strong></TD>
    178. 

  178. 					  
    179. 

  179.                       <TD width="%75" valign="top" class="tableBodyRight" bgcolor="#CCCCCC">
    180. 

  180.                         <?php 
    181. 

  181. 								if ($FG_DEBUG == 1) print($FG_TABLE_EDITION[$i][3]);
    182. 

  182. 						  		if (strtoupper ($FG_TABLE_EDITION[$i][3])==strtoupper ("INPUT"))
    183. 

  183. 								{								
    184. 

  184. 						  ?>
    185. 

  185.                         <INPUT class="form_enter" name=<?php echo $FG_TABLE_EDITION[$i][1]?>  <?php echo $FG_TABLE_EDITION[$i][4]?> value="<?php if($VALID_SQL_REG_EXP){ echo stripslashes($list[0][$i]); }else{ echo $$FG_TABLE_EDITION[$i][1]; }?>"> 
    186. 

  186. 						<?php 
    187. 

  187. 						  		}elseif (strtoupper ($FG_TABLE_EDITION[$i][3])==strtoupper ("POPUPVALUE"))
    188. 

  188. 								{								
    189. 

  189. 						  ?>
    190. 

  190.                         <INPUT class="form_enter" name=<?php echo $FG_TABLE_EDITION[$i][1]?>  <?php echo $FG_TABLE_EDITION[$i][4]?> value="<?php if($VALID_SQL_REG_EXP){ echo stripslashes($list[0][$i]); }else{ echo $$FG_TABLE_ADITION[$i][1]; }?>"> 
    191. 

  191. 						<a href="#" onclick="window.open('<?php echo $FG_TABLE_EDITION[$i][14]?>popup_formname=myForm&popup_fieldname=<?php echo $FG_TABLE_EDITION[$i][1]?>' <?php echo $FG_TABLE_EDITION[$i][15]?>);"><img src="images/icon_arrow_orange.gif"/></a>
    192. 

  192. 						
    193. 

  193.                         <?php 
    194. 

  194. 						  		}elseif (strtoupper ($FG_TABLE_EDITION[$i][3])==strtoupper ("TEXTAREA"))
    195. 

  195. 								{
    196. 

  196. 						  ?>
    197. 

  197.                         <textarea name=<?php echo $FG_TABLE_EDITION[$i][1]?>  <?php echo $FG_TABLE_EDITION[$i][4]?>><?php if($VALID_SQL_REG_EXP){ echo stripslashes($list[0][$i]); }else{ echo $$FG_TABLE_ADITION[$i][1]; }?></textarea> 
    198. 

  198.                         <?php 	
    199. 

  199. 								}elseif (strtoupper ($FG_TABLE_EDITION[$i][3])==strtoupper ("SELECT"))
    200. 

  200. 								{
    201. 

  201. 								
    202. 

  202. 										if ($FG_DEBUG == 1) 
    203. 

  203. 										{ echo "<br> TYPE DE SELECT :".$FG_TABLE_EDITION[$i][7];
    204. 

  204. 										}
    205. 

  205. 											
    206. 

  206. 										if (strtoupper ($FG_TABLE_EDITION[$i][7])==strtoupper ("SQL"))
    207. 

  207. 										{
    208. 

  208. 																					
    209. 

  209. 												$instance_sub_table = new Table($FG_TABLE_EDITION[$i][8], $FG_TABLE_EDITION[$i][9]);
    210. 

  210. 												$select_list = $instance_sub_table -> Get_list ($DBHandle, $FG_TABLE_EDITION[$i][10], null, null, null, null, null, null);
    211. 

  211. 												
    212. 

  212. 												if ($FG_DEBUG >= 2) { echo "<br>"; print_r($select_list);}
    213. 

  213. 											
    214. 

  214. 										 }elseif (strtoupper ($FG_TABLE_EDITION[$i][7])==strtoupper ("LIST"))
    215. 

  215. 										 {
    216. 

  216. 												
    217. 

  217. 												$select_list = $FG_TABLE_EDITION[$i][11];
    218. 

  218. 												if ($FG_DEBUG >= 2) { echo "<br>"; print_r($select_list);}
    219. 

  219. 												//$select_list_nb = count($select_list);
    220. 

  220. 										 }
    221. 

  221. 						  if ($FG_DEBUG >= 2) print_r ($list);			 
    222. 

  222. 						  if ($FG_DEBUG >= 2) echo "<br>#$i<br>::>".$VALID_SQL_REG_EXP;
    223. 

  223. 						  if ($FG_DEBUG >= 2) echo "<br><br>::>".$list[0][$i];
    224. 

  224. 						  if ($FG_DEBUG >= 2) echo "<br><br>::>".$$FG_TABLE_ADITION[$i][1];											
    225. 

  225. 						  ?>
    226. 

  226.                         
    227. 

  227. 						<SELECT name=<?php echo $FG_TABLE_EDITION[$i][1]?> class="form_enter">
    228. 

  228. 						<?php echo $FG_TABLE_EDITION[$i][15]?>
    229. 

  229.                           <?php
    230. 

  230. 										 if (count($select_list)>0)
    231. 

  231. 										 {
    232. 

  232. 												 $select_number=0;
    233. 

  233. 												 
    234. 

  234. 												 foreach ($select_list as $select_recordset){ 
    235. 

  235. 													 $select_number++;
    236. 

  236. 						  
    237. 

  237. 							  ?>
    238. 

  238.                           <OPTION  value=<?php echo $select_recordset[1]?> <?php 
    239. 

  239. 						  
    240. 

  240. 						  
    241. 

  241. 						  if($VALID_SQL_REG_EXP){ if (strcmp($list[0][$i],$select_recordset[1])==0){ echo "selected"; } }else{ if (strcmp($$FG_TABLE_ADITION[$i][1],$select_recordset[1])==0){ echo "selected"; } }
    242. 

  242. 						   ?>>
    243. 

  243. 						   <?php 						   
    244. 

  244. 						   		if ($FG_TABLE_EDITION[$i][12] != ""){
    245. 

  245. 				
    246. 

  246. 							   		$value_display = $FG_TABLE_EDITION[$i][12];
    247. 

  247. 									$nb_recor_k = count($select_recordset);
    248. 

  248. 																		
    249. 

  249. 									for ($k=1;$k<=$nb_recor_k;$k++){
    250. 

  250. 														$value_display  = str_replace("%$k", $select_recordset[$k-1], $value_display );
    251. 

  251. 									}
    252. 

  252. 									
    253. 

  253. 								}else{
    254. 

  254. 									$value_display = $select_recordset[0];								
    255. 

  255. 								}
    256. 

  256. 							?>
    257. 

  257.                           <?php echo $value_display ?>
    258. 

  258.                           </OPTION>
    259. 

  259.                           <?php 
    260. 

  260. 												 }// END_FOREACH
    261. 

  261. 										  }else{
    262. 

  262. 													echo gettext("No data found !!!");
    263. 

  263. 										  }//END_IF				
    264. 

  264. 							  ?>
    265. 

  265.                         </SELECT>
    266. 

  266.                         <?php     }elseif (strtoupper ($FG_TABLE_EDITION[$i][3])==strtoupper ("RADIOBUTTON")){
    267. 

  267. 								
    268. 

  268. 										 
    269. 

  269. 												$radio_table = split(",",trim($FG_TABLE_EDITION[$i][9]));
    270. 

  270. 												
    271. 

  271. 												foreach ($radio_table as $radio_instance){
    272. 

  272. 													$radio_composant = split(":",$radio_instance);																								
    273. 

  273. 													echo $radio_composant[0];
    274. 

  274. 													echo ' <input class="form_enter" type="radio" name="'.$FG_TABLE_EDITION[$i][1].'" value="'.$radio_composant[1].'" ';
    275. 

  275. 													
    276. 

  276. 													if($VALID_SQL_REG_EXP){ 
    277. 

  277. 														$know_is_checked = stripslashes($list[0][$i]); 
    278. 

  278. 													}else{ 
    279. 

  279. 														$know_is_checked = $$FG_TABLE_EDITION[$i][1]; 
    280. 

  280. 													}
    281. 

  281. 													
    282. 

  282. 													if ($know_is_checked==$radio_composant[1]){
    283. 

  283. 														echo "checked";
    284. 

  284. 													}
    285. 

  285. 													echo ">";
    286. 

  286. 													
    287. 

  287. 												}								
    288. 

  288. 						
    289. 

  289.                                }//END_IF (RADIOBUTTON)  
    290. 

  290. 							   
    291. 

  291. 						  ?>
    292. 

  292.                         <span class="liens"> 
    293. 

  293.                         <?php 						
    294. 

  294. 							if (!$fit_expression[$i]  &&  isset($fit_expression[$i]) ){
    295. 

  295. 							
    296. 

  296. 								echo "<br>".$FG_TABLE_EDITION[$i][6]." - ".$regular[$FG_TABLE_EDITION[$i][5]][1];								
    297. 

  297. 							}
    298. 

  298. 							   
    299. 

  299. 						  ?>
    300. 

  300.                         </span><br>
    301. 

  301.                         <?php  echo $FG_TABLE_COMMENT[$i];?>
    302. 

  302.                         &nbsp; </TD>
    303. 

  303.                     </TR>
    304. 

  304.                     <?php 					
    305. 

  305. 							}else{
    306. 

  306. 								
    307. 

  307. 							  if (strtoupper ($FG_TABLE_EDITION[$i][3])==strtoupper ("SELECT"))
    308. 

  308. 							  {
    309. 

  309. 								$table_split = split(":",$FG_TABLE_EDITION[$i][1]);								
    310. 

  310. 						
    311. 

  311. 					?>
    312. 

  312.                     <TR> 
    313. 

  313. 					  <!-- ******************** PARTIE EXTERN : SELECT ***************** -->
    314. 

  314.                       <TD width="122" class="form_head"><?php echo $FG_TABLE_EDITION[$i][0]?></TD>
    315. 

  315. 					  
    316. 

  316.                      <TD align="center" valign="top" class="tableBodyRight" bgcolor="#CCCCCC"><br>
    317. 

  317.                          
    318. 

  318. 						 <!-- Table with list instance already inserted -->
    319. 

  319.                         <table width="300" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#EDF3FF">
    320. 

  320.                           <TR bgcolor="#ffffff"> 
    321. 

  321.                             <TD height=16 style="PADDING-LEFT: 5px; PADDING-RIGHT: 3px" class="form_head"> 
    322. 

  322.                               <TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
    323. 

  323.                                 <TBODY>
    324. 

  324.                                   <TR> 
    325. 

  325.                                     <TD class="form_head"><?php echo $FG_TABLE_EDITION[$i][0]?> LIST </TD>                                    
    326. 

  326.                                   </TR>
    327. 

  327.                                 </TBODY>
    328. 

  328.                               </TABLE></TD>
    329. 

  329.                           </TR>
    330. 

  330.                           <TR> 
    331. 

  331.                             <TD> <TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
    332. 

  332.                                 <TBODY>
    333. 

  333.                                   <TR> 
    334. 

  334.                                     <TD bgColor=#e1e1e1 colSpan=<?php echo $FG_TOTAL_TABLE_COL?> height=1><IMG height=1 src="images/clear.gif" width=1></TD>
    335. 

  335.                                   </TR>
    336. 

  336.                                   <?php 
    337. 

  337. 			$SPLIT_CLAUSE = str_replace("%id", "$id", $table_split[4]);
    338. 

  338. 			$SPLIT_CLAUSE2 = str_replace("%id", "$id", $table_split[12]);
    339. 

  339. 		
    340. 

  340. 			$instance_sub_table = new Table($table_split[2], $table_split[3]);
    341. 

  341. 			$split_select_list = $instance_sub_table -> Get_list ($DBHandle, $SPLIT_CLAUSE, null, null, null, null, null, null);			
    342. 

  342. 			
    343. 

  343. 	if (!is_array($split_select_list)){	
    344. 

  344. 		$num=0;
    345. 

  345. 	}else{	
    346. 

  346. 		$num = count($split_select_list);
    347. 

  347. 	}
    348. 

  348. 	
    349. 

  349. 	
    350. 

  350. 	
    351. 

  351. 	if($num>0)
    352. 

  352. 	{	
    353. 

  353. 	for($j=0;$j<$num;$j++)
    354. 

  354. 	  {
    355. 

  355. 			if (is_numeric($table_split[7])){
    356. 

  356. 					$instance_sub_sub_table = new Table($table_split[8], $table_split[9]);
    357. 

  357. 					$SUB_TABLE_SPLIT_CLAUSE = str_replace("%1", $split_select_list[$j][$table_split[7]], $table_split[11] );
    358. 

  358. 					$sub_table_split_select_list = $instance_sub_sub_table -> Get_list ($DBHandle, $SUB_TABLE_SPLIT_CLAUSE, null, null, null, null, null, null);
    359. 

  359. 					$split_select_list[$j][$table_split[7]] = $sub_table_split_select_list[0][0];
    360. 

  360. 			}	
    361. 

  361. 			
    362. 

  362. 	?>
    363. 

  363.                                   <TR bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$j%2]?>"  onMouseOver="bgColor='#C4FFD7'" onMouseOut="bgColor='<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$j%2]?>'"> 
    364. 

  364.                                     <TD vAlign=top align="<?php echo $FG_TABLE_COL[$i][3]?>" class=tableBody> 
    365. 

  365.                                       <font face="Verdana" size="2">
    366. 

  366.                                       <b><?php echo $split_select_list[$j][$table_split[7]]?></b> : <?php echo $split_select_list[$j][0]?>
    367. 

  367.                                       </font> </TD>
    368. 

  368.                                     <TD align="center" vAlign=top class=tableBodyRight> 
    369. 

  369.                                       <input onClick="sendto('del-content','<?php echo $i?>','<?php echo $table_split[1]?>','<?php echo $split_select_list[$j][1]?>');" alt="Remove this <?php echo $FG_TABLE_EDITION[$i][0]?>" border=0 height=11 hspace=2 id=submit33 name=submit33 src="images/icon-del.gif" type=image width=33 value="add-split"> 
    370. 

  370.                                     </TD>
    371. 

  371.                                   </TR>
    372. 

  372.                                   <?php 
    373. 

  373. 	  }//end_for
    374. 

  374. 	}else{
    375. 

  375. 			?>
    376. 

  376.                                   <TR bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$j%2]?>"  onMouseOver="bgColor='#C4FFD7'" onMouseOut="bgColor='<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$j%2]?>'"> 
    377. 

  377.                                     <TD colspan="2" align="<?php echo $FG_TABLE_COL[$i][3]?>" vAlign=top class=tableBody> 
    378. 

  378.                                       <div align="center" class="liens">No <?php echo $FG_TABLE_EDITION[$i][0]?></div></TD>
    379. 

  379.                                   </TR>
    380. 

  380.                                   <?php 
    381. 

  381. 	}
    382. 

  382. 	?>
    383. 

  383.                                   <TR> 
    384. 

  384.                                     <TD class=tableDivider colSpan=<?php echo $FG_TOTAL_TABLE_COL?>><IMG height=1 src="images/clear.gif" width=1></TD>
    385. 

  385.                                   </TR>
    386. 

  386.                                 </TBODY>
    387. 

  387.                               </TABLE></td>
    388. 

  388.                           </tr>
    389. 

  389.                           <TR bgcolor="#ffffff"> 
    390. 

  390.                             <TD bgcolor="#AAAAAA"  height=16 style="PADDING-LEFT: 5px; PADDING-RIGHT: 3px"> 
    391. 

  391.                               <TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
    392. 

  392.                                 <TBODY>
    393. 

  393.                                   <TR> 
    394. 

  394.                                     <TD height="4" align="right"></TD>
    395. 

  395.                                 </TBODY>
    396. 

  396.                               </TABLE></TD>
    397. 

  397.                           </TR>
    398. 

  398.                         </table><br>
    399. 

  399. </TD>
    400. 

  400.                     </TR>
    401. 

  401. 					<?php
    402. 

  402. 						$split_select_list = $instance_sub_table -> Get_list ($DBHandle, $SPLIT_CLAUSE2, null, null, null, null, null, null);
    403. 

  403. 						if (count($split_select_list)>0){
    404. 

  404. 					?>
    405. 

  405.                     <TR>
    406. 

  406. 					  <!-- *******************   Select to ADD new instances  ****************************** -->					  
    407. 

  407.                       <TD class="form_head">&nbsp;</TD>
    408. 

  408.                       <TD align="center" valign="top" bgcolor="#CCCCCC" class="tableBodyRight"><br>
    409. 

  409.                         <TABLE width="300" height=50 border=0 align="center" cellPadding=0 cellSpacing=0>
    410. 

  410. <TBODY>
    411. 

  411.                             <TR> 
    412. 

  412.                               <TD bgColor=#7f99cc colSpan=3 height=16 style="PADDING-LEFT: 5px; PADDING-RIGHT: 5px" class="form_head">
    413. 

  413.                                 <TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
    414. 

  414.                                   <TBODY>
    415. 

  415.                                     <TR> 
    416. 

  416.                                       <TD class="form_head"> <?php echo gettext("Add a new")?>&nbsp; <?php echo $FG_TABLE_EDITION[$i][0]?></TD>                                      
    417. 

  417.                                     </TR>
    418. 

  418.                                   </TBODY>
    419. 

  419.                                 </TABLE></TD>
    420. 

  420.                             </TR>
    421. 

  421.                             <TR> 
    422. 

  422.                               <TD class="form_head"> <IMG height=1 src="images/clear.gif" width=1> 
    423. 

  423.                               </TD>
    424. 

  424.                               <TD bgColor=#F3F3F3 style="PADDING-BOTTOM: 7px; PADDING-LEFT: 5px; PADDING-RIGHT: 5px; PADDING-TOP: 5px"> 
    425. 

  425.                                 
    426. 

  426. 								<TABLE width="97%" border=0 align="center" cellPadding=0 cellSpacing=0>
    427. 

  427. 								
    428. 

  428.                                   <TBODY>
    429. 

  429.                                     <TR> 
    430. 

  430.                                       <TD width="122" class="tableBody"><?php echo $FG_TABLE_EDITION[$i][0]?></TD>
    431. 

  431.                                       <TD width="516"><div align="center"> 
    432. 

  432. 									  
    433. 

  433.                                           <SELECT name=<?php echo $table_split[1]?> class="form_enter">
    434. 

  434.                                             <?php
    435. 

  435. 										 
    436. 

  436. 										 
    437. 

  437. 										 if (count($split_select_list)>0)
    438. 

  438. 										 {
    439. 

  439. 												 $select_number=0;
    440. 

  440. 						 
    441. 

  441. 												 foreach ($split_select_list as $select_recordset){ 
    442. 

  442. 													 $select_number++;
    443. 

  443. 													 
    444. 

  444. 													 if ($table_split[6]!="" && !is_null($table_split[6])){
    445. 

  445. 													 
    446. 

  446. 													 		if (is_numeric($table_split[7])){
    447. 

  447. 																
    448. 

  448. 																$instance_sub_sub_table = new Table($table_split[8], $table_split[9]);
    449. 

  449. 																
    450. 

  450. 																$SUB_TABLE_SPLIT_CLAUSE = str_replace("%1", $select_recordset[$table_split[7]], $table_split[11] );
    451. 

  451. 																$sub_table_split_select_list = $instance_sub_sub_table -> Get_list ($DBHandle, $SUB_TABLE_SPLIT_CLAUSE, null, null, null, null, null, null);
    452. 

  452. 																
    453. 

  453. 																$select_recordset[$table_split[7]] = $sub_table_split_select_list[0][0];
    454. 

  454. 															}													 
    455. 

  455. 													 
    456. 

  456. 															 $value_display = $table_split[6];
    457. 

  457. 															 $nb_recor_k = count($select_recordset);
    458. 

  458. 															 for ($k=1;$k<=$nb_recor_k;$k++){
    459. 

  459. 																	$value_display  = str_replace("%$k", $select_recordset[$k-1], $value_display );
    460. 

  460. 															 }
    461. 

  461. 													 }else{													 	
    462. 

  462. 															$value_display  = $select_recordset[0];
    463. 

  463. 													 }
    464. 

  464. 										
    465. 

  465. 											  ?>
    466. 

  466.                                             <OPTION  value=<?php echo $select_recordset[1]?>> 
    467. 

  467.                                             <?php echo $value_display?>
    468. 

  468.                                             </OPTION>
    469. 

  469.                                             <?php 
    470. 

  470. 												 }// END_FOREACH
    471. 

  471. 										  }else{
    472. 

  472. 													echo gettext("No data found !!!");
    473. 

  473. 										  }//END_IF				
    474. 

  474. 							  ?>
    475. 

  475.                                           </SELECT>
    476. 

  476.                                         </div></TD>
    477. 

  477.                                     </TR>
    478. 

  478.                                     <TR> 
    479. 

  479.                                       <TD width="122">&nbsp;</TD>
    480. 

  480.                                       <TD width="316"></TD>
    481. 

  481.                                     </TR>
    482. 

  482.                                     <TR> 
    483. 

  483.                                       <TD colspan="2" align="center">
    484. 

  484. 									  	
    485. 

  485. 										<input onClick="sendto('add-content','<?php echo $i?>');" alt="add new a <?php echo $FG_TABLE_EDITION[$i][0]?>" border=0 height=20 hspace=2 id=submit32 name=submit3 src="images/btn_Add_94x20.gif" type=image width=94 value="add-split">
    486. 

  486.                                       </TD>
    487. 

  487.                                     </TR>
    488. 

  488.                                     <TR> 
    489. 

  489.                                       <TD colSpan=2 height=4></TD>
    490. 

  490.                                     </TR>
    491. 

  491.                                     <TR> 
    492. 

  492.                                       <TD colSpan=2> <div align="right"></div></TD>
    493. 

  493.                                     </TR>
    494. 

  494.                                   </TBODY>
    495. 

  495. 								 
    496. 

  496.                                 </TABLE></TD>
    497. 

  497.                               <TD class="form_head"><IMG height=1 src="images/clear.gif" width=1> 
    498. 

  498.                               </TD>
    499. 

  499.                             </TR>
    500. 

  500.                             <TR> 
    501. 

  501.                               <TD colSpan=3 class="form_head"><IMG height=1 src="images/clear.gif" width=1></TD>
    502. 

  502.                             </TR>
    503. 

  503.                           </TBODY>
    504. 

  504.                         </TABLE>
    505. 

  505.                         <br>
    506. 

  506.                         <br>
    507. 

  507.                         <hr size="0"></TD>
    508. 

  508.                     </TR>
    509. 

  509. 					<?php } ?>
    510. 

  510. 					<?php  }elseif (strtoupper ($FG_TABLE_EDITION[$i][3])==strtoupper ("INSERT")){
    511. 

  511. 					
    512. 

  512. 								$table_split = split(":",$FG_TABLE_EDITION[$i][1]);
    513. 

  513. 						
    514. 

  514. 					?>
    515. 

  515.                     <TR> 
    516. 

  516. 					  <!-- ******************** PARTIE EXTERN : INSERT ***************** -->
    517. 

  517. 					  
    518. 

  518.                       <TD width="122" class="form_head"><?php echo $FG_TABLE_EDITION[$i][0]?></TD>					  
    519. 

  519.                       <TD align="center" valign="top" class="tableBodyRight" bgcolor="#CCCCCC"><br>
    520. 

  520.                          
    521. 

  521. 						 <!-- Table with list instance already inserted -->
    522. 

  522.                         <table width="300" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#EDF3FF">
    523. 

  523.                           <TR bgcolor="#ffffff"> 
    524. 

  524.                             <TD height=16 style="PADDING-LEFT: 5px; PADDING-RIGHT: 3px" class="form_head"> 
    525. 

  525.                               <TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
    526. 

  526.                                 <TBODY>
    527. 

  527.                                   <TR> 
    528. 

  528.                                     <TD class="form_head"><?php echo $FG_TABLE_EDITION[$i][0]?>&nbsp; <?php echo gettext("LIST")?> </TD>                                    
    529. 

  529.                                   </TR>
    530. 

  530.                                 </TBODY>
    531. 

  531.                               </TABLE></TD>
    532. 

  532.                           </TR>
    533. 

  533.                           <TR> 
    534. 

  534.                             <TD> <TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
    535. 

  535.                                 <TBODY>
    536. 

  536.                                   <TR> 
    537. 

  537.                                     <TD bgColor=#e1e1e1 colSpan=<?php echo $FG_TOTAL_TABLE_COL?> height=1><IMG height=1 src="images/clear.gif" width=1></TD>
    538. 

  538.                                   </TR>
    539. 

  539.                                   <?php 
    540. 

  540. 			$SPLIT_CLAUSE = str_replace("%id", "$id", $table_split[4]);
    541. 

  541. 			
    542. 

  542. 

  543. 			$instance_sub_table = new Table($table_split[2], $table_split[3]);
    544. 

  544. 			$split_select_list = $instance_sub_table -> Get_list ($DBHandle, $SPLIT_CLAUSE, null, null, null, null, null, null);			
    545. 

  545. 			
    546. 

  546. 	if (!is_array($split_select_list)){	
    547. 

  547. 		$num=0;
    548. 

  548. 	}else{	
    549. 

  549. 		$num = count($split_select_list);
    550. 

  550. 	}
    551. 

  551. 	
    552. 

  552. 	if($num>0)
    553. 

  553. 	{	
    554. 

  554. 	for($j=0;$j<$num;$j++)
    555. 

  555. 	  {
    556. 

  556. 	?>
    557. 

  557.                                   <TR bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$j%2]?>"  onMouseOver="bgColor='#C4FFD7'" onMouseOut="bgColor='<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$j%2]?>'"> 
    558. 

  558.                                     <TD vAlign=top align="<?php echo $FG_TABLE_COL[$i][3]?>" class=tableBody> 
    559. 

  559.                                       <font face="Verdana" size="2">
    560. 

  560.                                       <b><?php echo $split_select_list[$j][$table_split[7]]?></b> : <?php echo $split_select_list[$j][0]?>
    561. 

  561.                                       </font> </TD>
    562. 

  562.                                     <TD align="center" vAlign=top class=tableBodyRight> 
    563. 

  563.                                       <input onClick="sendto('del-content','<?php echo $i?>','<?php echo $table_split[1]?>','<?php echo $split_select_list[$j][1]?>');" alt="Remove this <?php echo $FG_TABLE_EDITION[$i][0]?>" border=0 height=11 hspace=2 id=submit33 name=submit33 src="images/icon-del.gif" type=image width=33 value="add-split"> 
    564. 

  564.                                     </TD>
    565. 

  565.                                   </TR>
    566. 

  566.                                   <?php 
    567. 

  567. 	  }//end_for
    568. 

  568. 	}else{
    569. 

  569. 			?>
    570. 

  570.                                   <TR bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$j%2]?>"  onMouseOver="bgColor='#C4FFD7'" onMouseOut="bgColor='<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$j%2]?>'"> 
    571. 

  571.                                     <TD colspan="2" align="<?php echo $FG_TABLE_COL[$i][3]?>" vAlign=top class=tableBody> 
    572. 

  572.                                       <div align="center" class="liens">No <?php echo $FG_TABLE_EDITION[$i][0]?></div></TD>
    573. 

  573.                                   </TR>
    574. 

  574.                                   <?php 
    575. 

  575. 	}
    576. 

  576. 	?>
    577. 

  577.                                   <TR> 
    578. 

  578.                                     <TD class=tableDivider colSpan=<?php echo $FG_TOTAL_TABLE_COL?>><IMG height=1 src="images/clear.gif" width=1></TD>
    579. 

  579.                                   </TR>
    580. 

  580.                                 </TBODY>
    581. 

  581.                               </TABLE></td>
    582. 

  582.                           </tr>
    583. 

  583.                           <TR bgcolor="#ffffff"> 
    584. 

  584.                             <TD bgcolor="#AAAAAA"  height=16 style="PADDING-LEFT: 5px; PADDING-RIGHT: 3px"> 
    585. 

  585.                               <TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
    586. 

  586.                                 <TBODY>
    587. 

  587.                                   <TR> 
    588. 

  588.                                     <TD height="4" align="right"></TD>
    589. 

  589.                                 </TBODY>
    590. 

  590.                               </TABLE></TD>
    591. 

  591.                           </TR>
    592. 

  592.                         </table><br>
    593. 

  593. </TD>
    594. 

  594.                     </TR>
    595. 

  595.                     <TR>
    596. 

  596. 					  <!-- *******************   Select to ADD new instances  ****************************** -->					  
    597. 

  597.                       <TD class="form_head">&nbsp;</TD>
    598. 

  598.                       <TD align="center" valign="top" bgcolor="#CCCCCC" class="tableBodyRight"><br>
    599. 

  599.                         <TABLE width="300" height=50 border=0 align="center" cellPadding=0 cellSpacing=0>
    600. 

  600. <TBODY>
    601. 

  601.                             <TR> 
    602. 

  602.                               <TD bgColor=#7f99cc colSpan=3 height=16 style="PADDING-LEFT: 5px; PADDING-RIGHT: 5px" class="form_head">
    603. 

  603.                                 <TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
    604. 

  604.                                   <TBODY>
    605. 

  605.                                     <TR> 
    606. 

  606.                                       <TD class="form_head"><?php echo gettext("Add a new")?>  <?php echo $FG_TABLE_EDITION[$i][0]?></TD>                                      
    607. 

  607.                                     </TR>
    608. 

  608.                                   </TBODY>
    609. 

  609.                                 </TABLE></TD>
    610. 

  610.                             </TR>
    611. 

  611.                             <TR> 
    612. 

  612.                               <TD class="form_head"> <IMG height=1 src="images/clear.gif" width=1> 
    613. 

  613.                               </TD>
    614. 

  614.                               <TD bgColor=#F3F3F3 style="PADDING-BOTTOM: 7px; PADDING-LEFT: 5px; PADDING-RIGHT: 5px; PADDING-TOP: 5px"> 
    615. 

  615. 								<TABLE width="97%" border=0 align="center" cellPadding=0 cellSpacing=0>
    616. 

  616.                                   <TBODY>
    617. 

  617.                                     <TR> 
    618. 

  618.                                       <TD width="122" class="tableBody"></TD>
    619. 

  619.                                       <TD width="516"><div align="center"> 				
    620. 

  620. 									      <input type="checkbox" name="voipstation" value="true">
    621. 

  621.                                         <?php echo gettext("Voip Station")?> 
    622. 

  622.                                         </div></TD>
    623. 

  623.                                     </TR>
    624. 

  624. 									<TR> 
    625. 

  625.                                       <TD width="122" class="tableBody"><?php echo $FG_TABLE_EDITION[$i][0]?></TD>
    626. 

  626.                                       <TD width="516"><div align="center"> 				
    627. 

  627. 									      <INPUT TYPE="TEXT" name=<?php echo $table_split[1]?> class="form_enter"  size="20" maxlength="20">
    628. 

  628.                                         </div></TD>
    629. 

  629.                                     </TR>
    630. 

  630.                                     <TR> 
    631. 

  631.                                       <TD width="122">&nbsp;</TD>
    632. 

  632.                                       <TD width="316"></TD>
    633. 

  633.                                     </TR>
    634. 

  634.                                     <TR> 
    635. 

  635.                                       <TD colspan="2" align="center">
    636. 

  636. 									  	
    637. 

  637. 										<input onClick="sendto('add-content','<?php echo $i?>');" alt="add new a <?php echo $FG_TABLE_EDITION[$i][0]?>" border=0 height=20 hspace=2 id=submit32 name=submit3 src="images/btn_Add_94x20.gif" type=image width=94 value="add-split">
    638. 

  638.                                       </TD>
    639. 

  639.                                     </TR>
    640. 

  640.                                     <TR> 
    641. 

  641.                                       <TD colSpan=2 height=4></TD>
    642. 

  642.                                     </TR>
    643. 

  643.                                     <TR> 
    644. 

  644.                                       <TD colSpan=2> <div align="right"></div></TD>
    645. 

  645.                                     </TR>
    646. 

  646.                                   </TBODY>
    647. 

  647. 								 
    648. 

  648.                                 </TABLE></TD>
    649. 

  649.                               <TD class="form_head"><IMG height=1 src="images/clear.gif" width=1> 
    650. 

  650.                               </TD>
    651. 

  651.                             </TR>
    652. 

  652.                             <TR> 
    653. 

  653.                               <TD colSpan=3 class="form_head"><IMG height=1 src="images/clear.gif" width=1></TD>
    654. 

  654.                             </TR>
    655. 

  655.                           </TBODY>
    656. 

  656.                         </TABLE>
    657. 

  657.                         <br>
    658. 

  658.                         <br>
    659. 

  659.                         <hr size="0"> </TD>
    660. 

  660.                     </TR>
    661. 

  661. 					
    662. 

  662. 					<?php  }elseif (strtoupper ($FG_TABLE_EDITION[$i][3])==strtoupper ("CHECKBOX")){
    663. 

  663. 							
    664. 

  664. 							$table_split = split(":",$FG_TABLE_EDITION[$i][1]);
    665. 

  665. 					?>
    666. 

  666. 					<TR> 
    667. 

  667. 					 <!-- ******************** PARTIE EXTERN : CHECKBOX ***************** -->
    668. 

  668.                      <TD width="122" class="form_head"><?php echo $FG_TABLE_EDITION[$i][0]?></TD>					  
    669. 

  669.                      <TD align="center" valign="top" class="tableBodyRight" bgcolor="#CCCCCC">
    670. 

  670. 					    <br>
    671. 

  671. 	<?php 
    672. 

  672. 	$SPLIT_CLAUSE = str_replace("%id", "$id", $table_split[4]);
    673. 

  673. 

  674. 	$instance_sub_table = new Table($table_split[2], $table_split[3]);
    675. 

  675. 	$split_select_list = $instance_sub_table -> Get_list ($DBHandle, $SPLIT_CLAUSE, null, null, null, null, null, null);			
    676. 

  676. 	if (!is_array($split_select_list)){	
    677. 

  677. 		$num=0;
    678. 

  678. 	}else{	
    679. 

  679. 		$num = count($split_select_list);
    680. 

  680. 	}
    681. 

  681. 

  682. 	 ////////////////////////////////////////////////////////////////////////////////////////////////////////
    683. 

  683. 	 
    684. 

  684. 	 $split_select_list_tariff = $instance_sub_table -> Get_list ($DBHandle, null, null, null, null, null, null, null);
    685. 

  685. 										 
    686. 

  686. 	 if (count($split_select_list_tariff)>0)
    687. 

  687. 	 {
    688. 

  688. 			 $select_number=0;
    689. 

  689. 		  ?>				
    690. 

  690. 			  		<TABLE width="400" height=50 border=0 align="center" cellPadding=0 cellSpacing=0>
    691. 

  691. 						<TBODY>
    692. 

  692.                             <TR> 
    693. 

  693.                               <TD bgColor=#7f99cc colSpan=3 height=16 style="PADDING-LEFT: 5px; PADDING-RIGHT: 5px" class="form_head">
    694. 

  694.                                 <TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
    695. 

  695.                                   <TBODY>
    696. 

  696.                                     <TR> 
    697. 

  697.                                       <TD class="form_head"><?php echo gettext("LIST")?>  <?php echo $FG_TABLE_EDITION[$i][0]?></TD>                                      
    698. 

  698.                                     </TR>
    699. 

  699.                                   </TBODY>
    700. 

  700.                                 </TABLE></TD>
    701. 

  701.                             </TR>
    702. 

  702.                             <TR> 
    703. 

  703.                               <TD class="form_head"> <IMG height=1 src="images/clear.gif" width=1> 
    704. 

  704.                               </TD>
    705. 

  705.                               <TD bgColor=#F3F3F3 style="PADDING-BOTTOM: 7px; PADDING-LEFT: 5px; PADDING-RIGHT: 5px; PADDING-TOP: 5px"> 
    706. 

  706. 								<TABLE width="97%" border=0 align="center" cellPadding=0 cellSpacing=0>
    707. 

  707.                                   <TBODY>
    708. 

  708.                                     
    709. 

  709.  <?php 
    710. 

  710.  	foreach ($split_select_list_tariff as $select_recordset){ 
    711. 

  711. 				 $select_number++;
    712. 

  712. 				 
    713. 

  713. 				 if ($table_split[6]!="" && !is_null($table_split[6])){
    714. 

  714. 				 
    715. 

  715. 						if (is_numeric($table_split[7])){
    716. 

  716. 							
    717. 

  717. 							$instance_sub_sub_table = new Table($table_split[8], $table_split[9]);
    718. 

  718. 							
    719. 

  719. 							$SUB_TABLE_SPLIT_CLAUSE = str_replace("%1", $select_recordset[$table_split[7]], $table_split[11] );
    720. 

  720. 							$sub_table_split_select_list_tariff = $instance_sub_sub_table -> Get_list ($DBHandle, $SUB_TABLE_SPLIT_CLAUSE, null, null, null, null, null, null);
    721. 

  721. 							
    722. 

  722. 							$select_recordset[$table_split[7]] = $sub_table_split_select_list_tariff[0][0];
    723. 

  723. 						}													 
    724. 

  724. 				 
    725. 

  725. 						 $value_display = $table_split[6];
    726. 

  726. 						 $nb_recor_k = count($select_recordset);
    727. 

  727. 						 for ($k=1;$k<=$nb_recor_k;$k++){
    728. 

  728. 								$value_display  = str_replace("%$k", $select_recordset[$k-1], $value_display );
    729. 

  729. 						 }
    730. 

  730. 				 }else{													 	
    731. 

  731. 						$value_display  = $select_recordset[0];
    732. 

  732. 				 }
    733. 

  733. 				 
    734. 

  734. 				 
    735. 

  735. 				 $checked_tariff=false;
    736. 

  736. 				 if($num>0)
    737. 

  737. 				 {	
    738. 

  738. 					for($j=0;$j<$num;$j++)
    739. 

  739. 					{
    740. 

  740. 						if ($select_recordset[1]==$split_select_list[$j][1]) $checked_tariff=true;
    741. 

  741. 					}					
    742. 

  742. 				 }
    743. 

  743. 					
    744. 

  744. ?>
    745. 

  745. 			<TR> 
    746. 

  746. 				<TD class="tableBody"><input type="checkbox" name="<?php echo $table_split[0]?>[]" value="<?php echo $select_recordset[1]?>" <?php if ($checked_tariff) echo"checked";?>></TD>
    747. 

  747. 				<TD>&nbsp; <?php echo $value_display?></TD>
    748. 

  748. 			</TR>
    749. 

  749. <?php }// END_FOREACH?>
    750. 

  750.                                     <TR><TD width="30">&nbsp;</TD><TD width="316"></TD></TR>                                    
    751. 

  751.                                     <TR><TD colSpan=2 height=4></TD></TR>                                    
    752. 

  752.                                   </TBODY>
    753. 

  753.                                 </TABLE></TD>
    754. 

  754.                               <TD class="form_head"><IMG height=1 src="images/clear.gif" width=1> 
    755. 

  755.                               </TD>
    756. 

  756.                             </TR>
    757. 

  757.                             <TR> 
    758. 

  758.                               <TD colSpan=3 class="form_head"><IMG height=1 src="images/clear.gif" width=1></TD>
    759. 

  759.                             </TR>
    760. 

  760.                           </TBODY>
    761. 

  761.                         </TABLE>
    762. 

  762. 			  <?php 	       
    763. 

  763. 	  }else{
    764. 

  764. 				echo gettext("No data found !!!");
    765. 

  765. 	  }?>
    766. 

  766. 					 </TD>
    767. 

  767.                     </TR>
    768. 

  768.                     <?php   	  }// end if if (strtoupper ($FG_TABLE_EDITION[$i][3])==strtoupper ("SELECT"))
    769. 

  769. 							}// end if pos
    770. 

  770. 						}//END_FOR ?>
    771. 

  771.                     
    772. 

  772. 					<TR>                       
    773. 

  773.                       <TD colSpan=2  style="border-bottom: medium dotted #667766"> &nbsp;</TD>
    774. 

  774.                     </TR>
    775. 

  775. 					<TR> 
    776. 

  776. 					  <TD colspan=2>
    777. 

  777. 						<table>
    778. 

  778. 							<tr>
    779. 

  779. 								<td width="%95"  class="tableBodyRight"><?php echo $FG_BUTTON_EDITION_BOTTOM_TEXT?></td>
    780. 

  780. 								<td width="%5" align="right"><input onClick="sendto('edit');"  border=0 hspace=2 id=submit3 name=submit32 src="<?php echo $FG_BUTTON_EDITION_SRC?>" type=image value="add-split"></td>
    781. 

  781. 							</tr>
    782. 

  782. 						</table>
    783. 

  783.                       </TD>
    784. 

  784.                     </TR>                    
    785. 

  785.                     <TR> 
    786. 

  786.                       <TD colSpan=2 height=4></TD>
    787. 

  787.                     </TR>
    788. 

  788.                   </TBODY>
    789. 

  789.                 </FORM>
    790. 

  790.               </TABLE>      <br>
    791. 

  791.       <br>
    792. 

  792.       <?php } ?>
    793. 

  793.       <?php if ($form_action=="ask-add"){ ?>
    794. 

  794.     <br>
    795. 

  795. 	                <TABLE width="95%" border=0 align="center" cellPadding=2 cellSpacing=2 style="PADDING-BOTTOM: 7px; PADDING-LEFT: 5px; PADDING-RIGHT: 5px; PADDING-TOP: 5px">
    796. 

  796.                 <FORM action=<?php echo $PHP_SELF?> id=myForm method=post name=myForm>
    797. 

  797.                   <INPUT type="hidden" name="form_action" value="add">
    798. 

  798. 				  	<?php
    799. 

  799. 						if (!is_null($FG_QUERY_ADITION_HIDDEN_FIELDS) && $FG_QUERY_ADITION_HIDDEN_FIELDS!=""){
    800. 

  800. 							
    801. 

  801. 							$split_hidden_fields = split(",",trim($FG_QUERY_ADITION_HIDDEN_FIELDS));
    802. 

  802. 							$split_hidden_fields_value = split(",",trim($FG_QUERY_ADITION_HIDDEN_VALUE));
    803. 

  803. 

  804. 							for ($cur_hidden=0;$cur_hidden<count($split_hidden_fields);$cur_hidden++){
    805. 

  805. 									echo "<INPUT type=\"hidden\" name=\"".trim($split_hidden_fields[$cur_hidden])."\" value=\"".trim($split_hidden_fields_value[$cur_hidden])."\">\n";
    806. 

  806. 							}
    807. 

  807. 							
    808. 

  808. 						}
    809. 

  809. 					?>
    810. 

  810. 				  
    811. 

  811. 				  <INPUT type="hidden" name="atmenu" value="<?php echo $atmenu?>">
    812. 

  812. 				  
    813. 

  813.                   <TBODY>
    814. 

  814.                     <?php for($i=0;$i<$FG_NB_TABLE_EDITION;$i++){ 
    815. 

  815. 						$pos = strpos($FG_TABLE_EDITION[$i][1], ":");
    816. 

  816. 						if (!$pos){
    817. 

  817. 					?>
    818. 

  818.                     <TR> 					  
    819. 

  819.                       <TD width="%25" valign="top" class="form_head">
    820. 

  820.                         <?php echo $FG_TABLE_ADITION[$i][0]?></TD>
    821. 

  821.                       <TD width="%75" valign="top" class="tableBodyRight" bgcolor="#CCCCCC"> 
    822. 

  822.                         <?php 
    823. 

  823. 								if ($FG_DEBUG == 1) print($FG_TABLE_ADITION[$i][3]);
    824. 

  824. 						  		if (strtoupper ($FG_TABLE_ADITION[$i][3])==strtoupper ("INPUT")){
    825. 

  825. 						  ?>
    826. 

  826.                         <INPUT class="form_enter" name=<?php echo $FG_TABLE_ADITION[$i][1]?>  <?php echo $FG_TABLE_ADITION[$i][4]?> value="<?php echo $$FG_TABLE_ADITION[$i][1]?>"> 
    827. 

  827. 						<?php 
    828. 

  828. 						  		}elseif (strtoupper ($FG_TABLE_EDITION[$i][3])==strtoupper ("POPUPVALUE"))
    829. 

  829. 								{								
    830. 

  830. 						  ?>
    831. 

  831.                         <INPUT class="form_enter" name=<?php echo $FG_TABLE_ADITION[$i][1]?>  <?php echo $FG_TABLE_ADITION[$i][4]?> value="<?php if($VALID_SQL_REG_EXP){ echo stripslashes($list[0][$i]); }else{ echo $$FG_TABLE_ADITION[$i][1]; }?>"> 
    832. 

  832. 						<a href="#" onclick="window.open('<?php echo $FG_TABLE_ADITION[$i][14]?>popup_formname=myForm&popup_fieldname=<?php echo $FG_TABLE_ADITION[$i][1]?>' <?php echo $FG_TABLE_ADITION[$i][15]?>);"><img src="images/icon_arrow_orange.gif"/></a>
    833. 

  833. 						
    834. 

  834.                         <?php 
    835. 

  835. 						  		}elseif (strtoupper ($FG_TABLE_ADITION[$i][3])==strtoupper ("TEXTAREA")){
    836. 

  836. 						  ?>
    837. 

  837.                         <textarea class="form_enter" name=<?php echo $FG_TABLE_ADITION[$i][1]?> <?php echo $FG_TABLE_ADITION[$i][4]?>><?php echo $$FG_TABLE_ADITION[$i][1]?></textarea> 
    838. 

  838.                         <?php 	
    839. 

  839. 								}elseif (strtoupper ($FG_TABLE_ADITION[$i][3])==strtoupper ("SELECT")){
    840. 

  840. 								
    841. 

  841. 											if ($FG_DEBUG == 1) { echo "<br> TYPE DE SELECT :".$FG_TABLE_ADITION[$i][7];}
    842. 

  842. 											
    843. 

  843. 											if (strtoupper ($FG_TABLE_ADITION[$i][7])==strtoupper ("SQL")){
    844. 

  844. 																					
    845. 

  845. 												$instance_sub_table = new Table($FG_TABLE_ADITION[$i][8], $FG_TABLE_ADITION[$i][9]);
    846. 

  846. 												$select_list = $instance_sub_table -> Get_list ($DBHandle, $FG_TABLE_ADITION[$i][10], $FG_TABLE_ADITION[$i][13], $FG_TABLE_ADITION[$i][14], null, null, null, null);
    847. 

  847. 												
    848. 

  848. 												if ($FG_DEBUG >= 2) { echo "<br>"; print_r($select_list);}
    849. 

  849. 											
    850. 

  850. 											}elseif (strtoupper ($FG_TABLE_ADITION[$i][7])==strtoupper ("LIST")){
    851. 

  851. 																				
    852. 

  852. 												$select_list = $FG_TABLE_ADITION[$i][11];
    853. 

  853. 											}
    854. 

  854. 						  ?>                        
    855. 

  855. 						<SELECT class="form_enter" name=<?php echo $FG_TABLE_ADITION[$i][1]?> <?php echo $FG_TABLE_ADITION[$i][4]?>>
    856. 

  856. 						<?php echo $FG_TABLE_ADITION[$i][15]?>
    857. 

  857.                           <?php
    858. 

  858. 										if (count($select_list)>0){
    859. 

  859. 										  	 $select_number=0;
    860. 

  860. 					 
    861. 

  861. 										  	 foreach ($select_list as $select_recordset){ 
    862. 

  862. 												 $select_number++;
    863. 

  863. 									
    864. 

  864. 										   		if ($FG_TABLE_ADITION[$i][12] != ""){
    865. 

  865. 				
    866. 

  866. 														$value_display = $FG_TABLE_ADITION[$i][12];
    867. 

  867. 														$nb_recor_k = count($select_recordset);
    868. 

  868. 														for ($k=1;$k<=$nb_recor_k;$k++){
    869. 

  869. 																			$value_display  = str_replace("%$k", $select_recordset[$k-1], $value_display );
    870. 

  870. 														}
    871. 

  871. 												
    872. 

  872. 												}else{
    873. 

  873. 														$value_display = $select_recordset[0];								
    874. 

  874. 												}
    875. 

  875. 							?>
    876. 

  876. 								
    877. 

  877. 									<OPTION  value=<?php echo $select_recordset[1]?> <?php if ($$FG_TABLE_ADITION[$i][2]=="$select_recordset[1]"){?>selected<?php  } ?>><?php echo $value_display?></OPTION>
    878. 

  878. 						<?php 
    879. 

  879. 											 }// END_FOREACH
    880. 

  880. 										 }else{
    881. 

  881. 										  		echo DATA_NOT_FOUND;				  
    882. 

  882. 										 }//END_IF				
    883. 

  883. 							?>
    884. 

  884.                         </SELECT>
    885. 

  885.                         <?php     }elseif (strtoupper ($FG_TABLE_ADITION[$i][3])==strtoupper ("RADIOBUTTON")){
    886. 

  886. 								
    887. 

  887. 										 
    888. 

  888. 												$radio_table = split(",",trim($FG_TABLE_EDITION[$i][9]));
    889. 

  889. 												
    890. 

  890. 												foreach ($radio_table as $radio_instance){
    891. 

  891. 													$radio_composant = split(":",$radio_instance);
    892. 

  892. 													echo $radio_composant[0];																								
    893. 

  893. 													echo ' <input type="radio" name="'.$FG_TABLE_ADITION[$i][1].'" value="'.$radio_composant[1].'" ';
    894. 

  894. 													if ($FG_TABLE_ADITION[$i][2]==$radio_composant[1]){
    895. 

  895. 														echo "checked";
    896. 

  896. 													}
    897. 

  897. 													echo ">";
    898. 

  898. 												}								
    899. 

  899.                                }//END_IF (RADIOBUTTON)  
    900. 

  900. 							?>
    901. 

  901. 						<span class="liens">
    902. 

  902. 						 <?php 						
    903. 

  903. 							if (!$fit_expression[$i]  &&  isset($fit_expression[$i]) ){
    904. 

  904. 							
    905. 

  905. 								echo "<br>".$FG_TABLE_ADITION[$i][6]." - ".$regular[$FG_TABLE_ADITION[$i][5]][1];								
    906. 

  906. 							}
    907. 

  907. 							   
    908. 

  908. 						  ?>
    909. 

  909.                         </span> 
    910. 

  910.                         <?php  if (strlen($FG_TABLE_COMMENT[$i])>0){ echo "<br>".$FG_TABLE_COMMENT[$i]; }?>
    911. 

  911.                         &nbsp;</TD>
    912. 

  912.                     </TR>
    913. 

  913.                     <?php   	}
    914. 

  914. 					
    915. 

  915. 						}//END_FOR ?>
    916. 

  916.                     <TR>                       
    917. 

  917.                       <TD colSpan=2  style="border-bottom: medium dotted #667766"> &nbsp;</TD>
    918. 

  918.                     </TR>
    919. 

  919.                     <TR> 
    920. 

  920. 					  <TD colspan=2>
    921. 

  921. 						<table>
    922. 

  922. 							<tr>
    923. 

  923. 								<td class="tableBodyRight" width="95%"><?php echo $FG_BUTTON_ADITION_BOTTOM_TEXT?></td>
    924. 

  924. 								<td align="right" width="5%"><INPUT class="form_enter"  alt="Create a new <?php echo $FG_INSTANCE_NAME?>" border=0 hspace=2 id=submit4 name=submit2 src="<?php echo $FG_BUTTON_ADITION_SRC?>" type=image></td>
    925. 

  925. 							</tr>
    926. 

  926. 						</table>
    927. 

  927.                       </TD>
    928. 

  928.                     </TR>
    929. 

  929.                     <TR> 
    930. 

  930.                       <TD colSpan=2 height=4></TD>
    931. 

  931.                     </TR>
    932. 

  932.                     
    933. 

  933.                   </TBODY>
    934. 

  934.                 </FORM>
    935. 

  935.               </TABLE>      <br> <br>
    936. 

  936.       <?php } ?>
    937. 

  937.       <?php if ($form_action=="ask-delete"){ ?>
    938. 

  938.       <blockquote> 
    939. 

  939.         <div align="center"><b> 
    940. 

  940.           <?php echo $FG_INTRO_TEXT_ASK_DELETION?>
    941. 

  941.           </b></div>
    942. 

  942.       </blockquote>
    943. 

  943.       <br> 
    944. 

  944. 	  			<TABLE width="85%" border=0 align="center" cellPadding=2 cellSpacing=2 style="PADDING-BOTTOM: 7px; PADDING-LEFT: 5px; PADDING-RIGHT: 5px; PADDING-TOP: 5px">
    945. 

  945.                   <FORM action=<?php echo $PHP_SELF?> id=form1 method=post name=form1>
    946. 

  946.                   <INPUT type="hidden" name="id" value="<?php echo $id?>">
    947. 

  947. 				  <INPUT type="hidden" name="atmenu" value="<?php echo $atmenu?>">
    948. 

  948.                   <INPUT type="hidden" name="form_action" value="delete">
    949. 

  949.                   <TBODY>
    950. 

  950.                     <?php for($i=0;$i<$FG_NB_TABLE_EDITION;$i++){ 
    951. 

  951. 					?>
    952. 

  952.                     <TR> 
    953. 

  953.                       <TD width="%25" class="form_head"> 
    954. 

  954.                         <?php echo $FG_TABLE_EDITION[$i][0]?>
    955. 

  955.                       </TD>                      
    956. 

  956. 					  <TD width="%75" valign="top" class="tableBodyRight" bgcolor="#CCCCCC"> 
    957. 

  957.                         <?php 
    958. 

  958. 								if ($FG_DEBUG == 1) print($FG_TABLE_EDITION[$i][3]);
    959. 

  959. 						  		if (strtoupper ($FG_TABLE_EDITION[$i][3])==strtoupper ("INPUT")){
    960. 

  960. 						  ?>
    961. 

  961.                         <INPUT class="form_enter" disabled name=<?php echo $FG_TABLE_EDITION[$i][1]?>  <?php echo $FG_TABLE_EDITION[$i][4]?> value="<?php echo stripslashes($list[0][$i])?>"> 
    962. 

  962.                         <?php 
    963. 

  963. 						  		}elseif (strtoupper ($FG_TABLE_EDITION[$i][3])==strtoupper ("TEXTAREA")){
    964. 

  964. 						  ?>
    965. 

  965.                         <TEXTAREA class="form_enter" disabled name=<?php echo $FG_TABLE_EDITION[$i][1]?> <?php echo $FG_TABLE_EDITION[$i][4]?>><?php echo stripslashes($list[0][$i])?></textarea> 
    966. 

  966.                         <?php 	
    967. 

  967. 								}elseif (strtoupper ($FG_TABLE_EDITION[$i][3])==strtoupper ("SELECT")){
    968. 

  968. 								
    969. 

  969. 											if ($FG_DEBUG == 1) { echo "<br> TYPE DE SELECT :".$FG_TABLE_EDITION[$i][7];}
    970. 

  970. 											
    971. 

  971. 											if (strtoupper ($FG_TABLE_EDITION[$i][7])==strtoupper ("SQL")){
    972. 

  972. 																					
    973. 

  973. 												$instance_sub_table = new Table($FG_TABLE_EDITION[$i][8], $FG_TABLE_EDITION[$i][9]);
    974. 

  974. 												$select_list = $instance_sub_table -> Get_list ($DBHandle, $FG_TABLE_EDITION[$i][10], null, null, null, null, null, null);
    975. 

  975. 												
    976. 

  976. 												if ($FG_DEBUG >= 2) { echo "<br>"; print_r($select_list);}
    977. 

  977. 											
    978. 

  978. 											}elseif (strtoupper ($FG_TABLE_EDITION[$i][7])==strtoupper ("LIST")){
    979. 

  979. 																				
    980. 

  980. 												$select_list = $FG_TABLE_EDITION[$i][11];
    981. 

  981. 												//$select_list_nb = count($select_list);
    982. 

  982. 											}
    983. 

  983. 						  ?>
    984. 

  984.                         <SELECT class="form_enter" disabled name=<?php echo $FG_TABLE_EDITION[$i][1]?> class="form_enter">
    985. 

  985.                           <?php
    986. 

  986. 										if (count($select_list)>0){
    987. 

  987. 										  	 $select_number=0;
    988. 

  988. 					 
    989. 

  989. 										  	 foreach ($select_list as $select_recordset){ 
    990. 

  990. 												 $select_number++;
    991. 

  991. 												 //%1 : (%2)
    992. 

  992. 												 if (!is_null($FG_TABLE_EDITION[$i][12]) && strlen($FG_TABLE_EDITION[$i][12])){
    993. 

  993. 												 		$value_display =  $FG_TABLE_EDITION[$i][12];
    994. 

  994. 														$nb_recor_k = count($select_recordset);
    995. 

  995. 														for ($k=1;$k<=$nb_recor_k;$k++){
    996. 

  996. 															$value_display  = str_replace("%$k", $select_recordset[$k-1], $value_display );
    997. 

  997. 														}
    998. 

  998. 														
    999. 

  999. 												 }else{
    1000. 

  1000. 												 		$value_display = $select_recordset[0];
    1001. 

  1001. 												 }
    1002. 

  1002. 									
    1003. 

  1003. 									?>
    1004. 

  1004.                           <OPTION  value=<?php echo $select_recordset[1]?> <?php if (strcmp($list[0][$i],$select_recordset[1])==0){ echo "selected"; } ?>> 
    1005. 

  1005.                           <?php echo $value_display?>
    1006. 

  1006.                           </OPTION>
    1007. 

  1007.                           <?php 
    1008. 

  1008. 											 }// END_FOREACH
    1009. 

  1009. 										 }else{
    1010. 

  1010. 										  		echo gettext("No data found !!!");				  
    1011. 

  1011. 										 }//END_IF				
    1012. 

  1012. 							?>
    1013. 

  1013.                         </SELECT> 
    1014. 

  1014.                         <?php     }//END_IF (SELECT)						
    1015. 

  1015. 						?>
    1016. 

  1016.                       </TD>
    1017. 

  1017.                     </TR>
    1018. 

  1018.                     <?php   }//END_FOR ?>
    1019. 

  1019. 					<TR>                       
    1020. 

  1020.                       <TD colSpan=2  style="border-bottom: medium dotted #667766"> &nbsp;</TD>
    1021. 

  1021.                     </TR>
    1022. 

  1022.                     <TR> 
    1023. 

  1023.                       <TD class="tableBodyRight"  width="95%"><?php echo $FG_BUTTON_DELETION_BOTTOM_TEXT?>
    1024. 

  1024. 					  </TD>				                      
    1025. 

  1025.                       <TD align="right"  width="5%"> <INPUT class="form_enter" title="<?php echo gettext("Remove this Speed Dial")?>" alt="<?php echo REMOVE_SPEEDDIAL?>" height=20 hspace=2 id=submit22 name=submit22 value="<?php echo gettext("Delete");?>" type="submit">
    1026. 

  1026. 		      </TD>
    1027. 

  1027.                     </TR>                    
    1028. 

  1028.                     
    1029. 

  1029.                   </TBODY>
    1030. 

  1030.                 </FORM>
    1031. 

  1031.               </TABLE>      <br> <br> 
    1032. 

  1032.       <?php } ?>
    1033. 

  1033.       <?php if ($form_action == "delete" || $form_action == "add"){ ?>
    1034. 

  1034.       <br><br>
    1035. 

  1035. 	  
    1036. 

  1036.         
    1037. 

  1037.  			  <TABLE width="85%" border=0 align="center" cellPadding=2 cellSpacing=2 style="PADDING-BOTTOM: 7px; PADDING-LEFT: 5px; PADDING-RIGHT: 5px; PADDING-TOP: 5px">              
    1038. 

  1038.                 <TBODY>
    1039. 

  1039. 				<TR> 
    1040. 

  1040.                     <TD class="form_head"> 
    1041. 

  1041. 							  <?php if ($form_action == "delete") { ?>
    1042. 

  1042. 							  <?php echo $FG_INSTANCE_NAME?> <?php echo gettext("Deletetion")?> 
    1043. 

  1043. 							  <?php }elseif ($form_action == "add"){ ?>
    1044. 

  1044. 							 <?php echo gettext("New")?>  <?php echo $FG_INSTANCE_NAME?><?php echo gettext("Inserted")?> 
    1045. 

  1045. 							  <?php  } ?>
    1046. 

  1046.                       </TD>                    
    1047. 

  1047.                   </TR>
    1048. 

  1048.                   <TR> 
    1049. 

  1049.                     <TD width="516" valign="top" class="tableBodyRight" bgcolor="#CCCCCC"> <br>
    1050. 

  1050. 						<div align="center"><strong><font size="3"> 
    1051. 

  1051. 					<?php if ($form_action == "delete") { ?><?php echo $FG_INTRO_TEXT_DELETION?><?php }elseif ($form_action == "add"){ ?><?php echo $FG_TEXT_ADITION_CONFIRMATION?><?php  } ?>
    1052. 

  1052.                         
    1053. 

  1053.                         </font></strong></div>
    1054. 

  1054. 						<br>
    1055. 

  1055. 					</TD>
    1056. 

  1056.                   </TR>                  
    1057. 

  1057.                 </TBODY>
    1058. 

  1058.               </TABLE>
    1059. 

  1059. 			  <br><br><br><br><br>
    1060. 

  1060.       <?php } ?>
    1061. 

  1061. <?php
    1062. 

  1062. 	include("PP_footer.php");
    1063. 

  1063. ?>
    1064. 

  1064.