Esempio n. 1
0
 function report_results()
 {
     $department = get_form_value('department', 0);
     $order = get_form_value('order', 'upc');
     $dir = get_form_value('dir', 'ASC');
     $excel = get_form_value('excel', False);
     $dbc = op_connect();
     $query = "SELECT upc, description, normal_price, modified\n\t\t\tFROM products WHERE department={$department}\n\t\t\tORDER BY {$order} {$dir}";
     $columns = array('UPC' => array('col' => 'upc'), 'Description' => array('col' => 'description'), 'Price' => array('col' => 'normal_price', 'align' => 'right', 'format' => '%.2f'), 'Last Modified' => array('col' => 'modified', 'date' => 'm/d/Y'));
     $report = get_sortable_table($dbc, $query, $columns, $this->module_url(), $order, $excel);
     if ($excel) {
         $this->download('report.xls', 'excel');
     }
     $dbc->close();
     return $report;
 }
Esempio n. 2
0
use Galette\Core\L10n;
use Zend\Db\Sql\Expression;
/** @ignore */
require_once 'includes/galette.inc.php';
if (!$login->isLogged()) {
    header('location: index.php');
    die;
}
if (!$login->isAdmin() && !$login->isStaff()) {
    header('location: voir_adherent.php');
    die;
} elseif (!$login->isAdmin()) {
    header('location: gestion_adherents.php');
    die;
}
$text_orig = get_form_value('text_orig', '');
if (isset($_POST['trans']) && isset($text_orig)) {
    if (isset($_POST['new']) && $_POST['new'] == 'true') {
        //create translation if it does not exists yet
        $res = addDynamicTranslation($_POST['text_orig'], $error_detected);
    }
    // Validate form
    while (list($key, $value) = each($_POST)) {
        if (substr($key, 0, 11) == 'text_trans_') {
            $trans_lang = substr($key, 11);
            $trans_lang = str_replace('_utf8', '.utf8', $trans_lang);
            $res = updateDynamicTranslation($text_orig, $trans_lang, $value, $error_detected);
            if ($res !== true) {
                $error_detected[] = preg_replace(array('/%label/', '/%lang/'), array($text_orig, $trans_lang), _T("An error occured saving label `%label` for language `%lang`"));
            }
        }
include WEB_ROOT . "includes/database.inc.php";
include WEB_ROOT . "includes/session.inc.php";
if ($_SESSION["logged_status"] == 0) {
    header("location: index.php");
    die;
}
if ($_SESSION["admin_status"] == 0) {
    header("location: voir_adherent.php");
    die;
}
include WEB_ROOT . "includes/functions.inc.php";
include WEB_ROOT . "includes/i18n.inc.php";
include WEB_ROOT . "includes/smarty.inc.php";
include WEB_ROOT . "includes/dynamic_fields.inc.php";
$error_detected = array();
$form_name = get_form_value('form', '');
if (!isset($all_forms[$form_name])) {
    $form_name = '';
}
$form_not_set = $form_name == '';
if ($form_name == '') {
    $form_title = '';
    $tpl->assign("all_forms", $all_forms);
} else {
    $form_title = $all_forms[$form_name];
    $quoted_form_name = $DB->qstr($form_name, get_magic_quotes_gpc());
    if (isset($_POST["valid"])) {
        if ($_POST["field_type"] != $field_type_separator && (!isset($_POST["field_name"]) || $_POST["field_name"] == "")) {
            $error_detected[] = _T("- The name field cannot be void.");
        } else {
            $field_name = $_POST["field_name"];
{
    if (is_numeric($trans_id)) {
        $total_amount = db_get_one($DB, "SELECT trans_amount\n\t\t\t\t\t\t\t  FROM " . PREFIX_DB . "transactions\n\t\t\t\t\t\t\t  WHERE trans_id={$trans_id}", $error_detected);
        $current_amount = $DB->GetOne("SELECT SUM(montant_cotis)\n\t\t\t\t\t\t\tFROM " . PREFIX_DB . "cotisations\n\t\t\t\t\t\t\tWHERE trans_id={$trans_id}");
        return $total_amount - $current_amount;
    }
    return 0;
}
// new or edit
$contribution['id_cotis'] = get_numeric_form_value("id_cotis", '');
$contribution['id_type_cotis'] = get_numeric_form_value("id_type_cotis", '');
$contribution['id_adh'] = get_numeric_form_value("id_adh", '');
$contribution['trans_id'] = get_numeric_form_value("trans_id", '');
$adh_selected = isset($contribution['id_adh']);
$tpl->assign("adh_selected", $adh_selected);
$type_selected = $contribution['id_cotis'] != '' || get_form_value("type_selected", 0);
$tpl->assign("type_selected", $type_selected);
$cotis_extension = 0;
if (isset($contribution['id_type_cotis'])) {
    $request = "SELECT cotis_extension\n\t\t\t    FROM " . PREFIX_DB . "types_cotisation\n\t\t\t    WHERE id_type_cotis = " . $contribution['id_type_cotis'];
    $cotis_extension = $DB->GetOne($request);
}
// initialize warning
$error_detected = array();
// flagging required fields
$required = array('montant_cotis' => 1, 'date_debut_cotis' => 1, 'date_fin_cotis' => $cotis_extension, 'id_type_cotis' => 1, 'id_adh' => 1);
// Validation
$contribution['dyn'] = array();
if (isset($_POST["valid"])) {
    $contribution['dyn'] = extract_posted_dynamic_fields($DB, $_POST, array());
    $update_string = '';
Esempio n. 5
0
/**
 * Get a numeric value sent by a form, either in POST and GET arrays
 *
 * @param string $name   property name
 * @param string $defval default rollback value
 *
 * @return numeric value retrieved from :
 * - GET array if defined and numeric,
 * - POST array if defined and numéric
 * - $defval otherwise
 */
function get_numeric_form_value($name, $defval)
{
    $val = get_form_value($name, $defval);
    if (!is_numeric($val)) {
        Analog::log('[get_numeric_form_value] not a numeric value! (value was: `' . $val . '`)', Analog::INFO);
        $val = $defval;
    }
    return $val;
}
Esempio n. 6
0
 /**
  * Creates a radio button
  * @param string or array
  * @param string
  * @param string
  * @param array
  * @return string
  */
 function select($name, $label = '', $value = '', $options = array())
 {
     if (is_array($name)) {
         $opts = $name;
         $name = $opts['name'];
         $options = $opts['options'];
         $label = $opts['label'];
         foreach (array('hint', 'required') as $v) {
             if (isset($opts[$v])) {
                 ${$v} = $opts[$v];
                 unset($opts['hint']);
             }
         }
     }
     $html = '<div class="input">';
     $html .= "<label>{$label}</label>";
     $html .= "<select name=\"{$name}\" id=\"{$name}\">";
     if (trim($value) == '') {
         $value = get_form_value($name);
     }
     $html .= '<option></option>';
     foreach ($options as $k => $v) {
         $checked = $value == $k ? 'selected="true" ' : '';
         $html .= "<option value='{$k}' {$checked} />{$v}</option>";
     }
     $html .= '</select>';
     $html .= form_error($name);
     if (isset($hint)) {
         $html .= "<br /><quote>{$hint}</quote>";
     }
     $html .= '</div>';
     return $html;
 }
function get_numeric_form_value($name, $defval)
{
    $val = get_form_value($name, $defval);
    if (!is_numeric($val)) {
        $val = '';
    }
    return $val;
}
Esempio n. 8
0
if (!$login->isAdmin() && !$login->isStaff()) {
    header('location: voir_adherent.php');
    die;
}
$contrib = new Contribution();
//TODO: dynamic fields should be handled by Contribution object
$dyn_fields = new DynamicFields();
$id_cotis = get_numeric_form_value('id_cotis', '');
//first/second step: select member
$id_adh = get_numeric_form_value('id_adh', '');
//first/second step: select contribution type
$selected_type = get_form_value('id_type_cotis', 1);
//first/second step: transaction id
$trans_id = get_numeric_form_value('trans_id', '');
//mark first step has been passed
$type_selected = $id_cotis != null || get_form_value('type_selected', 0);
// flagging required fields for first step only
$required = array('id_type_cotis' => 1, 'id_adh' => 1, 'date_enreg' => 1);
$cotis_extension = 0;
// TODO: remove and remplace with $contrib->isCotis()
$disabled = array();
if ($type_selected && !($id_adh || $id_cotis)) {
    $error_detected[] = _T("You have to select a member.");
    $type_selected = false;
} else {
    if ($id_cotis != '' || $type_selected || $trans_id || $id_adh) {
        if ($id_cotis != '') {
            $contrib = new Contribution((int) $id_cotis);
            if ($contrib->id == '') {
                //not possible to load contribution, exit
                header('location: index.php');
Esempio n. 9
0
    header('location: index.php');
    die;
}
if (!$login->isAdmin() && !$login->isStaff()) {
    header('location: voir_adherent.php');
    die;
}
$trans = new Transaction();
//TODO: dynamic fields should be handled by Transaction object
$dyn_fields = new DynamicFields();
// new or edit
$trans_id = get_numeric_form_value("trans_id", '');
$transaction['trans_id'] = get_numeric_form_value("trans_id", '');
$transaction['trans_amount'] = get_numeric_form_value("trans_amount", '');
$transaction['trans_date'] = get_form_value("trans_date", '');
$transaction['trans_desc'] = get_form_value("trans_desc", '');
$transaction['id_adh'] = get_numeric_form_value("id_adh", '');
// flagging required fields
$required = array('trans_amount' => 1, 'trans_date' => 1, 'trans_desc' => 1, 'id_adh' => 1);
$disabled = array();
if (isset($_GET['detach'])) {
    if (!Contribution::unsetTransactionPart($trans_id, $_GET['detach'])) {
        $error_detected[] = _T("Unable to detach contribution from transaction");
    } else {
        $success_detected[] = _T("Contribution has been successfully detached from current transaction");
    }
}
if (isset($_GET['cid']) && $_GET['cid'] != null) {
    if (!Contribution::setTransactionPart($trans_id, $_GET['cid'])) {
        $error_detected[] = _T("Unable to attach contribution to transaction");
    } else {
Esempio n. 10
0
    die;
}
$df = $dyn_fields->loadFieldType($field_id);
if ($df === false) {
    $error_detected[] = _T("Unable to retrieve field informations.");
}
$data = array('id' => $field_id);
if (isset($_POST['valid'])) {
    $field_name = $_POST['field_name'];
    $field_perm = get_numeric_posted_value('field_perm', '');
    $field_required = get_numeric_posted_value('field_required', '0');
    $field_width = get_numeric_posted_value('field_width', null);
    $field_height = get_numeric_posted_value('field_height', null);
    $field_size = get_numeric_posted_value('field_size', null);
    $field_repeat = get_numeric_posted_value('field_repeat', new Expression('NULL'));
    $fixed_values = get_form_value('fixed_values', '');
    if ($field_id != '' && $field_perm != '') {
        $duplicated = $dyn_fields->isDuplicate($zdb, $form_name, $field_name, $field_id);
        if ($duplicated) {
            $error_detected[] = _T("- Field name already used.");
        } else {
            $select = $zdb->select(DynamicFieldType::TABLE);
            $select->columns(array('field_name'))->where(array('field_id' => $field_id));
            $results = $zdb->execute($select);
            $result = $results->current();
            $old_field_name = $result->field_name;
            if ($old_field_name && $field_name != $old_field_name) {
                addDynamicTranslation($field_name, $error_detected);
                deleteDynamicTranslation($old_field_name, $error_detected);
            }
        }
Esempio n. 11
0
if ($field_id == '') {
    header("location: configurer_fiches.php?form={$form_name}");
}
$field_type = $DB->GetOne("SELECT field_type FROM {$field_types_table} WHERE field_id={$field_id}");
$properties = $field_properties[$field_type];
$data = array('id' => $field_id);
if (isset($_POST["valid"])) {
    $field_name = $_POST["field_name"];
    $field_perm = get_numeric_posted_value("field_perm", '');
    $field_pos = get_numeric_posted_value("field_pos", 0);
    $field_required = get_numeric_posted_value("field_required", '0');
    $field_width = get_numeric_posted_value("field_width", 'NULL');
    $field_height = get_numeric_posted_value("field_height", 'NULL');
    $field_size = get_numeric_posted_value("field_size", 'NULL');
    $field_repeat = get_numeric_posted_value("field_repeat", 'NULL');
    $fixed_values = get_form_value("fixed_values", '');
    if ($field_id != '' && $field_perm != '') {
        $quoted_form_name = $DB->qstr($form_name, get_magic_quotes_gpc());
        $quoted_field_name = $DB->qstr($field_name, get_magic_quotes_gpc());
        $DB->StartTrans();
        $query = "SELECT COUNT(field_id)\n\t\t\t\t  FROM {$field_types_table}\n\t\t\t\t  WHERE NOT field_id={$field_id} AND field_form={$quoted_form_name} AND\n\t\t\t\t  \tfield_name={$quoted_field_name}";
        $duplicate = $DB->GetOne($query);
        if ($duplicate != 0) {
            $error_detected[] = _T("- Field name already used.");
        }
        $query = "SELECT field_name\n\t\t\t\t  FROM {$field_types_table}\n\t\t\t\t  WHERE field_id={$field_id}";
        $old_field_name = db_get_one($DB, $query, $error_detected);
        if ($old_field_name && $field_name != $old_field_name) {
            add_dynamic_translation($DB, $field_name, $error_detected);
            delete_dynamic_translation($DB, $old_field_name, $error_detected);
        }
Esempio n. 12
0
		<span id="grid_step2_autogen_content_additional_data" class="grid_step2_additional_options">
			starting from <input type="text" size="10" name="grid_step2_autogen_content_seq_start"  value="<?php 
display_form_value($grid_step2_column_data, "grid_step2_column" . $current_column . "_autogen_content_seq_start");
?>
" />
		</span>
		suffix: <input type="text" size="10" name="grid_step2_autogen_suffix"  value="<?php 
display_form_value($grid_step2_column_data, "grid_step2_column" . $current_column . "_autogen_suffix");
?>
"/>
		<span class="tip">[you can leave prefix and suffix empty; 1 will taken as default value is starting from field is emtpy]</span>
	</p>
</div>
<div class="grid_step2_additional_options" id="grid_step2_lookup_div">
	<p>which column in this grid : <?php 
displaySelectBox($currentColumns, "grid_step2_lookup_fromcolumn", "grid_step2_lookup_fromcolumn", get_form_value($grid_step2_column_data, "grid_step2_column" . $current_column . "_lookup_fromcolumn"));
?>
</p>
	<p>length of field : <input type="text" size="2" name="grid_step2_lookup_size" /></p>
	<p>select grid : <select id="grid_step2_lookup_gridname" name="grid_step2_lookup_gridname"></select>	</p>
	<p>select column : <select id="grid_step2_lookup_columnname" name="grid_step2_lookup_columnname"></select> </p>
	<p>partial match? <input type="checkbox" name="grid_step2_lookup_partial" /></p>
	<p>match mandatory? <input type="checkbox" name="grid_step2_lookup_mandatory" /></p>
</div>

</fieldset>
<input type="hidden" id="grid_step2_column_datatype_val" value="<?php 
echo $grid_step2_column_datatype;
?>
"/>
<input type="hidden" name="grid_step2_column_no" value="<?php