| 5,29 → 5,58 |
|---|
| |
| if(array_key_exists('delete', $_POST)) { |
| $id = $_POST['id']; |
| $db->begin_transaction(); |
| $db->query_params("update telbook_persons set person_category=NULL" |
| . " where person_category=$1", array($id)); |
| $db->query_params("delete from telbook_categories_export where category_id=$1", array($id)); |
| $db->query_params("delete from telbook_categories where category_id=$1", array($id)); |
| $db->commit_transaction(); |
| |
| header("Location: telbook_categories_list.php"); |
| $g_display->add_text('Information deleted successfully'); |
| } |
| else if(array_key_exists('update', $_POST)) { |
| $id = $_POST['id']; |
| $category_name = $_POST['category_name']; |
| $category_comment = $_POST['category_comment']; |
| $category_export_key = ($_POST['category_export_key'] ? $_POST['category_export_key'] : NULL); |
| elseif(array_key_exists('update', $_POST)) { |
| $id = $_POST['id']; |
| $category_name = $_POST['category_name']; |
| $category_comment = $_POST['category_comment']; |
| |
| $db->begin_transaction(); |
| |
| if($id) { |
| $db->query_params("update telbook_categories set" |
| . " category_name=$2, category_comment=$3, category_export_key=$4" |
| . " category_name=$2, category_comment=$3" |
| . " where category_id=$1", |
| array($id, $category_name, $category_comment, $category_export_key)); |
| array($id, $category_name, $category_comment)); |
| } |
| else { |
| $db->query_params("insert into telbook_categories" |
| . " (category_name, category_comment, category_export_key) values ($1, $2, $3)", |
| array($category_name, $category_comment, $category_export_key)); |
| . " (category_name, category_comment) values ($1, $2)", |
| array($category_name, $category_comment)); |
| |
| $db->query("select currval('telbook_categories_category_id_seq')"); |
| if($line = $db->fetch_row_idx()) { |
| $id = $line[0]; |
| } |
| } |
| |
| $db->query_params("delete from telbook_categories_export where category_id=$1", array($id)); |
| |
| # save entries |
| foreach($_POST as $key => $value) { |
| if(substr($key, 0, strlen('export_title-')) == 'export_title-') { |
| $export_id = substr($key, strlen('export_title-')); |
| |
| if($value) { |
| $db->query_params("insert into telbook_categories_export" |
| . " (export_id, category_id, category_export_title)" |
| . " values ($1, $2, $3)", |
| array($export_id, $id, $value)); |
| } |
| } |
| } |
| |
| $db->commit_transaction(); |
| |
| header("Location: telbook_categories_list.php"); |
| $g_display->add_text('Information saved successfully'); |
| } |