<?php

/* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: */

/**
 * This file is part of A2Billing (http://www.a2billing.net/)
 *
 * A2Billing, Commercial Open Source Telecom Billing platform,
 * powered by Star2billing S.L. <http://www.star2billing.com/>
 *
 * @copyright   Copyright (C) 2004-2012 - Star2billing S.L.
 * @author      Belaid Arezqui <areski@gmail.com>
 * @license     http://www.fsf.org/licensing/licenses/agpl-3.0.html
 * @package     A2Billing
 *
 * Software License Agreement (GNU Affero General Public License)
 *
 * 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/>.
 *
 *
**/


getpost_ifset(array('id', 'config_title', 'config_key', 'config_value', 'config_description', 'config_group_title', 'groupselect', 'filterKey', 'rbKey', 'filterDescription', 'rbDesc', 'filterValue', 'rbValue', 'posted','agi_conf'));

// This will generate agi-confx
// agi-confx is duplication of Global configuration and list of configurations of : agi-conf1
if ($agi_conf) {
	check_demo_mode();
	$groupselect = add_agi_confx();
	unset($agi_conf);
}

$setbool = false;
$handle = DbConnect();
$instance_table = new Table();

if ($form_action == "ask-edit") {
	$QUERY =  "SELECT config_value, config_listvalues FROM cc_config where id = $id";
	$result = $instance_table -> SQLExec ($handle, $QUERY);
	if ($result[0][1] == "yes,no" || $result[0][1] == "no,yes") {
		$setbool = true;
	}
}

$value_list = array();
$value_list["1"] = array( gettext("yes"), 1);
$value_list["2"] = array( gettext("no"), 0);

$yesno = array();

$instance_config_table = new Table("cc_config", "config_value, config_valuetype, id");
$config_list = $instance_config_table -> Get_list ($handle, "", "id", "ASC");

foreach($config_list as $key => $cur_value) {
	if($cur_value[1] != '1') {
		$yesno[$cur_value[2]] = array($cur_value[0],$cur_value[2]);
	} else {
		if($cur_value[0] == '1') {
			$yesno[$cur_value[2]] = array("Yes",$cur_value[2]);
		} else if($cur_value[0] == '0') {
			$yesno[$cur_value[2]] = array("No",$cur_value[2]);
		} else {
			$yesno[$cur_value[2]] = array($cur_value[0],$cur_value[2]);
		}
	}
}
$HD_Form = new FormHandler("cc_config", gettext("Configuration"));
$HD_Form -> FG_DEBUG = 0;
$HD_Form -> FG_TABLE_ID="id";
$HD_Form -> FG_TABLE_DEFAULT_ORDER = "config_group_title";
$HD_Form -> FG_TABLE_DEFAULT_SENS = "ASC";

if ($groupselect != "-1" && $groupselect != "") {
	$HD_Form -> FG_TABLE_ID = "id";
	$HD_Form -> FG_TABLE_CLAUSE = " config_group_title = '$groupselect'";
	$_SESSION['ss_groupselect'] = $HD_Form -> FG_TABLE_CLAUSE;
	$_SESSION['grpselect'] = $groupselect;
}

if (!empty($filterKey)) {
	switch ($rbKey) {
		case 1 : $filterKey = " = '$filterKey'"; break;
		case 2 : $filterKey = " LIKE '$filterKey%'"; break;
		case 3 : $filterKey = " LIKE '%$filterKey%'"; break;
		case 4 : $filterKey = " LIKE '%$filterKey'"; break;
	}

	$OPL = '';
	if ( ($groupselect != "-1") ) {
		$OPL = 'AND';
	}
	$HD_Form -> FG_TABLE_CLAUSE .= " $OPL config_key $filterKey";
}
if (!empty($filterDescription)) {
	switch ($rbDesc) {
		case 1 : $filterDescription = " = '$filterDescription'"; break;
		case 2 : $filterDescription = " LIKE '$filterDescription%'"; break;
		case 3 : $filterDescription = " LIKE '%$filterDescription%'"; break;
		case 4 : $filterDescription = " LIKE '%$filterDescription'"; break;
	}

	$OPL = '';
	if ( ($groupselect != "-1") || !empty($filterKey) ) {
		$OPL = 'AND';
	}
	$HD_Form -> FG_TABLE_CLAUSE .= " $OPL config_description $filterDescription";
}

if (!empty($filterValue)) {
	switch ($rbValue) {
		case 1 : $filterValue = " = '$filterValue'"; break;
		case 2 : $filterValue = " LIKE '$filterValue%'"; break;
		case 3 : $filterValue = " LIKE '%$filterValue%'"; break;
		case 4 : $filterValue = " LIKE '%$filterValue'"; break;
	}

	$OPL = '';
	if ( ($groupselect != "-1") || !empty($filterKey) || !empty($filterDescription) ) {
		$OPL = 'AND';
	}
	$HD_Form -> FG_TABLE_CLAUSE .= " $OPL config_value $filterValue";
}

