winamp/Src/Plugins/Library/ml_local/editquery.cpp

1013 lines
42 KiB
C++
Raw Permalink Normal View History

2024-09-24 12:54:57 +00:00
#include "main.h"
#include "ml_local.h"
#include <windowsx.h>
#include "editquery.h"
#include "../nde/NDE.h"
#include "resource.h"
#include "..\..\General\gen_ml/gaystring.h"
#include "time.h"
#include "../Agave/Language/api_language.h"
#include "../replicant/nu/AutoChar.h"
#define ListBox_GetTextLenW(hwndCtl, index) ((int)(DWORD)SendMessageW((hwndCtl), LB_GETTEXTLEN, (WPARAM)(int)(index), 0L))
#define ListBox_GetTextW(hwndCtl, index, lpszBuffer) ((int)(DWORD)SendMessageW((hwndCtl), LB_GETTEXT, (WPARAM)(int)(index), (LPARAM)(LPCWSTR)(lpszBuffer)))
int myatoi(wchar_t *p, int len) {
wchar_t *w = (wchar_t *)calloc((len+1), sizeof(wchar_t));
if (w)
{
wcsncpy(w, p, len);
w[len] = 0;
int a = _wtoi(w);
free(w);
return a;
}
return 0;
}
static wchar_t *monthtable[12] = {L"January", L"February", L"March", L"April", L"May", L"June", L"July", L"August", L"September", L"October", L"November", L"December" };
INT_PTR CALLBACK editQueryDialogProc(HWND hwndDlg, UINT uMsg, WPARAM wParam,LPARAM lParam);
INT_PTR CALLBACK editDateTimeDialogProc(HWND hwndDlg, UINT uMsg, WPARAM wParam,LPARAM lParam);
static wchar_t *qe_field = NULL;
static GayStringW qe_curquery;
static GayStringW qe_curexpr;
static GayStringW qe_origquery;
static GayStringW qe_curorigin;
static GayStringW qe_curdate;
void qe_freeStuff() {
qe_curquery.Set(L"");
qe_curquery.Compact();
qe_curexpr.Set(L"");
qe_curexpr.Compact();
qe_curorigin.Set(L"");
qe_curorigin.Compact();
qe_origquery.Set(L"");
qe_origquery.Compact();
}
static GayStringW te_ret;
static GayStringW te_result;
int te_cur_selected_month=0;
const wchar_t *editTime(HWND wnd, const wchar_t *curfield) {
te_ret.Set(curfield);
TimeParse tp;
NDE_Time_ApplyConversion(0, curfield, &tp);
if (tp.relative_day == -2 || tp.relative_kwday != -1) {
wchar_t titleStr[64] = {0};
int r = MessageBoxW(wnd, WASABI_API_LNGSTRINGW(IDS_DATE_TIME_IS_TOO_COMPLEX),
WASABI_API_LNGSTRINGW_BUF(IDS_DATE_TIME_EDITOR_QUESTION,titleStr,64), MB_YESNO);
if (r == IDNO) {
return curfield;
}
}
INT_PTR r = WASABI_API_DIALOGBOXW(IDD_TIMEEDITOR, wnd, editDateTimeDialogProc);
if (r == IDOK) {
te_ret.Set(te_result.Get());
return te_ret.Get();
}
return NULL;
}
const wchar_t *editQuery(HWND wnd, const wchar_t *curquery, wchar_t *newQuery, size_t len)
{
qe_field = NULL;
qe_curquery.Set(curquery);
qe_origquery.Set(curquery);
INT_PTR r = WASABI_API_DIALOGBOXW(IDD_EDIT_QUERY, wnd, editQueryDialogProc);
if (qe_field) free(qe_field);
if (r == IDOK)
{
lstrcpynW(newQuery, qe_curquery.Get(), len);
qe_freeStuff();
return newQuery;
}
qe_freeStuff();
return NULL;
}
static bool FillListProc(Record *record, Field *entry, void *context)
{
HWND hwndDlg = (HWND)context;
SendMessage(hwndDlg, LB_ADDSTRING, 0, (LPARAM)NDE_ColumnField_GetFieldName((nde_field_t)entry));
return true;
}
void qe_fillFieldsList( HWND hwndDlg )
{
ListBox_ResetContent( hwndDlg );
Record *cr = ( (Table *)g_table )->GetColumns(); // TODO: don't use C++ NDE API
if ( cr )
{
cr->WalkFields( FillListProc, (void *)hwndDlg );
}
int len = ListBox_GetTextLenW( hwndDlg, 0 );
if ( qe_field != NULL )
free( qe_field );
qe_field = (wchar_t *)calloc( ( len + 1 ), sizeof( wchar_t ) );
ListBox_GetTextW( hwndDlg, 0, qe_field );
qe_field[ len ] = 0;
ListBox_SetCurSel( hwndDlg, 0 );
}
void qe_doEnableDisable( HWND hwndDlg, int *n, int num, int how )
{
for ( int i = 0; i < num; i++ )
EnableWindow( GetDlgItem( hwndDlg, n[ i ] ), how );
}
void qe_enableDisableItem( HWND hwndDlg, int id, int tf )
{
EnableWindow( GetDlgItem( hwndDlg, id ), tf );
}
void qe_fallback( HWND hwndDlg, int disabling, int enabled )
{
if ( IsDlgButtonChecked( hwndDlg, disabling ) )
{
CheckDlgButton( hwndDlg, disabling, BST_UNCHECKED );
CheckDlgButton( hwndDlg, enabled, BST_CHECKED );
}
}
int ctrls_datetime[] = {IDC_STATIC_DATETIME, IDC_EDIT_DATETIME, IDC_BUTTON_EDITDATETIME, IDC_STATIC_CURDATETIME};
int ctrls_datetime_base[] = {IDC_STATIC_DATETIME, IDC_CHECK_ABSOLUTE, IDC_CHECK_RELATIVE};
int ctrls_datetime_relative[] = {IDC_CHECK_SELECTIVE, IDC_CHECK_TIMEAGO, IDC_STATIC_QUERYTIME, IDC_STATIC_RESULT};
int ctrls_datetime_relative_ago[] = {IDC_STATIC_TIMEAGO, IDC_EDIT_TIMEAGO, IDC_RADIO_TIMEAGO_Y,
IDC_RADIO_TIMEAGO_H, IDC_RADIO_TIMEAGO_M, IDC_RADIO_TIMEAGO_MIN, IDC_RADIO_TIMEAGO_W, IDC_RADIO_TIMEAGO_S,
IDC_RADIO_TIMEAGO_D};
int ctrls_datetime_relative_ago_direction[] = {IDC_STATIC_DIRECTION, IDC_RADIO_AFTER, IDC_RADIO_BEFORE};
int ctrls_datetime_relative_selective[] = {IDC_STATIC_SELECTIVE, IDC_STATIC_YEAR, IDC_RADIO_THISYEAR,
IDC_RADIO_YEAR, IDC_EDIT_YEAR, IDC_STATIC_MONTH, IDC_RADIO_THISMONTH, IDC_RADIO_MONTH, IDC_BUTTON_MONTH,
IDC_STATIC_DAY, IDC_RADIO_THISDAY, IDC_RADIO_DAY, IDC_EDIT_DAY, IDC_STATIC_TIME, IDC_RADIO_THISTIME,
IDC_RADIO_TIME, IDC_RADIO_NOON, IDC_RADIO_MIDNIGHT, IDC_BUTTON_NOW, IDC_BUTTON_PICK, IDC_DATETIMEPICKER2};
int ctrls_datetime_absolute[] = {IDC_STATIC_ABSOLUTE, IDC_DATETIMEPICKER, IDC_DATETIMEPICKER1, IDC_STATIC_RELATIVE};
int ctrls_string_ops[] = {IDC_RADIO_ISLIKE, IDC_RADIO_BEGINS, IDC_RADIO_ENDS, IDC_RADIO_CONTAINS};
int ctrls_string[] = {IDC_STATIC_STRING, IDC_EDIT_STRING};
void qe_showHideOperators(HWND hwndDlg) {
if (!qe_curquery.Get() || !*qe_curquery.Get()) {
ShowWindow(GetDlgItem(hwndDlg, IDC_BUTTON_AND), SW_HIDE);
ShowWindow(GetDlgItem(hwndDlg, IDC_BUTTON_OR), SW_HIDE);
ShowWindow(GetDlgItem(hwndDlg, ID_BUTTON_SENDTOQUERY), SW_SHOW);
} else {
ShowWindow(GetDlgItem(hwndDlg, IDC_BUTTON_AND), SW_SHOW);
ShowWindow(GetDlgItem(hwndDlg, IDC_BUTTON_OR), SW_SHOW);
ShowWindow(GetDlgItem(hwndDlg, ID_BUTTON_SENDTOQUERY), SW_HIDE);
}
}
void qe_updateResultingDate(HWND hwndDlg) {
if (IsWindowEnabled(GetDlgItem(hwndDlg, IDC_EDIT_DATETIME)) && !IsDlgButtonChecked(hwndDlg, IDC_RADIO_ISEMPTY)) {
time_t t = NDE_Time_ApplyConversion(0, qe_curdate.Get(), 0);
struct tm *ts = localtime(&t);
wchar_t qe_tempstr[4096] = {0};
if (ts)
wsprintfW(qe_tempstr, L"%02d/%d/%04d %02d:%02d:%02d", ts->tm_mon+1, ts->tm_mday, ts->tm_year+1900, ts->tm_hour, ts->tm_min, ts->tm_sec);
else
wcsncpy(qe_tempstr, L"DATE_OUTOFRANGE", 4096);
SetDlgItemTextW(hwndDlg, IDC_STATIC_CURDATETIME, qe_tempstr);
} else {
SetDlgItemTextW(hwndDlg, IDC_STATIC_CURDATETIME, L"N/A");
}
}
void te_updateResultingDate(HWND hwndDlg) {
if (IsDlgButtonChecked(hwndDlg, IDC_CHECK_RELATIVE)) {
time_t t = NDE_Time_ApplyConversion(0, qe_curorigin.Get(), 0);
struct tm *ts = localtime(&t);
wchar_t qe_tempstr[4096] = {0};
if (ts)
wsprintfW(qe_tempstr, L"%02d/%d/%04d %02d:%02d:%02d", ts->tm_mon+1, ts->tm_mday, ts->tm_year+1900, ts->tm_hour, ts->tm_min, ts->tm_sec);
else
wcsncpy(qe_tempstr, L"DATE_OUTOFRANGE", 4096);
SetDlgItemTextW(hwndDlg, IDC_STATIC_QUERYTIME, qe_tempstr);
} else {
SetDlgItemTextW(hwndDlg, IDC_STATIC_QUERYTIME, L"N/A");
}
}
void qe_enableDisable(HWND hwndDlg) {
if (!*qe_field) return;
nde_field_t field = NDE_Table_GetColumnByName(g_table, AutoChar(qe_field));
if (!field) return;
int type = NDE_ColumnField_GetDataType(field);
qe_showHideOperators(hwndDlg);
switch (type) {
case FIELD_DATETIME: {
qe_fallback(hwndDlg, IDC_RADIO_ISLIKE, IDC_RADIO_EQUAL);
qe_fallback(hwndDlg, IDC_RADIO_BEGINS, IDC_RADIO_EQUAL);
qe_fallback(hwndDlg, IDC_RADIO_ENDS, IDC_RADIO_EQUAL);
qe_fallback(hwndDlg, IDC_RADIO_CONTAINS, IDC_RADIO_EQUAL);
qe_doEnableDisable(hwndDlg, ctrls_string, sizeof(ctrls_string)/sizeof(int), 0);
qe_doEnableDisable(hwndDlg, ctrls_string_ops, sizeof(ctrls_string_ops)/sizeof(int), 0);
SetDlgItemTextW(hwndDlg,IDC_STATIC_STRING,WASABI_API_LNGSTRINGW(IDS_COMPARE_TO_STRING));
qe_doEnableDisable(hwndDlg, ctrls_datetime, sizeof(ctrls_datetime)/sizeof(int), 1);
SetDlgItemTextW(hwndDlg, IDC_RADIO_ABOVE, WASABI_API_LNGSTRINGW(IDS_AFTER));
SetDlgItemTextW(hwndDlg, IDC_RADIO_BELOW, WASABI_API_LNGSTRINGW(IDS_BEFORE));
SetDlgItemTextW(hwndDlg, IDC_RADIO_ABOVEOREQUAL, WASABI_API_LNGSTRINGW(IDS_SINCE));
SetDlgItemTextW(hwndDlg, IDC_RADIO_BELOWOREQUAL, WASABI_API_LNGSTRINGW(IDS_UNTIL));
break;
}
case FIELD_LENGTH: {
qe_fallback(hwndDlg, IDC_RADIO_ISLIKE, IDC_RADIO_EQUAL);
qe_fallback(hwndDlg, IDC_RADIO_BEGINS, IDC_RADIO_EQUAL);
qe_fallback(hwndDlg, IDC_RADIO_ENDS, IDC_RADIO_EQUAL);
qe_fallback(hwndDlg, IDC_RADIO_CONTAINS, IDC_RADIO_EQUAL);
qe_doEnableDisable(hwndDlg, ctrls_string, sizeof(ctrls_string)/sizeof(int), 1);
qe_doEnableDisable(hwndDlg, ctrls_string_ops, sizeof(ctrls_string_ops)/sizeof(int), 0);
SetDlgItemTextW(hwndDlg,IDC_STATIC_STRING,WASABI_API_LNGSTRINGW(IDS_COMPARE_TO_LENGTH));
qe_doEnableDisable(hwndDlg, ctrls_datetime, sizeof(ctrls_datetime)/sizeof(int), 0);
SetDlgItemTextW(hwndDlg, IDC_RADIO_ABOVE, WASABI_API_LNGSTRINGW(IDS_ABOVE));
SetDlgItemTextW(hwndDlg, IDC_RADIO_BELOW, WASABI_API_LNGSTRINGW(IDS_BELOW));
SetDlgItemTextW(hwndDlg, IDC_RADIO_ABOVEOREQUAL, WASABI_API_LNGSTRINGW(IDS_ABOVE_OR_EQUAL));
SetDlgItemTextW(hwndDlg, IDC_RADIO_BELOWOREQUAL, WASABI_API_LNGSTRINGW(IDS_BELOW_OR_EQUAL));
break;
}
case FIELD_FILENAME:
case FIELD_STRING: {
qe_doEnableDisable(hwndDlg, ctrls_string, sizeof(ctrls_string)/sizeof(int), 1);
qe_doEnableDisable(hwndDlg, ctrls_string_ops, sizeof(ctrls_string_ops)/sizeof(int), 1);
SetDlgItemTextW(hwndDlg,IDC_STATIC_STRING,WASABI_API_LNGSTRINGW(IDS_COMPARE_TO_STRING));
qe_doEnableDisable(hwndDlg, ctrls_datetime, sizeof(ctrls_datetime)/sizeof(int), 0);
SetDlgItemTextW(hwndDlg, IDC_RADIO_ABOVE, WASABI_API_LNGSTRINGW(IDS_ABOVE));
SetDlgItemTextW(hwndDlg, IDC_RADIO_BELOW, WASABI_API_LNGSTRINGW(IDS_BELOW));
SetDlgItemTextW(hwndDlg,IDC_RADIO_ABOVEOREQUAL, WASABI_API_LNGSTRINGW(IDS_ABOVE_OR_EQUAL));
SetDlgItemTextW(hwndDlg, IDC_RADIO_BELOWOREQUAL, WASABI_API_LNGSTRINGW(IDS_BELOW_OR_EQUAL));
break;
}
case FIELD_INTEGER: {
qe_fallback(hwndDlg, IDC_RADIO_ISLIKE, IDC_RADIO_EQUAL);
qe_fallback(hwndDlg, IDC_RADIO_BEGINS, IDC_RADIO_EQUAL);
qe_fallback(hwndDlg, IDC_RADIO_ENDS, IDC_RADIO_EQUAL);
qe_fallback(hwndDlg, IDC_RADIO_CONTAINS, IDC_RADIO_EQUAL);
SetDlgItemTextW(hwndDlg,IDC_STATIC_STRING,WASABI_API_LNGSTRINGW(IDS_COMPARE_TO_NUMBER));
qe_doEnableDisable(hwndDlg, ctrls_string, sizeof(ctrls_string)/sizeof(int), 1);
qe_doEnableDisable(hwndDlg, ctrls_string_ops, sizeof(ctrls_string_ops)/sizeof(int), 0);
qe_doEnableDisable(hwndDlg, ctrls_datetime, sizeof(ctrls_datetime)/sizeof(int), 0);
SetDlgItemTextW(hwndDlg, IDC_RADIO_ABOVE, WASABI_API_LNGSTRINGW(IDS_ABOVE));
SetDlgItemTextW(hwndDlg, IDC_RADIO_BELOW, WASABI_API_LNGSTRINGW(IDS_BELOW));
SetDlgItemTextW(hwndDlg, IDC_RADIO_ABOVEOREQUAL, WASABI_API_LNGSTRINGW(IDS_ABOVE_OR_EQUAL));
SetDlgItemTextW(hwndDlg, IDC_RADIO_BELOWOREQUAL, WASABI_API_LNGSTRINGW(IDS_BELOW_OR_EQUAL));
break;
}
}
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_ISEMPTY)) {
qe_doEnableDisable(hwndDlg, ctrls_string, sizeof(ctrls_string)/sizeof(int), 0);
qe_doEnableDisable(hwndDlg, ctrls_datetime, sizeof(ctrls_datetime)/sizeof(int), 0);
return;
}
}
void te_enableDisable(HWND hwndDlg) {
qe_doEnableDisable(hwndDlg, ctrls_datetime_relative, sizeof(ctrls_datetime_relative)/sizeof(int), IsDlgButtonChecked(hwndDlg, IDC_CHECK_RELATIVE));
qe_doEnableDisable(hwndDlg, ctrls_datetime_absolute, sizeof(ctrls_datetime_absolute)/sizeof(int), IsDlgButtonChecked(hwndDlg, IDC_CHECK_ABSOLUTE));
qe_doEnableDisable(hwndDlg, ctrls_datetime_relative_ago, sizeof(ctrls_datetime_relative_ago)/sizeof(int), IsDlgButtonChecked(hwndDlg, IDC_CHECK_RELATIVE) && IsDlgButtonChecked(hwndDlg, IDC_CHECK_TIMEAGO));
qe_doEnableDisable(hwndDlg, ctrls_datetime_relative_ago_direction, sizeof(ctrls_datetime_relative_ago_direction)/sizeof(int), !IsDlgButtonChecked(hwndDlg, IDC_CHECK_ABSOLUTE) && IsDlgButtonChecked(hwndDlg, IDC_CHECK_SELECTIVE) && IsDlgButtonChecked(hwndDlg, IDC_CHECK_TIMEAGO));
qe_doEnableDisable(hwndDlg, ctrls_datetime_relative_selective, sizeof(ctrls_datetime_relative_selective)/sizeof(int), IsDlgButtonChecked(hwndDlg, IDC_CHECK_RELATIVE) && IsDlgButtonChecked(hwndDlg, IDC_CHECK_SELECTIVE));
int origin = IsDlgButtonChecked(hwndDlg, IDC_CHECK_SELECTIVE) && IsDlgButtonChecked(hwndDlg, IDC_CHECK_RELATIVE);
qe_enableDisableItem(hwndDlg, IDC_EDIT_YEAR, origin && IsDlgButtonChecked(hwndDlg, IDC_RADIO_YEAR));
qe_enableDisableItem(hwndDlg, IDC_BUTTON_MONTH, origin && IsDlgButtonChecked(hwndDlg, IDC_RADIO_MONTH));
qe_enableDisableItem(hwndDlg, IDC_EDIT_DAY, origin && IsDlgButtonChecked(hwndDlg, IDC_RADIO_DAY));
qe_enableDisableItem(hwndDlg, IDC_DATETIMEPICKER2, origin && IsDlgButtonChecked(hwndDlg, IDC_RADIO_TIME));
SetDlgItemTextW(hwndDlg, IDC_CHECK_TIMEAGO, WASABI_API_LNGSTRINGW((IsDlgButtonChecked(hwndDlg, IDC_CHECK_SELECTIVE) ? IDS_OFFSET_BY : IDS_TIME_AGO)));
SetWindowTextW(GetDlgItem(hwndDlg, IDC_BUTTON_MONTH), monthtable[te_cur_selected_month]);
InvalidateRect(GetDlgItem(hwndDlg, IDC_CHECK_ABSOLUTE), NULL, TRUE);
InvalidateRect(GetDlgItem(hwndDlg, IDC_CHECK_RELATIVE), NULL, TRUE);
InvalidateRect(GetDlgItem(hwndDlg, IDC_CHECK_TIMEAGO), NULL, TRUE);
InvalidateRect(GetDlgItem(hwndDlg, IDC_CHECK_SELECTIVE), NULL, TRUE);
InvalidateRect(GetDlgItem(hwndDlg, IDC_STATIC_DIRECTION), NULL, TRUE);
}
const wchar_t *te_getDateTime(HWND hwndDlg) {
static GayStringW str;
wchar_t qe_tempstr[4096] = {0};
str.Set(L"");
if (IsDlgButtonChecked(hwndDlg, IDC_CHECK_ABSOLUTE)) {
GayStringW sd;
SYSTEMTIME st={0,0,0,0,0,0,0,0};
DateTime_GetSystemtime(GetDlgItem(hwndDlg, IDC_DATETIMEPICKER), &st);
if (st.wYear != 0) {
wsprintfW(qe_tempstr, L"%02d/%d/%02d", st.wMonth, st.wDay, st.wYear);
sd.Append(qe_tempstr);
}
SYSTEMTIME stt={0,0,0,0,0,0,0,0};
DateTime_GetSystemtime(GetDlgItem(hwndDlg, IDC_DATETIMEPICKER1), &stt);
if (stt.wYear != 0) {
if (sd.Get() && *sd.Get()) sd.Append(L" ");
wsprintfW(qe_tempstr, L"%02d:%02d:%02d", stt.wHour, stt.wMinute, stt.wSecond);
sd.Append(qe_tempstr);
}
if (sd.Get() && *sd.Get()) {
str.Set(sd.Get());
return str.Get();
}
} else if (IsDlgButtonChecked(hwndDlg, IDC_CHECK_RELATIVE)) {
GayStringW sd;
int gotshit = 0;
int gotmonth = 0;
int gotthismonth = 0;
int gotday = 0;
int lgotthistime = 0;
int lgotthisday = 0;
if (IsDlgButtonChecked(hwndDlg, IDC_CHECK_TIMEAGO)) {
int v = GetDlgItemInt(hwndDlg, IDC_EDIT_TIMEAGO, NULL, TRUE);
wsprintfW(qe_tempstr, L"%d", v);
sd.Append(qe_tempstr);
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_TIMEAGO_Y)) { sd.Append(L" year"); if (v > 1) sd.Append(L"s"); }
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_TIMEAGO_M)) { sd.Append(L" month"); if (v > 1) sd.Append(L"s"); }
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_TIMEAGO_W)) { sd.Append(L" week"); if (v > 1) sd.Append(L"s"); }
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_TIMEAGO_D)) { sd.Append(L" day"); if (v > 1) sd.Append(L"s"); }
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_TIMEAGO_H)) sd.Append(L" h");
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_TIMEAGO_MIN)) sd.Append(L" mn");
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_TIMEAGO_S)) sd.Append(L" s");
}
if (IsDlgButtonChecked(hwndDlg, IDC_CHECK_SELECTIVE)) {
if (IsDlgButtonChecked(hwndDlg, IDC_CHECK_TIMEAGO) && IsDlgButtonChecked(hwndDlg, IDC_RADIO_AFTER)) sd.Append(L" after");
if (IsDlgButtonChecked(hwndDlg, IDC_CHECK_TIMEAGO) && IsDlgButtonChecked(hwndDlg, IDC_RADIO_BEFORE)) sd.Append(L" before");
if (!IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISDAY) &&
IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISMONTH)) {
if (sd.Get() && *sd.Get()) sd.Append(L" ");
int v = GetDlgItemInt(hwndDlg, IDC_EDIT_DAY, NULL, TRUE);
wsprintfW(qe_tempstr, L"%s%d", !gotmonth ? L"the " : L"", v);
int u = (v - ((int)((double)v/10.0)) * 10);
if (v < 1 || v > 31) {
sd.Append(L"DAY_OUTOFRANGE");
gotshit = 1;
} else {
sd.Append(qe_tempstr);
switch (u) {
case 1: sd.Append(L"st"); gotshit = 1; break;
case 2: sd.Append(L"nd"); gotshit = 1; break;
case 3: sd.Append(L"rd"); gotshit = 1; break;
default: sd.Append(L"th"); gotshit = 1; break;
}
}
if (!gotthismonth && IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISMONTH)) {
sd.Append(L" of this month");
gotthismonth = 1;
}
gotshit = 1;
gotday = 1;
}
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISYEAR) &&
IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISMONTH) &&
IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISDAY) &&
IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISTIME)) {
if (sd.Get() && *sd.Get()) sd.Append(L" ");
sd.Append(L"now");
gotshit = 1;
} else {
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISYEAR) &&
IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISMONTH) &&
IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISDAY)) {
if (gotshit) sd.Append(L",");
if (sd.Get() && *sd.Get()) sd.Append(L" ");
sd.Append(L"this date");
gotshit = 1;
} else {
if (!gotthismonth && IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISMONTH) && !IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISYEAR)) {
if (gotshit) sd.Append(L",");
if (sd.Get() && *sd.Get()) sd.Append(L" ");
sd.Append(L"this month");
gotthismonth = 1;
gotshit = 1;
}
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISDAY)) {
if (gotshit) sd.Append(L",");
if (sd.Get() && *sd.Get()) sd.Append(L" ");
sd.Append(L"this day");
lgotthisday = 1;
gotshit = 1;
}
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISTIME)) {
if (gotshit) sd.Append(L",");
if (sd.Get() && *sd.Get()) sd.Append(L" ");
sd.Append(L"this time");
lgotthistime = 1;
lgotthisday = 0;
gotshit = 1;
}
}
}
if (!IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISMONTH)) {
if (sd.Get() && *sd.Get()) sd.Append(L" ");
if (lgotthistime) {
if (!IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISDAY))
sd.Append(L"on ");
else {
sd.Append(L"in ");
}
} else if (lgotthisday) sd.Append(L"of ");
switch (te_cur_selected_month) {
case 0: sd.Append(L"Jan"); gotshit = 1; gotmonth = 1; break;
case 1: sd.Append(L"Feb"); gotshit = 1; gotmonth = 1; break;
case 2: sd.Append(L"Mar"); gotshit = 1; gotmonth = 1; break;
case 3: sd.Append(L"Apr"); gotshit = 1; gotmonth = 1; break;
case 4: sd.Append(L"May"); gotshit = 1; gotmonth = 1; break;
case 5: sd.Append(L"Jun"); gotshit = 1; gotmonth = 1; break;
case 6: sd.Append(L"Jul"); gotshit = 1; gotmonth = 1; break;
case 7: sd.Append(L"Aug"); gotshit = 1; gotmonth = 1; break;
case 8: sd.Append(L"Sep"); gotshit = 1; gotmonth = 1; break;
case 9: sd.Append(L"Oct"); gotshit = 1; gotmonth = 1; break;
case 10: sd.Append(L"Nov"); gotshit = 1; gotmonth = 1; break;
case 11: sd.Append(L"Dec"); gotshit = 1; gotmonth = 1; break;
default: sd.Append(L"MONTH_OUTOFRANGE"); gotshit = 1; gotmonth = 1; break;
}
}
if (!IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISDAY) &&
!IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISMONTH)) {
if (sd.Get() && *sd.Get()) sd.Append(L" ");
int v = GetDlgItemInt(hwndDlg, IDC_EDIT_DAY, NULL, TRUE);
wsprintfW(qe_tempstr, L"%s%d", !gotmonth ? L"the " : L"", v);
int u = (v - ((int)((double)v/10.0)) * 10);
if (v < 1 || v > 31) {
sd.Append(L"DAY_OUTOFRANGE");
gotshit = 1;
} else {
sd.Append(qe_tempstr);
switch (u) {
case 1: sd.Append(L"st"); gotshit = 1; break;
case 2: sd.Append(L"nd"); gotshit = 1; break;
case 3: sd.Append(L"rd"); gotshit = 1; break;
default: sd.Append(L"th"); gotshit = 1; break;
}
}
if (!gotthismonth && IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISMONTH)) {
sd.Append(L" of this month");
}
gotthismonth = 1;
gotshit = 1;
gotday = 1;
}
if (!IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISYEAR)) {
if ((gotshit || gotday) && !gotmonth) {
if (sd.Get() && *sd.Get()) sd.Append(L" ");
sd.Append(L"in ");
} else if (gotmonth && gotday) sd.Append(L", ");
else if (sd.Get() && *sd.Get()) sd.Append(L" ");
int v = GetDlgItemInt(hwndDlg, IDC_EDIT_YEAR, NULL, TRUE);
if (v <= 69) v += 2000;
else if (v > 69 && v < 100) v += 1900;
if (v <= 1969 || v >= 2038)
wcsncpy(qe_tempstr, L"YEAR_OUTOFRANGE", 4096);
else
wsprintfW(qe_tempstr, L"%d", v);
sd.Append(qe_tempstr);
gotshit = 1;
}
if (!IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISTIME)) {
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_NOON)) {
if (sd.Get() && *sd.Get()) sd.Append(L" ");
if (gotshit) sd.Append(L"at ");
sd.Append(L"noon");
} else if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_MIDNIGHT)) {
if (sd.Get() && *sd.Get()) sd.Append(L" ");
if (gotshit) sd.Append(L"at ");
sd.Append(L"midnight");
} else if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_TIME)) {
if (sd.Get() && *sd.Get()) sd.Append(L" ");
if (gotshit) sd.Append(L"at ");
SYSTEMTIME stt={0,0,0,0,0,0,0,0};
DateTime_GetSystemtime(GetDlgItem(hwndDlg, IDC_DATETIMEPICKER2), &stt);
wsprintfW(qe_tempstr, L"%02d:%02d:%02d", stt.wHour, stt.wMinute, stt.wSecond);
sd.Append(qe_tempstr);
gotshit = 1;
}
}
} else {
if (IsDlgButtonChecked(hwndDlg, IDC_CHECK_TIMEAGO))
sd.Append(L" ago");
}
qe_curorigin.Set(sd.Get());
if (sd.Get() && *sd.Get()) {
str.Set(sd.Get());
return str.Get();
}
}
return NULL;
}
void qe_updateQuery(HWND hwndDlg) {
if (!*qe_field) return;
wchar_t qe_tempstr[4096] = {0};
nde_field_t field = NDE_Table_GetColumnByName(g_table, AutoChar(qe_field));
if (!field) return;
int type =NDE_ColumnField_GetDataType(field);
*qe_tempstr = NULL;
GayStringW str;
if (IsDlgButtonChecked(hwndDlg, IDC_CHECK_NOT))
str.Append(L"!(");
str.Append(qe_field);
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_EQUAL))
str.Append(L" ==");
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_ABOVE))
str.Append(L" >");
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_BELOW))
str.Append(L" <");
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_ABOVEOREQUAL))
str.Append(L" >=");
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_BELOWOREQUAL))
str.Append(L" <=");
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_ISLIKE))
str.Append(L" like");
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_ISEMPTY))
str.Append(L" isempty");
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_BEGINS))
str.Append(L" begins");
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_ENDS))
str.Append(L" ends");
if (IsDlgButtonChecked(hwndDlg, IDC_RADIO_CONTAINS))
str.Append(L" has");
if (!IsDlgButtonChecked(hwndDlg, IDC_RADIO_ISEMPTY)) {
switch(type) {
case FIELD_DATETIME: {
str.Append(L" [");
GetDlgItemTextW(hwndDlg, IDC_EDIT_DATETIME, qe_tempstr, 4096);
qe_curdate.Set(qe_tempstr);
str.Append(qe_curdate.Get());
str.Append(L"]");
}
break;
case FIELD_INTEGER: {
wsprintfW(qe_tempstr, L" %d", GetDlgItemInt(hwndDlg, IDC_EDIT_STRING, NULL, 1));
str.Append(qe_tempstr);
}
break;
case FIELD_FILENAME:
case FIELD_STRING: {
GetDlgItemTextW(hwndDlg, IDC_EDIT_STRING, qe_tempstr, 4096);
str.Append(L" \"");
GayStringW escaped;
queryStrEscape(qe_tempstr, escaped);
str.Append(escaped.Get());
str.Append(L"\"");
}
break;
case FIELD_LENGTH: {
GetDlgItemTextW(hwndDlg, IDC_EDIT_STRING, qe_tempstr, 4096);
wchar_t *z = wcschr(qe_tempstr, L':');
if (z) {
wchar_t *zz = wcschr(z+1, L':');
int a, b, c=0,v=0;
a = myatoi(qe_tempstr, z-qe_tempstr);
if (zz) { b = myatoi(z+1, zz-(z+1)); c = _wtoi(zz+1); v = a * 3600 + b * 60 + c; }
else { b = _wtoi(z+1); v = a * 60 + b; }
if (v < 60)
wsprintfW(qe_tempstr,L"%d",v);
else if (v < 60*60)
wsprintfW(qe_tempstr,L"%d:%02d",v/60,v%60);
else
wsprintfW(qe_tempstr,L"%d:%02d:%02d",v/60/60,(v/60)%60,v%60);
str.Append(qe_tempstr);
} else {
wsprintfW(qe_tempstr, L" %d", GetDlgItemInt(hwndDlg, IDC_EDIT_STRING, NULL, 1));
str.Append(qe_tempstr);
}
}
break;
}
}
if (IsDlgButtonChecked(hwndDlg, IDC_CHECK_NOT))
str.Append(L")");
qe_curexpr.Set(str.Get());
SetDlgItemTextW(hwndDlg, IDC_EDIT_RESULT, str.Get());
SetDlgItemTextW(hwndDlg, IDC_EDIT_QUERY, qe_curquery.Get());
qe_updateResultingDate(hwndDlg);
}
void qe_update(HWND hwndDlg) {
qe_enableDisable(hwndDlg);
qe_updateQuery(hwndDlg);
}
void te_updateResult(HWND hwndDlg) {
const wchar_t *s = te_getDateTime(hwndDlg);
te_result.Set(s == NULL ? L"":s);
SetDlgItemTextW(hwndDlg, IDC_EDIT_RESULT, te_result.Get());
}
void te_update(HWND hwndDlg) {
te_enableDisable(hwndDlg);
te_updateResult(hwndDlg);
}
void qe_pushExpression(HWND hwndDlg, const wchar_t *op) {
GayStringW newq;
if (op && qe_curquery.Get() && *qe_curquery.Get()) {
newq.Append(L"(");
newq.Append(qe_curquery.Get());
newq.Append(L") ");
newq.Append(op);
newq.Append(L" (");
newq.Append(qe_curexpr.Get());
newq.Append(L")");
qe_curquery.Set(newq.Get());
} else {
qe_curquery.Set(qe_curexpr.Get());
}
qe_update(hwndDlg);
}
SYSTEMTIME pickedtime;
SYSTEMTIME pickeddate;
INT_PTR CALLBACK pickDateTimeDialogProc(HWND hwndDlg, UINT uMsg, WPARAM wParam,LPARAM lParam) {
switch(uMsg) {
case WM_INITDIALOG: {
return TRUE;
}
case WM_COMMAND: {
switch (LOWORD(wParam)) {
case IDOK:
memset(&pickedtime, 0, sizeof(pickedtime));
memset(&pickeddate, 0, sizeof(pickeddate));
DateTime_GetSystemtime(GetDlgItem(hwndDlg, IDC_DATETIMEPICKER), &pickeddate);
DateTime_GetSystemtime(GetDlgItem(hwndDlg, IDC_DATETIMEPICKER1), &pickedtime);
EndDialog(hwndDlg, IDOK);
break;
case IDCANCEL:
EndDialog(hwndDlg, IDCANCEL);
break;
}
}
break;
}
return FALSE;
}
INT_PTR CALLBACK editDateTimeDialogProc(HWND hwndDlg, UINT uMsg, WPARAM wParam,LPARAM lParam) {
switch(uMsg) {
case WM_INITDIALOG: {
const wchar_t *p = te_ret.Get();
while (p) {
if (*p != L' ') break;
p++;
}
int empty = (p && *p == 0);
TimeParse tp;
NDE_Time_ApplyConversion(0, te_ret.Get(), &tp);
if (!empty) {
CheckDlgButton(hwndDlg, IDC_RADIO_THISYEAR, tp.relative_year == -1 ? BST_CHECKED : BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_YEAR, tp.relative_year != -1 ? BST_CHECKED : BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_THISMONTH, tp.relative_month == -1 ? BST_CHECKED : BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_MONTH, tp.relative_month != -1 ? BST_CHECKED : BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_THISDAY, tp.relative_day == -1 ? BST_CHECKED : BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_DAY, tp.relative_day != -1 ? BST_CHECKED : BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_THISTIME, tp.relative_hour == -1 ? BST_CHECKED : BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_NOON, (tp.relative_hour == 12 && tp.relative_min == 0 && tp.relative_sec == 0) ? BST_CHECKED : BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_MIDNIGHT, (tp.relative_hour == 0 && tp.relative_min == 0 && tp.relative_sec == 0) ? BST_CHECKED : BST_UNCHECKED);
int timeyet = IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISTIME);
timeyet |= IsDlgButtonChecked(hwndDlg, IDC_RADIO_NOON);
timeyet |= IsDlgButtonChecked(hwndDlg, IDC_RADIO_MIDNIGHT);
CheckDlgButton(hwndDlg, IDC_RADIO_TIME, !timeyet ? BST_CHECKED : BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_CHECK_RELATIVE, tp.is_relative ? BST_CHECKED : BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_CHECK_ABSOLUTE, !tp.is_relative ? BST_CHECKED : BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_BEFORE, tp.offset_whence == 1 ? BST_CHECKED : BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_AFTER, tp.offset_whence == 0 ? BST_CHECKED : BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_CHECK_TIMEAGO, tp.offset_used == 1 ? BST_CHECKED : BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_TIMEAGO_Y, tp.offset_what == 0 ? BST_CHECKED : BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_TIMEAGO_M, tp.offset_what == 1 ? BST_CHECKED : BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_TIMEAGO_W, tp.offset_what == 2 ? BST_CHECKED : BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_TIMEAGO_D, tp.offset_what == 3 ? BST_CHECKED : BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_TIMEAGO_H, tp.offset_what == 4 ? BST_CHECKED : BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_TIMEAGO_MIN, tp.offset_what == 5 ? BST_CHECKED : BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_TIMEAGO_S, tp.offset_what == 6 ? BST_CHECKED : BST_UNCHECKED);
if (tp.is_relative && (tp.relative_year != -1 || tp.relative_month != -1 || tp.relative_day != -1 || tp.relative_hour != -1 || tp.relative_min != -1 || tp.relative_sec != -1))
CheckDlgButton(hwndDlg, IDC_CHECK_SELECTIVE, BST_CHECKED);
else
CheckDlgButton(hwndDlg, IDC_CHECK_SELECTIVE, BST_UNCHECKED);
}
wchar_t t[64] = {0};
wsprintfW(t, L"%d", tp.offset_value);
SetDlgItemTextW(hwndDlg, IDC_EDIT_TIMEAGO, t);
SetDlgItemTextW(hwndDlg, IDC_EDIT_RESULT, te_ret.Get());
{
wchar_t qe_tempstr[4096] = {0};
time_t now;
time(&now);
struct tm *ts = localtime(&now);
wsprintfW(qe_tempstr, L"%d", tp.relative_year != -1 ? tp.relative_year : ts->tm_year+1900);
SetDlgItemTextW(hwndDlg, IDC_EDIT_YEAR, qe_tempstr);
wsprintfW(qe_tempstr, L"%d", tp.relative_day != -1 ? tp.relative_day : ts->tm_mday);
SetDlgItemTextW(hwndDlg, IDC_EDIT_DAY, qe_tempstr);
te_cur_selected_month = tp.relative_month != -1 ? tp.relative_month : ts->tm_mon;
}
if (!empty && !IsDlgButtonChecked(hwndDlg, IDC_RADIO_THISTIME) && !IsDlgButtonChecked(hwndDlg, IDC_RADIO_NOON) && !IsDlgButtonChecked(hwndDlg, IDC_RADIO_MIDNIGHT)) {
SYSTEMTIME st={0};
st.wHour = (WORD)tp.relative_hour;
st.wMinute = (WORD)tp.relative_min;
st.wSecond = (WORD)tp.relative_sec;
DateTime_SetSystemtime(GetDlgItem(hwndDlg, IDC_DATETIMEPICKER2), GDT_VALID, &st);
}
if (!empty && !tp.is_relative) {
time_t o = tp.absolute_datetime;
struct tm *t = localtime(&o);
if (t) {
if (!tp.absolute_hasdate)
DateTime_SetSystemtime(GetDlgItem(hwndDlg, IDC_DATETIMEPICKER), GDT_NONE, NULL);
else {
SYSTEMTIME st={0};
st.wYear = (WORD)t->tm_year;
st.wDay = (WORD)t->tm_mday;
st.wMonth = (WORD)t->tm_mon;
DateTime_SetSystemtime(GetDlgItem(hwndDlg, IDC_DATETIMEPICKER), GDT_VALID, &st);
}
if (!tp.absolute_hastime)
DateTime_SetSystemtime(GetDlgItem(hwndDlg, IDC_DATETIMEPICKER1), GDT_NONE, NULL);
else {
SYSTEMTIME st2={0};
GetSystemTime(&st2);
st2.wHour = (WORD)t->tm_hour;
st2.wMinute = (WORD)t->tm_min;
st2.wSecond = (WORD)t->tm_sec;
DateTime_SetSystemtime(GetDlgItem(hwndDlg, IDC_DATETIMEPICKER1), GDT_VALID, &st2);
}
}
CheckDlgButton(hwndDlg, IDC_CHECK_TIMEAGO, 1);
CheckDlgButton(hwndDlg, IDC_RADIO_TIMEAGO_W, 1);
SetDlgItemText(hwndDlg, IDC_EDIT_TIMEAGO, L"1");
CheckDlgButton(hwndDlg, IDC_RADIO_BEFORE, 1);
} else if (!empty) {
if (!IsDlgButtonChecked(hwndDlg, IDC_CHECK_SELECTIVE)) {
CheckDlgButton(hwndDlg, IDC_RADIO_THISYEAR, 1);
CheckDlgButton(hwndDlg, IDC_RADIO_THISMONTH, 1);
CheckDlgButton(hwndDlg, IDC_RADIO_THISDAY, 1);
CheckDlgButton(hwndDlg, IDC_RADIO_THISTIME, 1);
}
} else if (empty) {
CheckDlgButton(hwndDlg, IDC_CHECK_TIMEAGO, 1);
CheckDlgButton(hwndDlg, IDC_RADIO_TIMEAGO_W, 1);
SetDlgItemText(hwndDlg, IDC_EDIT_TIMEAGO, L"1");
CheckDlgButton(hwndDlg, IDC_RADIO_BEFORE, 1);
CheckDlgButton(hwndDlg, IDC_RADIO_THISYEAR, 1);
CheckDlgButton(hwndDlg, IDC_RADIO_THISMONTH, 1);
CheckDlgButton(hwndDlg, IDC_RADIO_THISDAY, 1);
CheckDlgButton(hwndDlg, IDC_RADIO_THISTIME, 1);
CheckDlgButton(hwndDlg, IDC_CHECK_RELATIVE, 1);
}
te_enableDisable(hwndDlg);
SetTimer(hwndDlg, 0, 1000, NULL);
}
return 1;
case WM_COMMAND: {
switch (LOWORD(wParam)) {
case IDOK: EndDialog(hwndDlg, IDOK); break;
case IDCANCEL: EndDialog(hwndDlg, IDCANCEL); break;
case IDC_EDIT_TIMEAGO:
case IDC_EDIT_YEAR:
case IDC_EDIT_DAY:
if (HIWORD(wParam) != EN_CHANGE) break;
case IDC_CHECK_ABSOLUTE:
case IDC_CHECK_RELATIVE:
case IDC_CHECK_TIMEAGO:
case IDC_CHECK_SELECTIVE:
case IDC_RADIO_THISYEAR:
case IDC_RADIO_THISMONTH:
case IDC_RADIO_THISDAY:
case IDC_RADIO_THISTIME:
case IDC_RADIO_YEAR:
case IDC_RADIO_MONTH:
case IDC_RADIO_DAY:
case IDC_RADIO_TIME:
case IDC_RADIO_NOON:
case IDC_RADIO_MIDNIGHT:
case IDC_RADIO_EQUAL:
case IDC_RADIO_ABOVE:
case IDC_RADIO_ABOVEOREQUAL:
case IDC_RADIO_BELOW:
case IDC_RADIO_BELOWOREQUAL:
case IDC_RADIO_ISLIKE:
case IDC_RADIO_ISEMPTY:
case IDC_RADIO_BEGINS:
case IDC_RADIO_ENDS:
case IDC_RADIO_CONTAINS:
case IDC_CHECK_NOT:
case IDC_RADIO_TIMEAGO_Y:
case IDC_RADIO_TIMEAGO_M:
case IDC_RADIO_TIMEAGO_D:
case IDC_RADIO_TIMEAGO_H:
case IDC_RADIO_TIMEAGO_MIN:
case IDC_RADIO_TIMEAGO_S:
case IDC_RADIO_TIMEAGO_W:
case IDC_RADIO_AFTER:
case IDC_RADIO_BEFORE:
te_update(hwndDlg);
return 0;
case IDC_BUTTON_PICK: {
INT_PTR r = WASABI_API_DIALOGBOXW(IDD_EDIT_QUERY_PICK, hwndDlg, pickDateTimeDialogProc);
if (r == IDOK) {
if (pickeddate.wYear != 0) {
SetDlgItemInt(hwndDlg, IDC_EDIT_YEAR, pickeddate.wYear, 0);
te_cur_selected_month = pickeddate.wMonth-1;
SetDlgItemInt(hwndDlg, IDC_EDIT_DAY, pickeddate.wDay, 0);
CheckDlgButton(hwndDlg, IDC_RADIO_THISYEAR, BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_YEAR, BST_CHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_THISMONTH, BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_MONTH, BST_CHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_THISDAY, BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_DAY, BST_CHECKED);
}
if (pickedtime.wYear != 0) {
DateTime_SetSystemtime(GetDlgItem(hwndDlg, IDC_DATETIMEPICKER2), GDT_VALID, &pickedtime);
CheckDlgButton(hwndDlg, IDC_RADIO_THISTIME, BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_TIME, BST_CHECKED);
}
te_update(hwndDlg);
}
}
break;
case IDC_BUTTON_NOW:
CheckDlgButton(hwndDlg, IDC_RADIO_THISYEAR, BST_CHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_YEAR, BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_THISMONTH, BST_CHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_MONTH, BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_THISDAY, BST_CHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_DAY, BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_THISTIME, BST_CHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_TIME, BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_NOON, BST_UNCHECKED);
CheckDlgButton(hwndDlg, IDC_RADIO_MIDNIGHT, BST_UNCHECKED);
te_update(hwndDlg);
return 0;
case IDC_BUTTON_MONTH: {
HMENU menu = CreatePopupMenu();
for (int i=0;i<12;i++)
AppendMenuW(menu, MF_STRING|(te_cur_selected_month==i)?MF_CHECKED:MF_UNCHECKED, i+1, monthtable[i]);
POINT pt;
GetCursorPos(&pt);
int r = TrackPopupMenuEx(menu, TPM_LEFTALIGN|TPM_BOTTOMALIGN|TPM_NONOTIFY|TPM_RETURNCMD|TPM_LEFTBUTTON|TPM_RIGHTBUTTON, pt.x, pt.y, hwndDlg, NULL);
if (r)
{
te_cur_selected_month = r-1;
te_update(hwndDlg);
}
break;
}
}
}
case WM_TIMER: {
te_updateResultingDate(hwndDlg);
return 0;
}
case WM_NOTIFY: {
int idCtrl = (int)wParam;
NMHDR *hdr = (NMHDR*)lParam;
switch (idCtrl) {
case IDC_DATETIMEPICKER:
case IDC_DATETIMEPICKER1:
case IDC_DATETIMEPICKER2:
if (hdr->code == DTN_DATETIMECHANGE)
te_update(hwndDlg);
break;
}
}
break;
}
return 0;
}
INT_PTR CALLBACK editQueryDialogProc( HWND hwndDlg, UINT uMsg, WPARAM wParam, LPARAM lParam )
{
switch ( uMsg )
{
case WM_INITDIALOG:
{
qe_fillFieldsList( GetDlgItem( hwndDlg, IDC_LIST_FIELDS ) );
SetDlgItemTextW( hwndDlg, IDC_EDIT_RESULT, qe_curquery.Get() );
CheckDlgButton( hwndDlg, IDC_RADIO_EQUAL, MF_CHECKED );
qe_update( hwndDlg );
SetTimer( hwndDlg, 0, 1000, NULL );
return 1;
}
case WM_TIMER:
{
qe_updateResultingDate( hwndDlg );
return 0;
}
case WM_COMMAND:
{
switch ( LOWORD( wParam ) )
{
case IDOK:
if ( !qe_curquery.Get() || !*qe_curquery.Get() && qe_curexpr.Get() && *qe_curexpr.Get() )
{
wchar_t titleStr[ 32 ] = { 0 };
int r = MessageBoxW( hwndDlg, WASABI_API_LNGSTRINGW( IDS_QUERY_FIELD_IS_EMPTY ),
WASABI_API_LNGSTRINGW_BUF( IDS_EMPTY_QUERY, titleStr, 32 ), MB_YESNOCANCEL );
if ( r == IDYES )
qe_curquery.Set( qe_curexpr.Get() );
else if ( r == IDCANCEL ) break;
}
if ( qe_origquery.Get() && *qe_origquery.Get() && qe_curquery.Get() || *qe_curquery.Get() && qe_curexpr.Get() && *qe_curexpr.Get() )
{
if ( !wcscmp( qe_curquery.Get(), qe_origquery.Get() ) )
{
wchar_t titleStr[ 32 ] = { 0 };
int r = MessageBoxW( hwndDlg, WASABI_API_LNGSTRINGW( IDS_NO_CHANGES_MADE_TO_QUERY ),
WASABI_API_LNGSTRINGW_BUF( IDS_QUERY_NOT_CHANGED, titleStr, 32 ), MB_YESNOCANCEL );
if ( r == IDYES )
qe_curquery.Set( qe_curexpr.Get() );
else if ( r == IDCANCEL ) break;
}
}
EndDialog( hwndDlg, IDOK );
break;
case IDCANCEL: EndDialog( hwndDlg, IDCANCEL ); break;
case IDC_EDIT_STRING:
case IDC_EDIT_DATETIME:
if ( HIWORD( wParam ) != EN_CHANGE ) break;
case IDC_RADIO_EQUAL:
case IDC_RADIO_ABOVE:
case IDC_RADIO_ABOVEOREQUAL:
case IDC_RADIO_BELOW:
case IDC_RADIO_BELOWOREQUAL:
case IDC_RADIO_ISLIKE:
case IDC_RADIO_ISEMPTY:
case IDC_RADIO_BEGINS:
case IDC_RADIO_ENDS:
case IDC_RADIO_CONTAINS:
case IDC_CHECK_NOT:
qe_update( hwndDlg );
return 0;
case IDC_LIST_FIELDS:
if ( HIWORD( wParam ) == CBN_SELCHANGE )
{
HWND wnd = GetDlgItem( hwndDlg, IDC_LIST_FIELDS );
int idx = ListBox_GetCurSel( wnd );
int len = ListBox_GetTextLenW( wnd, idx );
if ( qe_field != NULL ) free( qe_field );
qe_field = (wchar_t *)calloc( ( len + 1 ), sizeof( wchar_t ) );
ListBox_GetTextW( wnd, idx, qe_field );
qe_field[ len ] = 0;
qe_update( hwndDlg );
}
break;
case IDC_BUTTON_AND:
qe_pushExpression( hwndDlg, L"AND" );
break;
case IDC_BUTTON_OR:
qe_pushExpression( hwndDlg, L"OR" );
break;
case ID_BUTTON_SENDTOQUERY:
qe_pushExpression( hwndDlg, NULL );
break;
case IDC_BUTTON_EDITDATETIME:
{
const wchar_t *res = editTime( hwndDlg, qe_curdate.Get() );
if ( res != NULL )
{
SetDlgItemTextW( hwndDlg, IDC_EDIT_DATETIME, res );
qe_curdate.Set( res );
}
qe_update( hwndDlg );
break;
}
case IDC_EDIT_QUERY:
if ( HIWORD( wParam ) == EN_CHANGE )
{
wchar_t qe_tempstr[ 4096 ] = { 0 };
GetDlgItemTextW( hwndDlg, IDC_EDIT_QUERY, qe_tempstr, 4096 );
qe_curquery.Set( qe_tempstr );
qe_showHideOperators( hwndDlg );
}
break;
}
}
break;
}
return FALSE;
}