void employee::sEditCharass() { ParameterList params; params.append("mode", "edit"); params.append("charass_id", _charass->id()); characteristicAssignment newdlg(this, "", TRUE); newdlg.set(params); if (newdlg.exec() != XDialog::Rejected) sFillCharassList(); }
void employee::sNewCharass() { ParameterList params; params.append("mode", "new"); params.append("emp_id", _empid); characteristicAssignment newdlg(this, "", TRUE); newdlg.set(params); if (newdlg.exec() != XDialog::Rejected) sFillCharassList(); }
void employee::sDeleteCharass() { XSqlQuery delq; delq.prepare("DELETE FROM charass WHERE (charass_id=:charass_id);"); delq.bindValue(":charass_id", _charass->id()); delq.exec(); if (ErrorReporter::error(QtCriticalMsg, this, tr("Error deleting Characteristic Assignment"), delq, __FILE__, __LINE__)) return; sFillCharassList(); }
void employee::sDeleteCharass() { q.prepare( "DELETE FROM charass " "WHERE (charass_id=:charass_id);" ); q.bindValue(":charass_id", _charass->id()); q.exec(); if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } sFillCharassList(); }
void employee::sPopulate() { q.prepare("SELECT *, curr_id, curr_abbr " "FROM api.employee LEFT OUTER JOIN" " curr_symbol ON (wage_currency = curr_abbr) " "WHERE (code=:code);"); q.bindValue(":code", _empcode); q.exec(); if (q.first()) { _code->setText(q.value("code").toString()); _number->setText(q.value("number").toString()); _active->setChecked(q.value("active").toBool()); _startDate->setDate(q.value("start_date").toDate()); _contact->setNumber(q.value("contact_number").toString()); _contact->setHonorific(q.value("honorific").toString()); _contact->setFirst(q.value("first").toString()); _contact->setLast(q.value("last").toString()); _contact->setTitle(q.value("job_title").toString()); _contact->setPhone(q.value("voice").toString()); _contact->setPhone2(q.value("alternate").toString()); _contact->setFax(q.value("fax").toString()); _contact->setEmailAddress(q.value("email").toString()); _contact->setWebAddress(q.value("web").toString()); _contact->addressWidget()->setLine1(q.value("address1").toString()); _contact->addressWidget()->setLine2(q.value("address2").toString()); _contact->addressWidget()->setLine3(q.value("address3").toString()); _contact->addressWidget()->setCity(q.value("city").toString()); _contact->addressWidget()->setState(q.value("state").toString()); _contact->addressWidget()->setPostalCode(q.value("postalcode").toString()); _contact->addressWidget()->setCountry(q.value("country").toString()); _site->setCode(q.value("site").toString()); _mgr->setNumber(q.value("manager_code").toString()); _wagetype->setCode(q.value("wage_type").toString()); _rate->set(q.value("wage").toDouble(), q.value("curr_id").toInt(), QDate::currentDate()); _externalRate->set(q.value("rate").toDouble(), q.value("curr_id").toInt(), QDate::currentDate()); _currabbr = q.value("curr_abbr").toString(); _per->setCode(q.value("wage_period").toString()); _perExt->setCode(q.value("billing_period").toString()); _dept->setNumber(q.value("department").toString()); _shift->setNumber(q.value("shift").toString()); _user->setChecked(q.value("is_user").toBool()); _salesrep->setChecked(q.value("is_salesrep").toBool()); _vendor->setChecked(q.value("is_vendor").toBool()); _notes->setText(q.value("notes").toString()); _image->setNumber(q.value("image").toString()); _user->setEnabled(_createUsers && ! _user->isChecked()); _userButton->setEnabled(_privileges->check("MaintainUsers") && _user->isChecked()); _salesrep->setEnabled(_privileges->check("MaintainSalesReps") && ! _salesrep->isChecked()); _salesrepButton->setEnabled((_privileges->check("MaintainSalesReps") || _privileges->check("ViewSalesReps")) && _salesrep->isChecked()); _vendor->setEnabled(_privileges->check("MaintainVendors") && ! _vendor->isChecked()); _vendorButton->setEnabled((_privileges->check("MaintainVendors") || _privileges->check("ViewVendors")) && _vendor->isChecked()); if (DEBUG) qDebug("image %s and %s", qPrintable(q.value("image").toString()), qPrintable(_image->number())); sFillCharassList(); sFillGroupsList(); _comments->setId(_empid); _comments->setReadOnly(_empid==-1); emit populated(); } else if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } }
bool employee::sPopulate() { XSqlQuery getq; if (_empid > 0) { getq.prepare("SELECT emp.*, crmacct_id, crmacct_owner_username," " crmacct_salesrep_id, crmacct_usr_username, crmacct_vend_id" " FROM emp JOIN crmacct ON (emp_id=crmacct_emp_id)" " WHERE (emp_id=:id);"); getq.bindValue(":id", _empid); } else if (_crmacctid > 0) { getq.prepare("SELECT crmacct_number AS emp_code, NULL AS emp_number," " crmacct_name AS emp_name," " crmacct_active AS emp_active," " crmacct_cntct_id_1 AS emp_cntct_id," " NULL AS emp_startdate, NULL AS emp_mgr_emp_id," " NULL AS emp_warehous_id, NULL AS emp_wage_type," " NULL AS emp_wage, NULL AS emp_wage_curr_id," " NULL AS emp_extrate, NULL AS emp_wage_period," " NULL AS emp_extrate_period, NULL AS emp_dept_id," " NULL AS emp_shift_id, NULL AS emp_notes," " NULL AS emp_image_id," "crmacct_id, crmacct_owner_username" " FROM crmacct" " WHERE (crmacct_id=:id);"); getq.bindValue(":id", _crmacctid); } getq.exec(); if (getq.first()) { _code->setText(getq.value("emp_code").toString()); _name->setText(getq.value("emp_name").toString()); _number->setText(getq.value("emp_number").toString()); _active->setChecked(getq.value("emp_active").toBool()); _startDate->setDate(getq.value("emp_startdate").toDate()); _contact->setId(getq.value("emp_cntct_id").toInt()); _site->setId(getq.value("emp_warehous_id").toInt()); _mgr->setId(getq.value("emp_mgr_emp_id").toInt()); _wagetype->setCode(getq.value("emp_wage_type").toString()); _rate->set(getq.value("emp_wage").toDouble(), getq.value("emp_wage_curr_id").toInt(), QDate::currentDate()); _externalRate->set(getq.value("emp_extrate").toDouble(), getq.value("emp_wage_curr_id").toInt(), QDate::currentDate()); _per->setCode(getq.value("emp_wage_period").toString()); _perExt->setCode(getq.value("emp_extrate_period").toString()); _dept->setId(getq.value("emp_dept_id").toInt()); _shift->setId(getq.value("emp_shift_id").toInt()); _notes->setText(getq.value("emp_notes").toString()); _image->setId(getq.value("emp_image_id").toInt()); _crmacctid = getq.value("crmacct_id").toInt(); _crmowner = getq.value("crmacct_owner_username").toString(); if (DEBUG) qDebug("image %s and %s", qPrintable(getq.value("image").toString()), qPrintable(_image->number())); sFillCharassList(); sFillGroupsList(); _comments->setId(_empid); _comments->setReadOnly(_empid==-1); emit populated(); } else if (ErrorReporter::error(QtCriticalMsg, this, tr("Error getting Employee"), getq, __FILE__, __LINE__)) return false; sHandleButtons(); return true; }