static tui_list_query_t following_list_query(tui_list_t *p)
{
p->in_query = true;
if (t_query(following_list_get_name(p->data, p->cur)) == -1)
return FULLUPDATE;
screen_move_clear(-1);
//% prints("\033[0;1;44;31m\033[33m 寄信 m │ 结束 Q,← │上一位 ↑│"
prints("\033[0;1;44;31m\033[33m \xbc\xc4\xd0\xc5 m \xa9\xa6 \xbd\xe1\xca\xf8 Q,\xa1\xfb \xa9\xa6\xc9\xcf\xd2\xbb\xce\xbb \xa1\xfc\xa9\xa6"
//% "下一位 <Space>,↓ \033[m");
"\xcf\xc2\xd2\xbb\xce\xbb <Space>,\xa1\xfd \033[m");
screen_flush();
return DONOTHING;
}
void SUBE_TREE_BATCH::REFRESH_SUBE_SCHEMA()
{
SQL_QUERY f_query (DB);
SQL_QUERY s_query (DB);
SQL_QUERY t_query (DB);
QString schema = "";
f_query.PREPARE_SELECT( "sub_subeler","sube_id,sube_kodu,sube_adi" );
if ( f_query.SELECT() EQ 0 ) {
m_ui->text_edit_sube_semasi->clear();
return;
}
while ( f_query.NEXT() EQ true ) {
schema.append(QString("<p style=\"margin:0; -qt-block-indent:0; text-indent:0px;\">"
"<span style=\"font-size:20px; font-weight:600;\">Şube: %1 %2</span></p>")
.arg(f_query.VALUE(1).toString()).arg(f_query.VALUE(2).toString()));
s_query.PREPARE_SELECT("sub_depolar","depo_id,depo_kodu,depo_adi","sube_id=:sube_id");
s_query.SET_VALUE (":sube_id" , f_query.VALUE(0).toInt());
if ( s_query.SELECT() NE 0 ) {
while ( s_query.NEXT() EQ true ) {
schema.append(QString("<p style=\"margin:0; -qt-block-indent:0; text-indent:30px;\">"
"<span style=\"font-size:16px; font-weight:600;\">Depo: %1 %2</span></p>")
.arg(s_query.VALUE(1).toString()).arg(s_query.VALUE(2).toString()));
t_query.PREPARE_SELECT("sub_uniteler","unite_adi","sube_id=:sube_id AND depo_id=:depo_id");
t_query.SET_VALUE (":sube_id", f_query.VALUE(0).toInt());
t_query.SET_VALUE (":depo_id", s_query.VALUE(0).toInt());
if ( t_query.SELECT() NE 0 ) {
while ( t_query.NEXT() EQ true ) {
schema.append(QString("<p style=\"margin:0; -qt-block-indent:0; text-indent:60px;\">"
"<span style=\"font-size:13px; font-weight:600;\">Ünite: %1</span></p>")
.arg(t_query.VALUE(0).toString()));
}
}
}
}
schema.append("<br><br>");
}
m_ui->text_edit_sube_semasi->setHtml(schema);
}
static tui_list_query_t online_users_query(tui_list_t *p)
{
online_users_t *up = p->data;
online_user_info_t *ip = up->users + p->cur;
p->in_query = true;
t_query(ip->name);
screen_move(-1, 0);
//% prints("\033[0;1;37;44m聊天[\033[1;32mt\033[37m] 寄信[\033[1;32mm\033[37m] "
prints("\033[0;1;37;44m\xc1\xc4\xcc\xec[\033[1;32mt\033[37m] \xbc\xc4\xd0\xc5[\033[1;32mm\033[37m] "
//% "送讯息[\033[1;32ms\033[37m] 加,减朋友[\033[1;32mo\033[37m,\033[1;32md\033[37m] "
"\xcb\xcd\xd1\xb6\xcf\xa2[\033[1;32ms\033[37m] \xbc\xd3,\xbc\xf5\xc5\xf3\xd3\xd1[\033[1;32mo\033[37m,\033[1;32md\033[37m] "
//% "选择使用者[\033[1;32m↑\033[37m,\033[1;32m↓\033[37m] "
"\xd1\xa1\xd4\xf1\xca\xb9\xd3\xc3\xd5\xdf[\033[1;32m\xa1\xfc\033[37m,\033[1;32m\xa1\xfd\033[37m] "
//% "求救[\033[1;32mh\033[37m]");
"\xc7\xf3\xbe\xc8[\033[1;32mh\033[37m]");
screen_flush();
return DONOTHING;
}
int t_chat2()
{
int currchar;
char inbuf[120];
BOOL page_pending = FALSE;
int ch;
char seedstr[STRLEN];
long seed;
char rcvbuf[512];
int chatport;
char *mycrypt();
if (check_page_perm() < 0)
return C_FOOT;
chatport = CHATPORT;
#if 1
if (chatport == 0)
chatport = 6177;
#endif
#if 0
#if defined(NSYSUBBS1)
getdata(1, 0, _msg_chat_1, genbuf, 2, ECHONOSP);
if (genbuf[0] == '2')
chatport = CHATPORT + 1;
#endif
#endif
/* initialize */
inbuf[0] = '\0';
currchar = 0;
chat_line = 0;
if (!getdata(1, 0, "Enter Chat id: ", mychatid, CHATIDLEN, ECHONOSP))
xstrncpy(mychatid, curuser.userid, CHATIDLEN);
fixchatid(mychatid);
if ((ac = ConnectServer(CHAT_SERVER, chatport)) < 0)
{
move(2, 0);
outs(_msg_chat_3);
refresh();
sprintf(genbuf, "bbschatd %d", chatport);
outdoor(genbuf);
sleep(2);
if ((ac = ConnectServer(CHAT_SERVER, chatport)) < 0)
{
perror("connect failed");
pressreturn();
return C_FULL;
}
}
/* receive ChatServer Hello Welcome VersionInfo */
net_gets(ac, genbuf, sizeof(genbuf));
/* receive Random Number for Checksum */
net_gets(ac, seedstr, sizeof(seedstr));
seed = atol(mycrypt(seedstr));
net_printf(ac, "USRID\t%s\t%ld\r\n", curuser.userid, seed);
net_gets(ac, genbuf, sizeof(genbuf));
if (strncmp(genbuf, "+OK", 3)) /* lthuang */
{
outs(_msg_chat_4);
pressreturn();
return C_FULL;
}
uinfo.mode = CHATROOM;
xstrncpy(uinfo.chatid, mychatid, sizeof(uinfo.chatid));
update_ulist(cutmp, &uinfo);
/* set prompt */
strcpy(prompt, mychatid);
strcat(prompt, ": ");
prompt[SAYWORD_POINT] = '\0';
draw_chat_screen();
add_io(ac, 0);
net_gets(ac, genbuf, sizeof(genbuf)); /* welcome !! */
genbuf[strlen(genbuf) - 1] = '\0';
printchatline(genbuf);
#if 0
net_printf(ac, "JOIN\t%s\t%s\r\n", DEFAULT_CHANNAME, NOPASSWORD);
net_gets(ac, genbuf, sizeof(genbuf));
#endif
if (strcmp(mychatid, curuser.userid))
{
net_printf(ac, "NICKNAME\t%s\r\n", mychatid);
net_gets(ac, genbuf, sizeof(genbuf));
}
/* Chat Main */
while (1)
{
ch = getkey();
if (PLINE != CUR_PLINE) {
draw_chat_screen();
continue;
}
if (talkrequest)
page_pending = TRUE;
if (page_pending)
page_pending = servicepage(0);
if (msqrequest)
{
add_io(0, 0);
msqrequest = FALSE;
msq_reply();
add_io(ac, 0);
continue;
}
if (ch == I_OTHERDATA)
{
if (!net_gets(ac, rcvbuf, sizeof(rcvbuf)))
break;
rcvbuf[strlen(rcvbuf) - 1] = '\0'; /* lthuang */
if (rcvbuf[0] == '/')
{
char *p, *nick;
if ((p = strchr(rcvbuf, '\t')) != NULL)
{
*p = '\0';
if (cmp_wlist(iglist, rcvbuf + 1, strcmp))
continue;
nick = p + 1;
if ((p = strchr(nick, '\t')) != NULL)
{
*p = '\0';
if (cmp_wlist(iglist, nick, strcmp))
continue;
strcpy(genbuf, nick);
strcat(genbuf, ": ");
genbuf[SAYWORD_POINT] = '\0';
strcat(genbuf, ++p);
printchatline(genbuf);
}
}
}
#if 0
else if (rcvbuf[0] == '*')
{
sprintf(genbuf, "[1;37m%s[0m", rcvbuf);
printchatline(genbuf);
}
#endif
else
printchatline(rcvbuf);
}
else if (isprint2(ch))
{
if (SAYWORD_POINT + currchar - 1 >= t_columns - 3)
{
bell();
continue;
}
inbuf[currchar++] = ch;
inbuf[currchar] = '\0';
move(PLINE, SAYWORD_POINT + currchar - 1);
outc(ch);
}
else if (ch == '\n' || ch == '\r')
{
char *p = inbuf;
currchar = 0;
while (*p != '\0' && isspace((int)(*p)))
p++;
if (*p == '\0')
continue;
if (inbuf[0] == '/')
dochatcommand(inbuf + 1);
else
{
net_printf(ac, "SPEAK\t%s\r\n", inbuf);
sprintf(genbuf, "%s%s", prompt, inbuf);
printchatline(genbuf);
}
inbuf[0] = '\0';
/* show prompt */
move(PLINE, 0);
clrtoeol();
outs(prompt);
}
else if (ch == CTRL('H') || ch == '\177')
{
if (currchar == 0)
{
bell();
continue;
}
move(PLINE, SAYWORD_POINT + --currchar);
outs(" ");
inbuf[currchar] = '\0';
}
else if (ch == CTRL('C') || ch == CTRL('D'))
{
net_printf(ac, "QUIT\r\n"); /* lthuang */
break;
}
else if (ch == CTRL('R'))
{
msq_reply();
continue;
}
else if (ch == CTRL('Q'))
{
add_io(0, 0);
t_query();
add_io(ac, 0);
continue;
}
move(PLINE, currchar + SAYWORD_POINT);
}
add_io(0, 0);
close(ac);
uinfo.chatid[0] = '\0';
update_ulist(cutmp, &uinfo);
free_wlist(&iglist, free);
return C_FULL;
}
int PRS_PUANTAJLARI_GOR_VE_DUZELT_FISI::GET_FIS_RECORD ( int record_id )
{
SQL_QUERY query ( DB );
SQL_QUERY s_query ( DB );
QString bordro_bas_donemi = PRS_GET_BORDRO_DONEMI_BAS_STRING( m_bordro_yili, m_bordro_ayi );
QString bordro_bts_donemi = PRS_GET_BORDRO_DONEMI_BTS_STRING( m_bordro_yili, m_bordro_ayi );
// isten ayrilanlar
query.PREPARE_SELECT("prs_personel_nufus_blgler, prs_personeller, prs_personel_kisisel_blgler " ,
"prs_personel_nufus_blgler.personel_id, "
"ucret_sekli, "
"net_ucret, "
"brut_ucret , "
"ise_giris_tarihi, "
"cari_hesap_id, "
"ise_giris_tarihi, "
"calisma_sekli, "
"haftalik_calisilan_gun_sayisi,"
"isten_cikis_tarihi",
"prs_personel_nufus_blgler.personel_id = prs_personeller.personel_id "
"AND prs_personel_kisisel_blgler.personel_id = prs_personeller.personel_id "
"AND sube_id = :sube_id "
"AND ise_giris_tarihi <= :ise_giris_tarihi "
"AND isten_cikis_tarihi >= :isten_cikis_tarihi " );
query.SET_VALUE(":sube_id" , m_sube_id);
query.SET_VALUE(":ise_giris_tarihi" , bordro_bts_donemi );
query.SET_VALUE(":isten_cikis_tarihi" , bordro_bas_donemi );
if ( query.SELECT() EQ 0) {
return ADAK_OK;
}
int current_row = -1;
int prs_doviz_id = 0;
while ( query.NEXT() NE 0 ) {
int personel_id = query.VALUE("personel_id").toInt();
int cari_hesap_id = query.VALUE( "cari_hesap_id").toInt();
QDate ise_giris_tarihi = QDate::fromString( query.VALUE( "ise_giris_tarihi" ).toString(), "yyyy.MM.dd" );
QString isten_cikis_tarihi = query.VALUE( "isten_cikis_tarihi" ).toString();
CARI_HESAP_STRUCT hesap_bilgileri;
CARI_SET_HESAP_STRUCT_DEFAULTS(&hesap_bilgileri);
CARI_KART_BILGILERINI_OKU( cari_hesap_id, &hesap_bilgileri );
current_row = ADD_NEW_LINE();
QLineEdit * line_edit_adi_soyad = ( QLineEdit * ) m_ui->table_widget_gun_satirlari->cellWidget(current_row ,ADI_COLUMN);
line_edit_adi_soyad->setText( hesap_bilgileri.cari_hesap_ismi );
int calisma_sekli = query.VALUE("calisma_sekli").toInt();
prs_doviz_id = CARI_GET_PARA_BIRIM_ID( cari_hesap_id );
int ucret_sekli_enum = query.VALUE( "ucret_sekli" ).toInt();
double net_ucret = query.VALUE( "net_ucret" ).toDouble();
double brut_ucret = query.VALUE( "brut_ucret" ).toDouble();
double haftalik_calisilan_gun_sayisi = query.VALUE( "haftalik_calisilan_gun_sayisi" ).toDouble();
double prs_personel_ucret = net_ucret;
if ( ucret_sekli_enum EQ PRS_BRUT ) {
prs_personel_ucret = brut_ucret;
}
QTableWidgetItem * new_item;
new_item = new QTableWidgetItem(tr("%1").arg(personel_id));
m_ui->table_widget_gun_satirlari->setItem(current_row ,ROW_ID_COLUMN ,new_item);
new_item=new QTableWidgetItem(tr("%1").arg(record_id));
m_ui->table_widget_gun_satirlari->setItem(current_row ,RECORD_ID_COLUMN ,new_item);
QLineEdit * line_edit_calisma_sekli = ( QLineEdit * ) m_ui->table_widget_gun_satirlari->cellWidget(current_row, CALISMA_SEKLI);
line_edit_calisma_sekli->setText( QVariant ( calisma_sekli ).toString() );
s_query.PREPARE_SELECT ("prs_puantaj","gun_sayisi ",
"personel_id = :personel_id "
"AND bordro_donemi_yil = :bordro_donemi_yil "
"AND bordro_donemi_ay = :bordro_donemi_ay ");
s_query.SET_VALUE (":personel_id" , personel_id );
s_query.SET_VALUE (":bordro_donemi_yil" , m_bordro_yili );
s_query.SET_VALUE (":bordro_donemi_ay" , m_bordro_ayi );
QCommaEdit * comma_edit_doviz_kuru = ( QCommaEdit * ) m_ui->table_widget_gun_satirlari->cellWidget( current_row, KUR_COLUMN );
QCommaEdit * comma_edit_aldigi_ucret = ( QCommaEdit * ) m_ui->table_widget_gun_satirlari->cellWidget( current_row, ALDIGI_UCRET );
QCommaEdit * comma_edit_ucret_tutari = ( QCommaEdit * ) m_ui->table_widget_gun_satirlari->cellWidget( current_row, TEMEL_PARABIRIMI_UCRET );
QCommaEdit * comma_edit_gun = ( QCommaEdit * ) m_ui->table_widget_gun_satirlari->cellWidget(current_row,CALISTIGI_GUN_COLUMN);
QCommaEdit * comma_edit_ek_odenek = ( QCommaEdit * ) m_ui->table_widget_gun_satirlari->cellWidget(current_row,EK_ODENEK_TUTARI);
QCommaEdit * comma_edit_ek_kesinti = ( QCommaEdit * ) m_ui->table_widget_gun_satirlari->cellWidget(current_row,EK_KESINTI_TUTARI);
QCommaEdit * comma_edit_gunluk_ucret = ( QCommaEdit * ) m_ui->table_widget_gun_satirlari->cellWidget(current_row,GUNLUK_UCRET );
QCommaEdit * comma_edit_yemek_verilen_gun_sayisi= ( QCommaEdit * ) m_ui->table_widget_gun_satirlari->cellWidget(current_row,YEMEK_VERILEN_GUN_SAYISI );
comma_edit_yemek_verilen_gun_sayisi->SET_DOUBLE( haftalik_calisilan_gun_sayisi * 4 );
double eksik_gun_sayisi = PRS_GET_EKSIK_GUN_SAYISI( personel_id, m_bordro_ayi, m_bordro_yili );
if ( eksik_gun_sayisi > 0.00 ) {
if ( isten_cikis_tarihi NE "9999.99.99" ) {
comma_edit_gun->SET_DOUBLE( QDate::fromString( isten_cikis_tarihi, "yyyy.MM.dd").daysInMonth() - eksik_gun_sayisi );
}
else {
comma_edit_gun->SET_DOUBLE( QDate::fromString( bordro_bts_donemi, "yyyy.MM.dd").daysInMonth() - eksik_gun_sayisi );
}
}
else {
if ( isten_cikis_tarihi NE "9999.99.99" ) {
QDate isten_cikis_date = QDate::fromString( isten_cikis_tarihi, "yyyy.MM.dd");
comma_edit_gun->SET_DOUBLE( isten_cikis_date.day() );
}
else {
comma_edit_gun->SET_DOUBLE( 30 );
}
}
int gun_sayisi = comma_edit_gun->GET_DOUBLE();
if ( ise_giris_tarihi.year() EQ m_bordro_yili ) {
QDate bordro_tarihi;
if ( ise_giris_tarihi.month() EQ m_bordro_ayi ) {
int ise_giris_gunu = ise_giris_tarihi.day();
bordro_tarihi = QDate::fromString( bordro_bts_donemi, "yyyy.MM.dd" );
if ( isten_cikis_tarihi NE "9999.99.99" ) {
bordro_tarihi = QDate::fromString( isten_cikis_tarihi, "yyyy.MM.dd" );
gun_sayisi = bordro_tarihi.day();
}
else {
gun_sayisi = bordro_tarihi.daysInMonth();
}
gun_sayisi = gun_sayisi - ise_giris_gunu + 1 ;
comma_edit_gun->SET_INTEGER( gun_sayisi );
}
comma_edit_yemek_verilen_gun_sayisi->SET_DOUBLE( haftalik_calisilan_gun_sayisi * floor( comma_edit_gun->GET_DOUBLE() / 7.0 ) );
}
// GUNLUK UCRET PUANTAJ'DA GUN DEGISTIRILIRSE OTOMATIK CARPILACAK
comma_edit_gunluk_ucret->SET_DOUBLE( ROUND( prs_personel_ucret / 30 ));
if ( calisma_sekli EQ ENUM_GUNLUK ) {
comma_edit_gunluk_ucret->SET_DOUBLE( prs_personel_ucret );
}
if ( calisma_sekli EQ ENUM_AYLIK and gun_sayisi > 30 ) {
comma_edit_gun->SET_DOUBLE( 30 );
}
if ( calisma_sekli EQ ENUM_GUNLUK ) {
prs_personel_ucret = ROUND( comma_edit_gun->GET_DOUBLE() * comma_edit_gunluk_ucret->GET_DOUBLE() );
}
if ( prs_doviz_id NE DVZ_GET_TEMEL_PARA_BIRIMI_ID() ) {
comma_edit_doviz_kuru->setEnabled( true );
}
// personel ek odenek bilgileri sorgulaniyor.
double toplam_ek_odenek = 0.00;
double toplam_ek_kesinti = 0.00;
SQL_QUERY t_query( DB );
t_query.PREPARE_SELECT( "prs_ek_kesintiler_odenekler",
"yuzde_mi, yuzde_orani, tutar, kesinti_odenek_turu ",
"personel_id = :personel_id AND "
"bordro_donemi_yil = :bordro_donemi_yil AND "
"bordro_donemi_ay = :bordro_donemi_ay ");
t_query.SET_VALUE( ":personel_id" , personel_id );
t_query.SET_VALUE( ":bordro_donemi_yil" , m_bordro_yili );
t_query.SET_VALUE( ":bordro_donemi_ay " , m_bordro_ayi );
if ( t_query.SELECT() NE 0 ) {
while ( t_query.NEXT() EQ true ) {
int yuzde_mi = t_query.VALUE( "yuzde_mi" ).toInt();
int kesinti_odenek_turu = t_query.VALUE( "kesinti_odenek_turu" ).toInt();
double yuzde_orani = t_query.VALUE( "yuzde_orani" ).toDouble();
double tutar = t_query.VALUE( "tutar" ).toDouble();
if ( yuzde_mi EQ 1 ) {
if ( kesinti_odenek_turu EQ ENUM_PRS_ODENEK ) {
toplam_ek_odenek += ROUND( prs_personel_ucret * yuzde_orani );
}
if ( kesinti_odenek_turu EQ ENUM_PRS_KESINTI ) {
toplam_ek_kesinti += ROUND( prs_personel_ucret * yuzde_orani );
}
}
else {
if ( kesinti_odenek_turu EQ ENUM_PRS_ODENEK ) {
toplam_ek_odenek += tutar;
}
if ( kesinti_odenek_turu EQ ENUM_PRS_KESINTI ) {
toplam_ek_kesinti += tutar;
}
}
}
}
comma_edit_aldigi_ucret->SET_DOUBLE ( prs_personel_ucret );
comma_edit_ek_odenek->SET_DOUBLE ( toplam_ek_odenek );
comma_edit_ek_kesinti->SET_DOUBLE ( toplam_ek_kesinti );
comma_edit_doviz_kuru->SET_DOUBLE ( DVZ_DOVIZ_KURUNU_AL( prs_doviz_id, QDate::currentDate(), ENUM_SATIS ) );
comma_edit_ucret_tutari->SET_DOUBLE ( ROUND( comma_edit_doviz_kuru->GET_DOUBLE() * prs_personel_ucret ) );
if ( s_query.SELECT() EQ 0 ) {
DB->START_TRANSACTION();
QCommaEdit * comma_edit_kur = ( QCommaEdit * ) m_ui->table_widget_gun_satirlari->cellWidget(current_row ,KUR_COLUMN);
SQL_QUERY insert_query(DB);
insert_query.PREPARE_INSERT("prs_puantaj", "puantaj_id" ,
"personel_id , gun_sayisi ,doviz_kuru, "
"temel_para_birim_tutari , bordro_donemi_yil, bordro_donemi_ay, yemek_verilen_gun_sayisi ");
insert_query.SET_VALUE(":personel_id" , personel_id);
insert_query.SET_VALUE(":gun_sayisi" , comma_edit_gun->GET_DOUBLE());
insert_query.SET_VALUE(":doviz_kuru" , comma_edit_kur->GET_DOUBLE());
insert_query.SET_VALUE(":temel_para_birim_tutari" , comma_edit_ucret_tutari->GET_DOUBLE() );
insert_query.SET_VALUE(":bordro_donemi_yil" , m_bordro_yili );
insert_query.SET_VALUE(":bordro_donemi_ay" , m_bordro_ayi );
insert_query.SET_VALUE(":yemek_verilen_gun_sayisi" , comma_edit_yemek_verilen_gun_sayisi->GET_DOUBLE() );
insert_query.INSERT();
DB->COMMIT_TRANSACTION();
}
}
return ADAK_OK;
}
int tui_query(void)
{
return t_query(NULL);
}
static int set_keydefine_key(struct _select_def *conf, int key)
{
int oldmode;
switch (key) {
case KEY_TAB:
ask_define();
return SHOW_DIRCHANGE;
case 'a': /* add new user */
if (keymem_total < MAX_KEY_DEFINE) {
int i,j;
struct key_struct k;
char buf[120];
clear();
move(1, 0);
prints("请键入自定义键: ");
do {
i = igetkey();
get_key_name(i, buf);
} while (!buf[0]&&i!=KEY_ESC);
if (i==KEY_ESC) return SHOW_DIRCHANGE;
prints("%s\n", buf);
k.key = i;
move(2, 0);
prints("请输入替换序列(最多10个)，按一次ESC结束: ");
j=0;
do {
do {
i = igetkey();
get_key_name(i, buf);
} while (!buf[0]&&i!=KEY_ESC);
if (i==KEY_ESC) break;
prints("%s ", buf);
k.mapped[j] = i;
j++;
if (j>=10) break;
} while (1);
if (j<10) k.mapped[j]=0;
if (j==0) return SHOW_DIRCHANGE;
k.status[0] = -1;
add_key(&k);
return SHOW_DIRCHANGE;
}
break;
case 'e':
set_modes(keymem[conf->pos-1].status);
return SHOW_DIRCHANGE;
case 's': {
int i,j,x,y;
struct key_struct k;
char buf[120];
memmove(&k,keymem+conf->pos-1,sizeof(struct key_struct));
clear();
move(1, 0);
prints("请键入自定义键: ");
do {
i = igetkey();
get_key_name(i, buf);
} while (!buf[0]&&i!=KEY_ESC);
if (i==KEY_ESC) return SHOW_DIRCHANGE;
prints("%s\n", buf);
k.key = i;
move(2, 0);
prints("请输入替换序列(最多10个)，按一次ESC结束: ");
j=0;
do {
do {
i = igetkey();
get_key_name(i, buf);
} while (!buf[0]&&i!=KEY_ESC);
if (i==KEY_ESC) break;
getyx(&y,&x);
prints((x+strlen(buf)<t_columns-1)?"%s ":"\n%s ",buf);
k.mapped[j] = i;
j++;
if (j>=10) break;
} while (1);
if (j<10) k.mapped[j]=0;
if (j==0) return SHOW_DIRCHANGE;
memcpy(keymem+conf->pos-1, &k, sizeof(struct key_struct));
return SHOW_DIRCHANGE;
}
break;
case 'x': {
struct key_struct k;
int i;
char buf[128];
memmove(&k,keymem+conf->pos-1,sizeof(struct key_struct));
clear();
move(1,0);
prints("请键入自定义键: ");
do {
i=igetkey();
get_key_name(i,buf);
} while (!buf[0]&&i!=KEY_ESC);
if (i==KEY_ESC)
return SHOW_DIRCHANGE;
k.key=i;
prints("%s",buf);
memmove(keymem+conf->pos-1,&k,sizeof(struct key_struct));
prints("\n\n\033[1;33m%s\033[0;33m<Enter>\033[m","已更新!");
WAIT_RETURN;
return SHOW_DIRCHANGE;
}
break;
case 't': {
struct key_struct k;
int i,j,x,y;
char buf[128];
memmove(&k,keymem+conf->pos-1,sizeof(struct key_struct));
clear();
move(1,0);
prints("请输入替换序列(最多10个), 按一次ESC结束: ");
for (j=0; j<10; j++) {
do {
i=igetkey();
get_key_name(i,buf);
} while (!buf[0]&&i!=KEY_ESC);
if (i==KEY_ESC)
break;
getyx(&y,&x);
prints((x+strlen(buf)<t_columns-1)?"%s ":"\n%s ",buf);
k.mapped[j]=i;
}
if (!j)
return SHOW_DIRCHANGE;
if (j<10)
k.mapped[j]=0;
memmove(keymem+conf->pos-1,&k,sizeof(struct key_struct));
prints("\n\n\033[1;33m%s\033[0;33m<Enter>\033[m","已更新!");
WAIT_RETURN;
return SHOW_DIRCHANGE;
}
break;
case 'd': /* delete existed user */
if (keymem_total > 0) {
char ans[3];
getdata(t_lines - 1, 0, "确实要删除该定义键吗(Y/N)? [N]: ", ans, sizeof(ans), DOECHO, NULL, true);
if (ans[0] == 'Y' || ans[0] == 'y') {
remove_key(conf->pos-1);
if (keymem_total==0) {
struct key_struct key;
key.key = 'A';
key.mapped[0] = 'A';
key.mapped[1] = 0;
key.status[0] = 0;
add_key(&key);
}
}
return SHOW_DIRCHANGE;
}
break;
case 'L':
case 'l':
oldmode = uinfo.mode;
show_allmsgs();
modify_user_mode(oldmode);
return SHOW_REFRESH;
case 'W':
case 'w':
oldmode = uinfo.mode;
if (!HAS_PERM(getCurrentUser(), PERM_PAGE))
break;
s_msg();
modify_user_mode(oldmode);
return SHOW_REFRESH;
case 'u':
oldmode = uinfo.mode;
clear();
modify_user_mode(QUERY);
t_query(NULL);
modify_user_mode(oldmode);
clear();
return SHOW_REFRESH;
}
return SHOW_CONTINUE;
}
static int tmpl_key(struct _select_def *conf, int key)
{
int oldmode;
switch (key) {
case 'a' :
tmpl_check_limit(template_num);
tmpl_add();
return SHOW_DIRCHANGE;
break;
case 'd' : {
char ans[3];
getdata(t_lines - 1, 0, "确实要删除吗(Y/N)? [N]: ", ans, sizeof(ans), DOECHO, NULL, true);
if (ans[0] == 'Y' || ans[0] == 'y') {
int i;
deepfree(ptemplate + conf->pos - 1, currboard->filename);
template_num--;
for (i=conf->pos-1; i<template_num; i++)
memcpy(ptemplate+i, ptemplate+i+1, sizeof(struct a_template));
ptemplate[template_num].tmpl = NULL;
ptemplate[template_num].cont = NULL;
tmpl_save();
}
if (template_num > 0)
return SHOW_DIRCHANGE;
else
return SHOW_QUIT;
}
break;
case 'c':
do {
extern bool in_do_sendmsg;
extern int super_select_board(char *bname);
int ret;
char bname[STRLEN] = "";
move(0,0); clrtoeol();
prints("%s","复制到讨论区 [ \033[1;32mSPACE/TAB\033[m - 自动补全, \033[1;32mESC\033[m - 退出 ]");
move(1,0); clrtoeol();
prints("请输入讨论区名称 [\033[1;32m%s\033[m]: ",currboard->filename);
make_blist(0, 3);
in_do_sendmsg=1;
ret = namecomplete(NULL, bname);
in_do_sendmsg=0;
CreateNameList(); /* free list memory. */
if (ret == KEY_ESC) {
/* noop */
} else if (!*bname || !strcmp(bname, currboard->filename)) {
/* copy to current board */
tmpl_check_BM(currboard->filename); /* sanity check, how about stick here when deposing? */
tmpl_check_limit(template_num);
if (tmpl_copy(conf->pos))
tmplcp_sorry();
else
tmplcp_success();
} else { /* copy to another board */
struct a_template *ptemp;
int temp_num = tmpl_init_ex(0, bname, &ptemp);
if (temp_num >= 0) {
tmpl_check_BM(bname); /* sanity check */
tmpl_check_limit(temp_num);
if (tmpl_copy_to_board(bname, &ptemp, &temp_num, conf->pos))
tmplcp_sorry();
else
tmplcp_success();
tmpl_free_ex(&ptemp, temp_num);
}
}
} while (0);
return SHOW_DIRCHANGE;
/* etnlegend, 2006.05.19, move templates... */
case 'm':
do {
struct a_template temp;
char ans[4];
int i,pos;
getdata(t_lines-1,0,"请输入希望移动到的位置序号: ",ans,4,DOECHO,NULL,true);
trimstr(ans);
if (!isdigit(ans[0]))
break;
pos=atoi(ans);
pos=((pos<1)?1:((pos>template_num)?template_num:pos));
if (pos==conf->pos)
break;
memcpy(&temp,&ptemplate[conf->pos-1],sizeof(struct a_template));
if (pos>conf->pos) {
for (i=(conf->pos-1); i<(pos-1); i++)
memcpy(&ptemplate[i],&ptemplate[i+1],sizeof(struct a_template));
} else {
for (i=(conf->pos-1); i>(pos-1); i--)
memcpy(&ptemplate[i],&ptemplate[i-1],sizeof(struct a_template));
}
memcpy(&ptemplate[pos-1],&temp,sizeof(struct a_template));
tmpl_save();
} while (0);
return SHOW_DIRCHANGE;
/* END - etnlegend, 2006.05.19, move templates ... */
case 't' : {
char newtitle[60];
strcpy(newtitle, ptemplate[conf->pos-1].tmpl->title);
getdata(t_lines - 1, 0, "新名称: ", newtitle, 50, DOECHO, NULL, false);
if (newtitle[0] == '\0' || newtitle[0]=='\n' || ! strcmp(newtitle,ptemplate[conf->pos-1].tmpl->title))
return SHOW_REFRESH;
strncpy(ptemplate[conf->pos-1].tmpl->title, newtitle, 50);
ptemplate[conf->pos-1].tmpl->title[49]='\0';
tmpl_save();
return SHOW_REFRESH;
}
break;/*
case 'z' :
{
char newtitle[30];
strcpy(newtitle, ptemplate[conf->pos-1].tmpl->title_prefix);
getdata(t_lines - 1, 0, "请输入此模板的文章标题前缀: ", newtitle, 20, DOECHO, NULL, false);
if( newtitle[0] == '\0' || newtitle[0]=='\n' || ! strcmp(newtitle,ptemplate[conf->pos-1].tmpl->title_prefix) )
return SHOW_REFRESH;
strncpy(ptemplate[conf->pos-1].tmpl->title_prefix, newtitle, 20);
ptemplate[conf->pos-1].tmpl->title_prefix[19]='\0';
tmpl_save();
return SHOW_REFRESH;
}*/
case 'f' : {
char filepath[STRLEN];
int oldmode;
oldmode = uinfo.mode;
modify_user_mode(EDITUFILE);
if (ptemplate[conf->pos-1].tmpl->filename[0] == '\0') {
setbfile(filepath, currboard->filename, "");
if (GET_POSTFILENAME(ptemplate[conf->pos-1].tmpl->filename, filepath) != 0) {
clear();
move(3,0);
prints("创建模板文件失败!");
pressanykey();
return SHOW_REFRESH;
}
tmpl_save();
}
setbfile(filepath, currboard->filename, ptemplate[conf->pos-1].tmpl->filename);
vedit(filepath,0,NULL,NULL,0);
modify_user_mode(oldmode);
return SHOW_REFRESH;
}
case 's' : {
char filepath[STRLEN];
setbfile(filepath, currboard->filename, ptemplate[conf->pos-1].tmpl->filename);
clear();
ansimore(filepath,1);
return SHOW_REFRESH;
}
case 'b' : {
if (ptemplate[conf->pos-1].tmpl->flag & TMPL_BM_FLAG)
ptemplate[conf->pos-1].tmpl->flag &= ~TMPL_BM_FLAG ;
else
ptemplate[conf->pos-1].tmpl->flag |= TMPL_BM_FLAG;
tmpl_save();
return SHOW_REFRESH;
}
case 'i' : {
char newtitle[STRLEN];
strcpy(newtitle, ptemplate[conf->pos-1].tmpl->title_tmpl);
getdata(t_lines - 1, 0, "新文章标题: ", newtitle, STRLEN, DOECHO, NULL, false);
if (newtitle[0] == '\0' || newtitle[0]=='\n' || ! strcmp(newtitle,ptemplate[conf->pos-1].tmpl->title_tmpl))
return SHOW_REFRESH;
strncpy(ptemplate[conf->pos-1].tmpl->title_tmpl, newtitle, STRLEN);
ptemplate[conf->pos-1].tmpl->title_tmpl[STRLEN-1]='\0';
tmpl_save();
return SHOW_REFRESH;
}
case 'x' : {
clear();
move(2,0);
prints("此模版的标题设置为");
move(4,0);
prints("%s",ptemplate[conf->pos-1].tmpl->title_tmpl);
pressanykey();
return SHOW_REFRESH;
}
/*
case 'h':
{
clear();
move(1,0);
prints(" x : 查看标题格式\n");
prints(" i : 修改标题格式");
pressanykey();
return SHOW_REFRESH;
}
*/
case 'l': /* by pig2532 on 2005.12.01 */
oldmode = uinfo.mode;
show_allmsgs();
modify_user_mode(oldmode);
return SHOW_REFRESH;
case 'w': /* by pig2532 on 2005-12-1 */
oldmode = uinfo.mode;
if (!HAS_PERM(getCurrentUser(), PERM_PAGE))
break;
s_msg();
modify_user_mode(oldmode);
return SHOW_REFRESH;
case 'u': /* by pig2532 on 2005-12-1 */
clear();
oldmode = uinfo.mode;
modify_user_mode(QUERY);
t_query(NULL);
modify_user_mode(oldmode);
return SHOW_REFRESH;
case 'U': /* pig2532 2005.12.10 */
board_query();
return SHOW_REFRESH;
default :
break;
}
return SHOW_CONTINUE;
}
static int content_key(struct _select_def *conf, int key)
{
int oldmode;
switch (key) {
case 'm': {
char ans[5];
int newm;
getdata(t_lines-1, 0, "移动到新次序:", ans, 4, DOECHO, NULL, true);
if (ans[0]=='\0' || ans[0]=='\n' || ans[0]=='\r')
return SHOW_REFRESH;
newm=atoi(ans);
if (newm <= 0 || newm > ptemplate[t_now].tmpl->content_num)
return SHOW_REFRESH;
if (newm > conf->pos) {
int i;
struct s_content sc;
memcpy(&sc, &ptemplate[t_now].cont[conf->pos-1], sizeof(struct s_content));
for (i=conf->pos; i<newm; i++)
memcpy(& ptemplate[t_now].cont[i-1], & ptemplate[t_now].cont[i], sizeof(struct s_content));
memcpy(&ptemplate[t_now].cont[newm-1], &sc, sizeof(struct s_content));
tmpl_save();
return SHOW_REFRESH;
} else if (newm < conf->pos) {
int i;
struct s_content sc;
memcpy(&sc, &ptemplate[t_now].cont[conf->pos-1], sizeof(struct s_content));
for (i=conf->pos; i>newm; i--)
memcpy(& ptemplate[t_now].cont[i-1], & ptemplate[t_now].cont[i-2], sizeof(struct s_content));
memcpy(&ptemplate[t_now].cont[newm-1], &sc, sizeof(struct s_content));
tmpl_save();
return SHOW_REFRESH;
} else
return SHOW_REFRESH;
}
case 'a':
if (ptemplate[t_now].tmpl->content_num >= MAX_CONTENT) {
char ans[STRLEN];
move(t_lines - 1, 0);
clrtoeol();
a_prompt(-1, "选项已满，按回车继续 << ", ans);
move(t_lines - 1, 0);
clrtoeol();
return SHOW_CONTINUE;
}
content_add();
return SHOW_DIRCHANGE;
break;
case 'd': {
char ans[3];
getdata(t_lines - 1, 0, "确实要删除吗(Y/N)? [N]: ", ans, sizeof(ans), DOECHO, NULL, true);
if (ans[0] == 'Y' || ans[0] == 'y') {
int i=0;
struct s_content *ct;
if (ptemplate[t_now].tmpl->content_num == 1) {
ptemplate[t_now].tmpl->content_num = 0;
free(ptemplate[t_now].cont);
tmpl_save();
return SHOW_QUIT;
}
ct = (struct s_content *) malloc(sizeof(struct s_content) * (ptemplate[t_now].tmpl->content_num-1));
memcpy(ct+i,&(ptemplate[t_now].cont[i]),sizeof(struct s_content) *(conf->pos-1));
for (i=conf->pos-1; i<ptemplate[t_now].tmpl->content_num-1; i++)
memcpy(ct+i, &(ptemplate[t_now].cont[i+1]), sizeof(struct s_content));
free(ptemplate[t_now].cont);
ptemplate[t_now].cont = ct;
ptemplate[t_now].tmpl->content_num --;
tmpl_save();
return SHOW_DIRCHANGE;
}
return SHOW_REFRESH;
}
case 't' : {
char newtitle[60];
strcpy(newtitle, ptemplate[t_now].cont[conf->pos-1].text);
getdata(t_lines - 1, 0, "新标题: ", newtitle, 50, DOECHO, NULL, false);
if (newtitle[0] == '\0' || newtitle[0]=='\n' || ! strcmp(newtitle,ptemplate[t_now].cont[conf->pos-1].text))
return SHOW_REFRESH;
strncpy(ptemplate[t_now].cont[conf->pos-1].text, newtitle, 50);
ptemplate[t_now].cont[conf->pos-1].text[49]='\0';
tmpl_save();
return SHOW_REFRESH;
}
break;
case 'l' : {
char newlen[10];
int nl;
sprintf(newlen,"%-3d",ptemplate[t_now].cont[conf->pos-1].length);
getdata(t_lines-1, 0, "新长度: ", newlen, 5, DOECHO, NULL, false);
nl = atoi(newlen);
if (nl <= 0 || nl > MAX_CONTENT_LENGTH || nl == ptemplate[t_now].cont[conf->pos-1].length)
return SHOW_REFRESH;
ptemplate[t_now].cont[conf->pos-1].length = nl;
tmpl_save();
return SHOW_REFRESH;
}
break;
case 'w': /* by pig2532 on 2005-12-1 */
oldmode = uinfo.mode;
if (!HAS_PERM(getCurrentUser(), PERM_PAGE))
break;
s_msg();
modify_user_mode(oldmode);
return SHOW_REFRESH;
case 'u': /* by pig2532 on 2005-12-1 */
clear();
oldmode = uinfo.mode;
modify_user_mode(QUERY);
t_query(NULL);
modify_user_mode(oldmode);
return SHOW_REFRESH;
case 'U': /* pig2532 2005.12.10 */
board_query();
return SHOW_REFRESH;
default:
break;
}
return SHOW_CONTINUE;
}
static choose_handler_t choose_board_handler(choose_t *cp, int ch)
{
choose_board_t *cbrd = cp->data;
board_data_t *ptr;
char ans[2];
bool modify_mode = false;
switch (ch) {
case '*':
if (cbrd->brds[cp->cur].flag & BOARD_CUSTOM_FLAG)
return DONOTHING;
ptr = cbrd->brds + cp->cur;
show_board_info(ptr->name);
return FULLUPDATE;
case 'C':
return tui_goodbrd_copy(cp);
case 'c':
cbrd->newflag = !cbrd->newflag;
return PARTUPDATE;
case 'L':
m_read();
cp->valid = false;
modify_mode = true;
break;
case 'M':
m_new();
cp->valid = false;
modify_mode = true;
break;
case 'u':
modify_user_mode(QUERY);
t_query();
modify_mode = true;
break;
case 'H':
getdata(t_lines - 1, 0, "您选择? (1) 本日十大 (2) 系统热点 [1]",
ans, 2, DOECHO, YEA);
if (ans[0] == '2')
show_help("etc/hotspot");
else
show_help("0Announce/bbslist/day");
break;
case 'l':
msg_more();
modify_mode = true;
break;
case 'P':
return tui_goodbrd_paste(cp);
case '!':
save_zapbuf(cbrd);
free(cbrd->brds);
free(cbrd->gbrds);
Goodbye();
return -1;
case 'h':
show_help("help/boardreadhelp");
break;
case '/':
// TODO: search.
break;
case 's':
if (currentuser.flags[0] & BRDSORT_FLAG) {
currentuser.flags[0] ^= BRDSORT_FLAG;
currentuser.flags[0] |= BRDSORT_ONLINE;
cbrd->cmp = board_cmp_online;
} else if (currentuser.flags[0] & BRDSORT_ONLINE) {
currentuser.flags[0] ^= BRDSORT_ONLINE;
cbrd->cmp = board_cmp_default;
} else {
currentuser.flags[0] |= BRDSORT_FLAG;
cbrd->cmp = board_cmp_flag;
}
qsort(cbrd->brds, cbrd->num, sizeof(*cbrd->brds), cbrd->cmp);
substitut_record(PASSFILE, ¤tuser,
sizeof(currentuser), usernum);
return PARTUPDATE;
case 'y':
if (cbrd->gnum)
return DONOTHING;
cbrd->yank = !cbrd->yank;
cp->valid = false;
return PARTUPDATE;
case 'z':
if (cbrd->gnum)
return DONOTHING;
if (HAS_PERM(PERM_LOGIN)
&& !(cbrd->brds[cp->cur].flag & BOARD_NOZAP_FLAG)) {
ptr = cbrd->brds + cp->cur;
ptr->zap = !ptr->zap;
ptr->total = -1;
cbrd->zapbuf[ptr->pos] = (ptr->zap ? 0 : login_start_time);
}
cp->valid = false;
return PARTUPDATE;
case 'a':
return tui_goodbrd_add(cp);
case 'A':
return tui_goodbrd_mkdir(cp);
case 'T':
return tui_goodbrd_rename(cp);
case 'd':
return tui_goodbrd_rm(cp);
case '\r':
case '\n':
case KEY_RIGHT:
if (cbrd->num > 0)
choose_board_read(cp);
cp->valid = false;
modify_mode = true;
break;
case 'S':
if (!HAS_PERM(PERM_TALK))
return DONOTHING;
s_msg();
modify_mode = true;
break;
case 'o':
if (!HAS_PERM(PERM_LOGIN))
return DONOTHING;
online_users_show_override();
modify_mode = true;
break;
default:
return DONOTHING;
}
if (modify_mode)
modify_user_mode(cbrd->newflag ? READNEW : READBRD);
return FULLUPDATE;
}
void CEK_MUSTERI_CEK_SENET_ARAMA::SEARCH()
{
QString log_detaylari;
if ( m_cek_senet_turu EQ ENUM_CEK ) {
log_detaylari = QObject::tr ( "Müşteri Çekleri Arama " );
}
else {
log_detaylari = QObject::tr ( "Müşteri Senetleri Arama ");
}
if(m_ui->checkbox_cekin_durumu->isChecked() EQ true ) {
log_detaylari.append ( " , " + m_ui->combobox_cekin_durumu->currentText());
}
if(m_ui->checkbox_cari_hesap->isChecked() EQ true ) {
log_detaylari.append ( " , " + m_ui->searchEdit_cari_hesap_kodu->GET_TEXT() + " " + m_ui->lineedit_cari_hesap_ismi->text());
}
if(m_ui->checkbox_vade_tarihi->isChecked() EQ true ) {
log_detaylari.append ( "\nVade Tarihi Aralığı : " + m_ui->adakDate_vade_bas_tarihi->QDATE().toString("dd MMMM YYYY")
+ " - " + m_ui->adakDate_vade_bts_tarih->QDATE().toString("dd MMMM yyyy"));
}
DB->START_TRANSACTION();
K9_LOG_KAYDI_EKLE (CEKSENET_MODULU , LOG_CEK_RAPORLAR , LOG_ISLEM_RAPOR_ALINDI , log_detaylari);
DB->COMMIT_TRANSACTION();
QString table_names = "";
QString vade_bas_tarihi = m_ui->adakDate_vade_bas_tarihi->DATE();
QString vade_bts_tarihi = m_ui->adakDate_vade_bts_tarih->DATE();
if ( m_cek_senet_turu EQ ENUM_CEK ) {
table_names = QString ( "cek_senet_id,cek_senet_numarasi,vade_tarihi,keside_tarihi,cek_senet_tutari,"
"cek_senet_son_durumu,banka_ismi,sube_ismi");
}
else {
table_names = QString ( "cek_senet_id,cek_senet_numarasi,vade_tarihi,keside_tarihi,cek_senet_tutari,"
"cek_senet_son_durumu " );
}
SQL_QUERY f_query ( DB );
SQL_QUERY s_query ( DB );
f_query.PREPARE_SELECT ( "cek_cekler_senetler", table_names, "cek_senet_turu=:cek_senet_turu" );
if ( m_ui->checkbox_vade_tarihi->isChecked() EQ true ) {
f_query.AND_EKLE ("vade_tarihi BETWEEN :baslangic_tarihi AND :bitis_tarihi" );
f_query.SET_VALUE(":baslangic_tarihi",vade_bas_tarihi );
f_query.SET_VALUE(":bitis_tarihi" ,vade_bts_tarihi );
}
if ( m_ui->checkbox_cekin_durumu->isChecked() EQ true ) {
f_query.AND_EKLE ("cek_senet_son_durumu = :cek_senet_son_durumu");
f_query.SET_VALUE(":cek_senet_son_durumu",CEK_GET_CEK_SENET_POZISYONU_ENUM ( m_ui->combobox_cekin_durumu->currentText()));
}
f_query.SET_VALUE(":cek_senet_turu", m_cek_senet_turu );
if ( m_entegre_filtresi EQ FIS_BIRINCI_SIRKET ) {
f_query.AND_EKLE ("kaydedilecek_sirket = :kaydedilecek_sirket");
f_query.SET_VALUE(":kaydedilecek_sirket",1);
}
else if ( m_entegre_filtresi EQ FIS_IKINCI_SIRKET ) {
f_query.AND_EKLE ("kaydedilecek_sirket = :kaydedilecek_sirket");
f_query.SET_VALUE(":kaydedilecek_sirket",0);
}
f_query.AND_EKLE ("musteri_ceki_mi=:musteri_ceki_mi");
f_query.SET_VALUE(":musteri_ceki_mi", 1 );
if ( f_query.SELECT() EQ 0 ) {
return;
}
int current_row = 0;
s_query.PREPARE_SELECT("cek_bordrolar , cek_bordro_satirlari","cari_hesap_id",
"bordro_islem_turu = :bordro_islem_turu AND cek_senet_id = :cek_senet_id "
"AND cek_bordrolar.bordro_id = cek_bordro_satirlari.bordro_id AND "
"cek_bordrolar.modul_id != :modul_id");
while ( f_query.NEXT() EQ true ) {
int cek_senet_id = f_query.VALUE(0).toInt();
s_query.SET_VALUE(":bordro_islem_turu" , ENUM_CEK_MUSTERIDEN_ALINDI);
s_query.SET_VALUE(":cek_senet_id" , cek_senet_id );
s_query.SET_VALUE(":modul_id" , CEKSENET_MODULU);
int cari_hesap_id = 0;
if ( s_query.SELECT() NE 0 ) {
s_query.NEXT();
cari_hesap_id = s_query.VALUE(0).toInt();
}
else {
SQL_QUERY t_query ( DB );
t_query.PREPARE_SELECT("cek_bordrolar,cek_bordro_satirlari ",
"alinan_cari_hesap_id ",
"bordro_islem_turu = :bordro_islem_turu AND cek_senet_id = :cek_senet_id "
"AND cek_bordrolar.bordro_id = cek_bordro_satirlari.bordro_id AND "
"bordro_turu = :bordro_turu ");
t_query.SET_VALUE(":bordro_islem_turu" , ENUM_CEK_MUSTERIDEN_ALINDI);
t_query.SET_VALUE(":cek_senet_id" , cek_senet_id);
t_query.SET_VALUE(":bordro_turu" , ENUM_CEK_SENET_ACILIS_BORDROSU);
if ( t_query.SELECT() EQ 0 ) {
continue;
}
t_query.NEXT();
cari_hesap_id = t_query.VALUE(0).toInt();
}
if ( m_ui->checkbox_cari_hesap->isChecked() EQ true ) {
int aranacak_cari_hesap_id = m_cari_hesap_id;
if ( cari_hesap_id NE aranacak_cari_hesap_id ) {
continue;
}
}
QString cari_hesap_kodu, cari_hesap_ismi;
int result = CARI_GET_HESAP_KODU_ISMI_PARA_BIRIM_ID( cari_hesap_id, &cari_hesap_kodu, &cari_hesap_ismi );
if ( result EQ 0 ) {
continue;
}
QString cari_hesap = cari_hesap_kodu+ " " + cari_hesap_ismi;
current_row = ADD_NEW_ROW();
if ( m_cek_senet_turu EQ ENUM_CEK ) {
m_ui->tableWidget->item ( current_row,0 )->setText(f_query.VALUE(0).toString());
m_ui->tableWidget->item ( current_row,1 )->setText(f_query.VALUE(1).toString());
m_ui->tableWidget->item ( current_row,2 )->setText(f_query.VALUE(2).toDate().toString("dd MMMM yyyy dddd"));
m_ui->tableWidget->item ( current_row,3 )->setText(f_query.VALUE(3).toDate().toString ( "dd MMMM yyyy dddd"));
m_ui->tableWidget->item ( current_row,4 )->setText(cari_hesap );
m_ui->tableWidget->item ( current_row,5 )->setText(f_query.VALUE(6).toString() );
m_ui->tableWidget->item ( current_row,6 )->setText(f_query.VALUE(7).toString() );
m_ui->tableWidget->item ( current_row,7 )->setText(VIRGUL_EKLE(f_query.VALUE(4).toString() ) );
}
else {
m_ui->tableWidget->item ( current_row,0 )->setText(f_query.VALUE(0).toString());
m_ui->tableWidget->item ( current_row,1 )->setText(f_query.VALUE(1).toString());
m_ui->tableWidget->item ( current_row,2 )->setText(f_query.VALUE(2).toDate().toString("dd MMMM yyyy dddd"));
m_ui->tableWidget->item ( current_row,3 )->setText(f_query.VALUE(3).toDate().toString("dd MMMM yyyy dddd"));
m_ui->tableWidget->item ( current_row,4 )->setText(cari_hesap );
m_ui->tableWidget->item ( current_row,5 )->setText(VIRGUL_EKLE ( f_query.VALUE(4).toString() ) );
}
QString cekin_durumu = CEK_GET_CEK_SENET_POZISYONU_STRING ( f_query.VALUE(5).toInt() );
if ( m_cek_senet_turu EQ ENUM_CEK ) {
m_ui->tableWidget->item ( current_row,8 )->setText ( cekin_durumu );
}
else {
m_ui->tableWidget->item ( current_row,6 )->setText ( cekin_durumu );
}
}
}
