1 #======================================================================
4 #======================================================================
6 # Saving and loading drafts
8 #======================================================================
18 $main::lxdebug->enter_sub();
20 my ($self, $form) = @_;
22 my ($module, $submodule);
24 $module = $form->{"script"};
26 if (grep({ $module eq $_ } qw(is ir ar ap))) {
27 $submodule = "invoice";
29 $submodule = "unknown";
32 $main::lxdebug->leave_sub();
34 return ($module, $submodule);
38 $main::lxdebug->enter_sub();
40 my ($self, $myconfig, $form, $draft_id, $draft_description) = @_;
42 my ($dbh, $sth, $query, %saved, @dont_save, $dumped);
44 $dbh = $form->dbconnect_noauto($myconfig);
46 my ($module, $submodule) = $self->get_module($form);
48 $query = "SELECT COUNT(*) FROM drafts WHERE id = ?";
49 my ($res) = selectrow_query($form, $dbh, $query, $draft_id);
52 $draft_id = $module . "-" . $submodule . "-" . Common::unique_id();
53 $query = "INSERT INTO drafts (id, module, submodule) VALUES (?, ?, ?)";
54 do_query($form, $dbh, $query, $draft_id, $module, $submodule);
57 @dont_save = qw(login password action);
58 map({ $saved{$_} = $form->{$_};
59 delete($form->{$_}); } @dont_save);
61 $dumped = YAML::Dump($form);
62 map({ $form->{$_} = $saved{$_}; } @dont_save);
65 qq|UPDATE drafts SET description = ?, form = ?, employee_id = | .
66 qq| (SELECT id FROM employee WHERE login = ?) | .
69 do_query($form, $dbh, $query, $draft_description, $dumped, $form->{login}, $draft_id);
74 $form->{draft_id} = $draft_id;
75 $form->{draft_description} = $draft_description;
77 $main::lxdebug->leave_sub();
81 $main::lxdebug->enter_sub();
83 my ($self, $myconfig, $form, $draft_id) = @_;
85 my ($dbh, $sth, $query, @values);
87 $dbh = $form->dbconnect($myconfig);
89 $query = qq|SELECT id, description, form FROM drafts WHERE id = ?|;
91 $sth = prepare_execute_query($form, $dbh, $query, $draft_id);
94 if (my $ref = $sth->fetchrow_hashref()) {
95 @values = ($ref->{form}, $ref->{id}, $ref->{description});
101 $main::lxdebug->leave_sub();
107 $main::lxdebug->enter_sub();
109 my ($self, $myconfig, $form, @draft_ids) = @_;
111 return $main::lxdebug->leave_sub() unless (@draft_ids);
113 my ($dbh, $sth, $query);
115 $dbh = $form->dbconnect($myconfig);
117 $query = qq|DELETE FROM drafts WHERE id IN (| . join(", ", map { "?" } @draft_ids) . qq|)|;
118 do_query($form, $dbh, $query, @draft_ids);
122 $main::lxdebug->leave_sub();
126 $main::lxdebug->enter_sub();
128 my ($self, $myconfig, $form) = @_;
130 my ($dbh, $sth, $query, @values);
132 $dbh = $form->dbconnect($myconfig);
134 my ($module, $submodule) = $self->get_module($form);
138 qq|SELECT d.id, d.description, d.itime::timestamp(0) AS itime, | .
139 qq| e.name AS employee_name | .
141 qq|LEFT JOIN employee e ON d.employee_id = e.id | .
142 qq|WHERE (d.module = ?) AND (d.submodule = ?) | .
143 qq|ORDER BY d.itime|;
144 my @values = ($module, $submodule);
146 $sth = prepare_execute_query($form, $dbh, $query, @values);
148 while (my $ref = $sth->fetchrow_hashref()) {
155 $main::lxdebug->leave_sub();