GNCSearchWindow *
gnc_ui_find_transactions_dialog_create2 (GNCLedgerDisplay2 * orig_ledg)
{
QofIdType type = GNC_ID_SPLIT;
struct _ftd_data *ftd;
static GList *params = NULL;
QofQuery *start_q, *show_q = NULL;
gboolean num_action =
qof_book_use_split_action_for_num_field(gnc_get_current_book());
/* Build parameter list in reverse order */
if (params == NULL)
{
params = gnc_search_param_prepend (params, N_("All Accounts"),
ACCOUNT_MATCH_ALL_TYPE,
type, SPLIT_TRANS, TRANS_SPLITLIST,
SPLIT_ACCOUNT_GUID, NULL);
params = gnc_search_param_prepend (params, N_("Account"), GNC_ID_ACCOUNT,
type, SPLIT_ACCOUNT, QOF_PARAM_GUID,
NULL);
params = gnc_search_param_prepend (params, N_("Balanced"), NULL,
type, SPLIT_TRANS, TRANS_IS_BALANCED,
NULL);
params = gnc_search_param_prepend (params, N_("Reconcile"), RECONCILED_MATCH_TYPE,
type, SPLIT_RECONCILE, NULL);
params = gnc_search_param_prepend (params, N_("Share Price"), NULL,
type, SPLIT_SHARE_PRICE, NULL);
params = gnc_search_param_prepend (params, N_("Shares"), NULL,
type, SPLIT_AMOUNT, NULL);
params = gnc_search_param_prepend (params, N_("Value"), NULL,
type, SPLIT_VALUE, NULL);
params = gnc_search_param_prepend (params, N_("Date Posted"), NULL,
type, SPLIT_TRANS, TRANS_DATE_POSTED,
NULL);
params = gnc_search_param_prepend (params, N_("Notes"), NULL,
type, SPLIT_TRANS, TRANS_NOTES, NULL);
params = gnc_search_param_prepend (params, (num_action
? N_("Number/Action")
: N_("Action")), NULL,
type, SPLIT_ACTION, NULL);
params = gnc_search_param_prepend (params, (num_action
? N_("Transaction Number")
: N_("Number")), NULL,
type, SPLIT_TRANS, TRANS_NUM, NULL);
params = gnc_search_param_prepend (params, N_("Memo"), NULL,
type, SPLIT_MEMO, NULL);
params = gnc_search_param_prepend (params, N_("Description"), NULL,
type, SPLIT_TRANS, TRANS_DESCRIPTION,
NULL);
}
else
{
GList *l;
for (l = params; l; l = l->next)
{
GNCSearchParam *param = l->data;
if (num_action)
{
if (strcmp (param->title, N_("Action")) == 0)
gnc_search_param_set_title (param, N_("Number/Action"));
if (strcmp (param->title, N_("Number")) == 0)
gnc_search_param_set_title (param, N_("Transaction Number"));
}
else
{
if (strcmp (param->title, N_("Number/Action")) == 0)
gnc_search_param_set_title (param, N_("Action"));
if (strcmp (param->title, N_("Transaction Number")) == 0)
gnc_search_param_set_title (param, N_("Number"));
}
}
}
ftd = g_new0 (struct _ftd_data, 1);
if (orig_ledg)
{
ftd->ledger_q = gnc_ledger_display2_get_query (orig_ledg);
start_q = show_q = qof_query_copy (ftd->ledger_q);
}
else
{
start_q = qof_query_create ();
qof_query_set_book (start_q, gnc_get_current_book ());
/* In lieu of not "mis-using" some portion of the infrastructure by writing
* a bunch of new code, we just filter out the accounts of the template
* transactions. While these are in a seperate Account trees just for this
* reason, the query engine makes no distinction between Account trees.
* See Gnome Bug 86302.
* -- jsled
*
* copied from gnc-ledger-display2.c:gnc_ledger_display2_gl() -- warlord
*
* <jsled> Alternatively, you could look for a GNC_SX_ACCOUNT [SchedAction.h]
* key in the KVP frame of the split.
*/
{
Account *tRoot;
GList *al;
tRoot = gnc_book_get_template_root( gnc_get_current_book() );
al = gnc_account_get_descendants( tRoot );
xaccQueryAddAccountMatch( start_q, al, QOF_GUID_MATCH_NONE, QOF_QUERY_AND );
g_list_free (al);
al = NULL;
tRoot = NULL;
}
ftd->q = start_q; /* save this to destroy it later */
}
ftd->sw = gnc_search_dialog_create (type, _("Find Transaction"),
params, NULL, start_q, show_q,
NULL, do_find_cb, NULL,
ftd, free_ftd_cb, GNC_PREFS_GROUP_SEARCH, NULL);
if (!ftd->sw)
{
free_ftd_cb (ftd);
return NULL;
}
return ftd->sw;
}
GNCSearchWindow *
gnc_job_search (GncJob *start, GncOwner *owner, QofBook *book)
{
QofQuery *q, *q2 = NULL;
QofIdType type = GNC_JOB_MODULE_NAME;
struct _job_select_window *sw;
static GList *params = NULL;
static GList *columns = NULL;
static GNCSearchCallbackButton buttons[] =
{
{ N_("View/Edit Job"), edit_job_cb, NULL, TRUE},
{ N_("View Invoices"), invoice_job_cb, NULL, TRUE},
{ N_("Process Payment"), payment_job_cb, NULL, FALSE},
{ NULL },
};
g_return_val_if_fail (book, NULL);
/* Build parameter list in reverse order */
if (params == NULL)
{
params = gnc_search_param_prepend (params, _("Owner's Name"), NULL, type,
JOB_OWNER, OWNER_NAME, NULL);
params = gnc_search_param_prepend (params, _("Only Active?"), NULL, type,
JOB_ACTIVE, NULL);
params = gnc_search_param_prepend (params, _("Billing ID"), NULL, type,
JOB_REFERENCE, NULL);
params = gnc_search_param_prepend (params, _("Job Number"), NULL, type,
JOB_ID, NULL);
params = gnc_search_param_prepend (params, _("Job Name"), NULL, type,
JOB_NAME, NULL);
}
/* Build the column list in reverse order */
if (columns == NULL)
{
columns = gnc_search_param_prepend (columns, _("Billing ID"), NULL, type,
JOB_REFERENCE, NULL);
columns = gnc_search_param_prepend (columns, _("Company"), NULL, type,
JOB_OWNER, OWNER_NAME, NULL);
columns = gnc_search_param_prepend (columns, _("Job Name"), NULL, type,
JOB_NAME, NULL);
columns = gnc_search_param_prepend (columns, _("ID #"), NULL, type,
JOB_ID, NULL);
}
/* Build the queries */
q = qof_query_create_for (type);
qof_query_set_book (q, book);
/* If we have a start job but, for some reason, not an owner -- grab
* the owner from the starting job.
*/
if ((!owner || !gncOwnerGetGUID (owner)) && start)
owner = gncJobGetOwner (start);
/* If owner is supplied, limit all searches to invoices who's owner
* is the supplied owner! Show all invoices by this owner.
*/
if (owner && gncOwnerGetGUID (owner))
{
qof_query_add_guid_match (q, g_slist_prepend
(g_slist_prepend (NULL, QOF_PARAM_GUID),
JOB_OWNER),
gncOwnerGetGUID (owner), QOF_QUERY_AND);
q2 = qof_query_copy (q);
}
#if 0
if (start)
{
if (q2 == NULL)
q2 = qof_query_copy (q);
qof_query_add_guid_match (q2, g_slist_prepend (NULL, QOF_PARAM_GUID),
gncJobGetGUID (start), QOF_QUERY_AND);
}
#endif
/* launch select dialog and return the result */
sw = g_new0 (struct _job_select_window, 1);
if (owner)
{
gncOwnerCopy (owner, &(sw->owner_def));
sw->owner = &(sw->owner_def);
}
sw->book = book;
sw->q = q;
return gnc_search_dialog_create (type, _("Find Job"),
params, columns, q, q2, buttons, NULL,
new_job_cb, sw, free_userdata_cb,
GCONF_SECTION_SEARCH, NULL);
}
GNCSearchWindow *
gnc_customer_search (GncCustomer *start, QofBook *book)
{
QofQuery *q, *q2 = NULL;
QofIdType type = GNC_CUSTOMER_MODULE_NAME;
struct _customer_select_window *sw;
static GList *params = NULL;
static GList *columns = NULL;
static GNCSearchCallbackButton buttons[] =
{
{ N_("View/Edit Customer"), edit_customer_cb, NULL, TRUE},
{ N_("Customer's Jobs"), jobs_customer_cb, NULL, TRUE},
// { N_("Customer's Orders"), order_customer_cb, NULL, TRUE},
{ N_("Customer's Invoices"), invoice_customer_cb, NULL, TRUE},
{ N_("Process Payment"), payment_customer_cb, NULL, FALSE},
{ NULL },
};
(void)order_customer_cb;
g_return_val_if_fail (book, NULL);
/* Build parameter list in reverse order */
if (params == NULL)
{
params = gnc_search_param_prepend (params, _("Shipping Contact"), NULL, type,
CUSTOMER_SHIPADDR, ADDRESS_NAME, NULL);
params = gnc_search_param_prepend (params, _("Billing Contact"), NULL, type,
CUSTOMER_ADDR, ADDRESS_NAME, NULL);
params = gnc_search_param_prepend (params, _("Customer ID"), NULL, type,
CUSTOMER_ID, NULL);
params = gnc_search_param_prepend (params, _("Company Name"), NULL, type,
CUSTOMER_NAME, NULL);
}
/* Build the column list in reverse order */
if (columns == NULL)
{
columns = gnc_search_param_prepend (columns, _("Contact"), NULL, type,
CUSTOMER_ADDR, ADDRESS_NAME, NULL);
columns = gnc_search_param_prepend (columns, _("Company"), NULL, type,
CUSTOMER_NAME, NULL);
columns = gnc_search_param_prepend (columns, _("ID #"), NULL, type,
CUSTOMER_ID, NULL);
}
/* Build the queries */
q = qof_query_create_for (type);
qof_query_set_book (q, book);
#if 0
if (start)
{
q2 = qof_query_copy (q);
qof_query_add_guid_match (q2, g_slist_prepend (NULL, QOF_PARAM_GUID),
gncCustomerGetGUID (start), QOF_QUERY_AND);
}
#endif
/* launch select dialog and return the result */
sw = g_new0 (struct _customer_select_window, 1);
sw->book = book;
sw->q = q;
return gnc_search_dialog_create (type, _("Find Customer"),
params, columns, q, q2, buttons, NULL,
new_customer_cb, sw, free_userdata_cb,
GCONF_SECTION_SEARCH, NULL);
}
GNCSearchWindow *
gnc_employee_search (GncEmployee *start, QofBook *book)
{
QofIdType type = GNC_EMPLOYEE_MODULE_NAME;
struct _employee_select_window *sw;
QofQuery *q, *q2 = NULL;
static GList *params = NULL;
static GList *columns = NULL;
static GNCSearchCallbackButton buttons[] =
{
{ N_("View/Edit Employee"), edit_employee_cb, NULL, TRUE},
{ N_("Expense Vouchers"), invoice_employee_cb, NULL, TRUE},
{ N_("Process Payment"), payment_employee_cb, NULL, FALSE},
{ NULL },
};
g_return_val_if_fail (book, NULL);
/* Build parameter list in reverse order */
if (params == NULL)
{
params = gnc_search_param_prepend (params, _("Employee ID"), NULL, type,
EMPLOYEE_ID, NULL);
params = gnc_search_param_prepend (params, _("Employee Username"), NULL,
type, EMPLOYEE_USERNAME, NULL);
params = gnc_search_param_prepend (params, _("Employee Name"), NULL,
type, EMPLOYEE_ADDR, ADDRESS_NAME, NULL);
}
/* Build the column list in reverse order */
if (columns == NULL)
{
columns = gnc_search_param_prepend (columns, _("Username"), NULL, type,
EMPLOYEE_USERNAME, NULL);
columns = gnc_search_param_prepend (columns, _("ID #"), NULL, type,
EMPLOYEE_ID, NULL);
columns = gnc_search_param_prepend (columns, _("Name"), NULL, type,
EMPLOYEE_ADDR, ADDRESS_NAME, NULL);
}
/* Build the queries */
q = qof_query_create_for (type);
qof_query_set_book (q, book);
#if 0
if (start)
{
q2 = qof_query_copy (q);
qof_query_add_guid_match (q2, g_slist_prepend (NULL, QOF_PARAM_GUID),
gncEmployeeGetGUID (start), QOF_QUERY_AND);
}
#endif
/* launch select dialog and return the result */
sw = g_new0 (struct _employee_select_window, 1);
sw->book = book;
sw->q = q;
return gnc_search_dialog_create (type, _("Find Employee"),
params, columns, q, q2,
buttons, NULL, new_employee_cb,
sw, free_employee_cb,
GNC_PREFS_GROUP_SEARCH, NULL);
}