1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
|
/*
* This file is part of the xTuple ERP: PostBooks Edition, a free and
* open source Enterprise Resource Planning software suite,
* Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
* It is licensed to you under the Common Public Attribution License
* version 1.0, the full text of which (including xTuple-specific Exhibits)
* is available at www.xtuple.com/CPAL. By using this software, you agree
* to be bound by its terms.
*/
#include "postCostsByClassCode.h"
#include <QSqlError>
#include <QVariant>
postCostsByClassCode::postCostsByClassCode(QWidget* parent, const char* name, bool modal, Qt::WindowFlags fl)
: XDialog(parent, name, modal, fl)
{
setupUi(this);
// signals and slots connections
connect(_post, SIGNAL(clicked()), this, SLOT(sPost()));
connect(_selectAll, SIGNAL(clicked()), this, SLOT(sSelectAll()));
connect(_close, SIGNAL(clicked()), this, SLOT(reject()));
_classCode->setType(ParameterGroup::ClassCode);
if (!_metrics->boolean("Routings"))
{
_directLabor->hide();
_lowerDirectLabor->hide();
_overhead->hide();
_lowerOverhead->hide();
_machOverhead->hide();
_lowerMachOverhead->hide();
}
else if (_metrics->value("TrackMachineOverhead") != "M")
{
_machOverhead->setEnabled(false);
_machOverhead->setChecked(true);
_lowerMachOverhead->setEnabled(false);
_lowerMachOverhead->setChecked(true);
}
}
postCostsByClassCode::~postCostsByClassCode()
{
// no need to delete child widgets, Qt does it all for us
}
void postCostsByClassCode::languageChange()
{
retranslateUi(this);
}
void postCostsByClassCode::sSelectAll()
{
_material->setChecked(true);
_lowerMaterial->setChecked(true);
_user->setChecked(true);
_lowerUser->setChecked(true);
if (_metrics->boolean("Routings"))
{
_directLabor->setChecked(true);
_lowerDirectLabor->setChecked(true);
_overhead->setChecked(true);
_lowerOverhead->setChecked(true);
if (_metrics->value("TrackMachineOverhead") == "M")
{
_machOverhead->setChecked(true);
_lowerMachOverhead->setChecked(true);
}
}
}
void postCostsByClassCode::sPost()
{
XSqlQuery postPost;
QString sql = "SELECT doPostCosts(item_id, true, :material, :lowMaterial, "
" :directLabor, :lowDirectLabor, :overhead, :lowOverhead, "
" :machOverhead, :lowMachOverhead, :user, :lowUser, :rollUp) "
" FROM item, classcode "
" WHERE(item_classcode_id=classcode_id)";
if (_classCode->isSelected())
sql += " AND (item_classcode_id=:classcode_id);";
else if (_classCode->isPattern())
sql += " AND (classcode_code ~ :classcode_pattern);";
else
sql = "SELECT doPostCosts(:material, :lowMaterial, "
" :directLabor, :lowDirectLabor, :overhead, :lowOverhead, "
" :machOverhead, :lowMachOverhead, :user, :lowUser, :rollUp);";
postPost.prepare(sql);
postPost.bindValue(":material", _material->isChecked() ? "t" : "f");
postPost.bindValue(":lowMaterial", _lowerMaterial->isChecked() ? "t" : "f");
postPost.bindValue(":directLabor", _directLabor->isChecked() ? "t" : "f");
postPost.bindValue(":lowDirectLabor", _lowerDirectLabor->isChecked() ? "t" : "f");
postPost.bindValue(":overhead", _overhead->isChecked() ? "t" : "f");
postPost.bindValue(":lowOverhead", _lowerOverhead->isChecked() ? "t" : "f");
postPost.bindValue(":machOverhead", _machOverhead->isChecked() ? "t" : "f");
postPost.bindValue(":lowMachOverhead", _lowerMachOverhead->isChecked() ? "t" : "f");
postPost.bindValue(":user", _user->isChecked() ? "t" : "f");
postPost.bindValue(":lowUser", _lowerUser->isChecked() ? "t" : "f");
postPost.bindValue(":rollUp", _rollUp->isChecked() ? "t" : "f");
_classCode->bindValue(postPost);
postPost.exec();
if (postPost.lastError().type() != QSqlError::NoError)
{
systemError(this, postPost.lastError().databaseText(), __FILE__, __LINE__);
return;
}
accept();
}
|
