Разработка автоматизированной системы учета пластиковых карт

} // end foreach

$bcc_addresses =

$additional_headers = '';

"Cc:".$cc_addresses."\n";

"Bcc:".$bcc_addresses;

if ($cc_addresses != '') {

$additional_headers.=

} // end if

if ($bcc_addresses != '') {

$additional_headers.=

} // end if

mail($to_addresses, $db_name.'

- '.$table_name.' - '.$normal_messages_ar['new_update_executed'], $update_notice_email,

$additional_headers);

} // end if

header('Location:'.$site_url.$dadabik_main_file.'?table_name='.urlencode($table_name).'&fu nction=edit&where_field='.urlencode($where_field)."&where_value=".urlencode($where_value).'&just_ updated=1');

exit;

} // end if else {

header('Location:'.$site_url.$dadabik_main_file.'?table_name='.urlencode($table_name).'&fu nction=edit&where_field='.urlencode($where_field)."&where_value=".urlencode($where_value).'&just_ updated_no_authorization=1');

exit;

} // end else

} // end else

} // end else

} // end else

} // end else if ($check === 0) {

txt_out("<h3>".$normal_messages_ar["edit_record"]."</h3>");

$form_type = "update";

$res_details = '';

$show_insert_form_after_error = 1;

$show_edit_form_after_error = 1;

// display the form

$form = build_form($table_name, $action, $fields_labels_ar,

$form_type, $res_details, $where_field, $where_value, $_POST, $_FILES,

$show_insert_form_after_error, $show_edit_form_after_error);

echo $form;

} // end if

} // end if break;

case "delete":

if ($enable_delete == "1") {

$location_url =

$site_url.$dadabik_main_file.'?table_name='.urlencode($table_name).'&function=search&where_clause

='.urlencode($where_clause);

if(isset($page) && isset($order) && isset($order_type)) {

$location_url.= '&page='.$page.'&order='.urlencode($order).'&order_type='.$order_type;

}

else{

$location_url.= '&page=0';

}

if( $enable_authentication === 0 || $enable_delete_authorization === 0 || current_user_is_owner($where_field, $where_value, $table_name, $fields_labels_ar)){

delete_record ($table_name, $where_field, $where_value);

} // end if else {

$location_url.= '&just_delete_no_authorization=1';

} // end else header('Location: '.$location_url);

exit;

} // end if break;

case "delete_all":

if ($enable_delete == "1" && $enable_delete_all_feature === 1) {

$ID_user_field_name = get_ID_user_field_name($fields_labels_ar); delete_multiple_records ($table_name, $where_clause, $ID_user_field_name);

$location_url =

$site_url.$dadabik_main_file.'?table_name='.urlencode($table_name)."&function=search&where_clause

=&page=0";

if ($enable_browse_authorization === 0 && $ID_user_field_name !== false) {

// if the user see just his owns records the message doesn't make sense

$location_url.= '&just_delete_all_authorizated=1';

} // end if header('Location: '.$location_url);

exit;

} // end if break;

case "show_insert_form":

if ($enable_insert == "1") { txt_out("<h3>".$normal_messages_ar["insert_record"]."</h3>");

$form_type = "insert";

$res_details = "";

$show_insert_form_after_error = 0;

$show_edit_form_after_error = 0;

// display the form

$form = build_form($table_name, $action, $fields_labels_ar, $form_type,

$res_details, "", "", $_POST, $_FILES, $show_insert_form_after_error,

$show_edit_form_after_error);

echo $form;

} // end if break;

case "show_search_form":

txt_out("<h3>".$normal_messages_ar["search_records"]."</h3>");

$form_type = "search";

$res_details = "";

$show_insert_form_after_error = 0;

$show_edit_form_after_error = 0;

// display the form

$form = build_form($table_name, $action, $fields_labels_ar, $form_type,

$res_details, "", "", $_POST, $_FILES, $show_insert_form_after_error,

$show_edit_form_after_error);

echo $form; break;

case "choose_next_record";

if (isset($where_clause) && isset($order) && isset($order_type)) { // could be not set if the session has expired

// rebuild the query for the current results

$sql = build_select_part($fields_labels_ar, $table_name);

".$order_type;

if ($where_clause !== '') {

$sql.= " WHERE ".$where_clause;

} // end if

$sql.= " ORDER BY ".$quote.$table_name.$quote.'.'.$quote.$order.$quote. "

// execute the query

$res = execute_db($sql, $conn);

// loop through the recordset, when find the current record, read another one and save its where_value

$record_found = 0;

while ($row = fetch_row_db($res)) {

if ($row[$where_field] == $where_value) {

$record_found = 1;

current is the last record

if ($row = fetch_row_db($res)) { // could be false if the

$new_where_value = $row[$where_field];

} // end if

} // end if

} // end while

if ($record_found === 0) { // the record has not been found txt_out('<p>'.$error_messages_ar['record_from_which_you_come_no_longer_exists'].'</p>');

} // end if

elseif (!isset($new_where_value)) { // the current record is the last one header('Location:

'.$site_url.$dadabik_main_file.'?table_name='.$table_name.'&function='.$from_function.'&where_fie ld='.urlencode($where_field).'&where_value='.urlencode($where_value).'&just_next_record_on_last_o ne=1');

exit;

} // end elseif else {

// redirect to the function from which the user comes (edit or detail) using the where_value just discovered

header('Location: '.$site_url.$dadabik_main_file.'?table_name='.$table_name.'&function='.$from_function.'&where_fie ld='.urlencode($where_field).'&where_value='.urlencode($new_where_value));

} // end else

} // end if break;

case "choose_previous_record";

if (isset($where_clause) && isset($order) && isset($order_type)) { // could be not set if the session has expired

// rebuild the query for the current results

$sql = build_select_part($fields_labels_ar, $table_name);

".$order_type;

if ($where_clause !== '') {

$sql.= " WHERE ".$where_clause;

} // end if

$sql.= " ORDER BY ".$quote.$table_name.$quote.'.'.$quote.$order.$quote."

// execute the query

$res = execute_db($sql, $conn);

// loop through the recordset, when find the current record, read another one and save its where_value

$record_found = 0;

while ($row = fetch_row_db($res)) {

if ($row[$where_field] == $where_value) {

$record_found = 1;

} // end if

if ($record_found === 0) {

$new_where_value = $row[$where_field];

} // end if

} // end while

if ($record_found === 0) { // the record has not been found txt_out('<p>'.$error_messages_ar['record_from_which_you_come_no_longer_exists'].'</p>');

} // end if

elseif (!isset($new_where_value)) { // the current record is the first one header('Location:

'.$site_url.$dadabik_main_file.'?table_name='.$table_name.'&function='.$from_function.'&where_fie ld='.urlencode($where_field).'&where_value='.urlencode($where_value).'&just_previous_record_on_fi rst_one=1');

exit;

} // end elseif else {

// redirect to the function from which the user comes (edit or detail) using the where_value just discovered

header('Location: '.$site_url.$dadabik_main_file.'?table_name='.$table_name.'&function='.$from_function.'&where_fie ld='.urlencode($where_field).'&where_value='.urlencode($new_where_value));

exit;

} // end else

} // end if break;

} // end swtich ($function)

// include footer

include ("./include/footer.php");

?>

Размещено на Allbest.ru