if (isset($posted)) {
	$_SESSION['ss_groupselect'] = '';
	$_SESSION['groupselect'] = '';
	$_SESSION['ss_groupselect'] = $HD_Form -> FG_TABLE_CLAUSE;
}

if($form_action == "list") {
	$_SESSION['ss_groupselect'] = '';
	$_SESSION['groupselect'] = '';
} else {
	$HD_Form -> FG_TABLE_CLAUSE = $_SESSION['ss_groupselect'];
}

$HD_Form -> FG_EDITION_CLAUSE = "id = %id";
$HD_Form -> AddViewElement(gettext("TITLE"), "config_title", "20%", "center");
$HD_Form -> AddViewElement(gettext("KEY"), "config_key", "15%", "center");
$HD_Form -> AddViewElement(gettext("VALUE"), "config_value", "10%", "center","","","list-conf",$yesno);
$HD_Form -> AddViewElement(gettext("DESCRIPTION"), "config_description", "40%", "left");
$HD_Form -> AddViewElement(gettext("GROUP"), "config_group_title", "5%", "center");

$HD_Form -> FieldViewElement ('config_title, config_key, config_value, config_description, config_group_title');

$HD_Form -> CV_NO_FIELDS  = gettext("THERE ARE NO ".strtoupper($HD_Form->FG_INSTANCE_NAME)." CREATED!");
$HD_Form -> CV_DISPLAY_LINE_TITLE_ABOVE_TABLE = false;
$HD_Form -> CV_TEXT_TITLE_ABOVE_TABLE = '';
$HD_Form -> CV_DISPLAY_FILTER_ABOVE_TABLE = false;
$HD_Form -> FG_LIMITE_DISPLAY = 25;

$HD_Form -> FG_EDITION = true;
$HD_Form -> FG_DELETION = false;
$HD_Form -> FG_ADDITION = false;
if(!$setbool) {
	$HD_Form -> FG_DISPLAY_SELECT = true;
	$HD_Form -> FG_SELECT_FIELDNAME = "config_listvalues";
	$HD_Form -> FG_CONF_VALUE_FIELDNAME = "config_value";
}

$HD_Form -> AddEditElement (gettext("GROUP"),
	"config_group_title",
	'$value',
	"INPUT",
	"size=30 readonly",
	"",
	gettext("This is the group of the configuration. Not editable!"),
	"" , "", "", "", "", "", "", gettext("Group Name of the configuration variable"));


$HD_Form -> AddEditElement (gettext("TITLE"),
	"config_title",
	'$value',
	"INPUT",
	"size=40 maxlength=100 readonly",
	"",
	gettext("Insert the TITLE"),
	"" , "", "", "", "" , "", "" ,gettext("Title of the configuration variable"));

$HD_Form -> AddEditElement (gettext("KEY"),
	"config_key",
	'$value',
	"INPUT",
	"size=60 maxlength=100 readonly",
	"",
	gettext("Insert the TITLE"),
	"" , "", "", "", "" , "", "" ,gettext("Key name of the configuration variable"));

if ($setbool) {
	$HD_Form -> AddEditElement (gettext("VALUE"),
	   "config_value",
	   "",
	   "SELECT",
	   "","","",
	   "list" , "", "",	"", $value_list, "%1", "", "" );

} else {
	$HD_Form -> AddEditElement (gettext("VALUE"),
		"config_value",
		'$value',
		"INPUT",
		"size=100 maxlength=200",
		"","",
		"" , "", "", "", "", "", "", gettext("Insert the Value"));
}

if (LIST_OF_VALUES) {
	$HD_Form -> AddEditElement (gettext("LIST OF VALUES"),
		"config_listvalues",
		'$value',
		"INPUT",
		"size=40 ",
		"",
		"",
		"" , "", "", "", "", "", "", gettext("Insert the List of values, comma separated"));
}

$HD_Form -> AddEditElement (gettext("DESCRIPTION"),
	"config_description",
	'',
	"SPAN",
	"cols=80 rows=10",
	"",
	gettext("Insert the Description"),
	"" , "", "", "", "" , "", "", "");


if (LIST_OF_VALUES) {
	$HD_Form -> FieldEditElement ('config_group_title, config_title, config_key, config_value ,config_listvalues, config_description');
} else {
	$HD_Form -> FieldEditElement ('config_group_title, config_title, config_key, config_value ,config_description');
}


$HD_Form -> FG_INTRO_TEXT_EDITION= '';
$HD_Form -> FG_BUTTON_EDITION_SRC = $HD_Form -> FG_BUTTON_ADITION_SRC  = Images_Path . "/cormfirmboton.gif";
$HD_Form -> FG_BUTTON_EDITION_BOTTOM_TEXT = $HD_Form -> FG_BUTTON_ADITION_BOTTOM_TEXT = gettext("Click 'Confirm Data' to continue");

$HD_Form -> FG_GO_LINK_AFTER_ACTION_EDIT = filter_input(INPUT_SERVER, 'PHP_SELF', FILTER_SANITIZE_URL)."?atmenu=document&stitle=Document&wh=AC&id=";