void SQLI_cache_purge(struct db_cache *queue[], int index, struct insert_data *idata)
{
struct db_cache *LastElemCommitted = NULL;
time_t start;
int j, stop, ret;
for (j = 0, stop = 0; (!stop) && preprocess_funcs[j]; j++)
stop = preprocess_funcs[j](queue, &index, j);
if (config.what_to_count & COUNT_CLASS)
sql_invalidate_shadow_entries(queue, &index);
idata->ten = index;
if (config.debug) {
Log(LOG_DEBUG, "( %s/%s ) *** Purging cache - START ***\n", config.name, config.type);
start = time(NULL);
}
/* We check for variable substitution in SQL table */
if (idata->dyn_table) {
char tmpbuf[LONGLONGSRVBUFLEN];
time_t stamp = idata->new_basetime ? idata->new_basetime : idata->basetime;
strftime_same(insert_clause, LONGSRVBUFLEN, tmpbuf, &stamp);
strftime_same(update_clause, LONGSRVBUFLEN, tmpbuf, &stamp);
strftime_same(lock_clause, LONGSRVBUFLEN, tmpbuf, &stamp);
if (config.sql_table_schema) sql_create_table(bed.p, &stamp);
}
// strncat(update_clause, set_clause, SPACELEFT(update_clause));
(*sqlfunc_cbr.lock)(bed.p);
for (idata->current_queue_elem = 0; idata->current_queue_elem < index; idata->current_queue_elem++) {
if (queue[idata->current_queue_elem]->valid)
sql_query(&bed, queue[idata->current_queue_elem], idata);
if (queue[idata->current_queue_elem]->valid == SQL_CACHE_COMMITTED)
LastElemCommitted = queue[idata->current_queue_elem];
}
/* multi-value INSERT query: wrap-up */
if (idata->mv.buffer_elem_num) {
idata->mv.last_queue_elem = TRUE;
sql_query(&bed, LastElemCommitted, idata);
}
/* rewinding stuff */
(*sqlfunc_cbr.unlock)(&bed);
if (b.fail) Log(LOG_ALERT, "ALERT ( %s/%s ): recovery for SQLite3 daemon failed.\n", config.name, config.type);
if (config.debug) {
idata->elap_time = time(NULL)-start;
Log(LOG_DEBUG, "( %s/%s ) *** Purging cache - END (QN: %u, ET: %u) ***\n",
config.name, config.type, idata->qn, idata->elap_time);
}
if (config.sql_trigger_exec) {
if (!config.debug) idata->elap_time = time(NULL)-start;
SQL_SetENV_child(idata);
}
}
/* this is called when a new server is introduced,
we just care for the first server when services connect to the hub
so that we create the bots and join them to their channels
*/
void ev_bs_new_server(IRC_Server* nserver, IRC_Server *from)
{
static int already_loaded = 0;
MYSQL_RES *res;
MYSQL_ROW row;
if (already_loaded)
return;
res = sql_query("SELECT nick,username,publichost,realname,bid FROM botserv");
while((row = sql_next_row(res)))
{
MYSQL_RES *res_chan;
MYSQL_ROW row_chan;
IRC_User *user;
u_int32_t bid = atoi(row[4]);
user = irc_CreateLocalUser(row[0], row[1], row[2], row[2], row[3], "+r");
mod_do_event(e_bot_introduce, &bid, NULL);
irc_AddUMsgEvent(user, "\1PING", bs_ctcp_ping); /* CTCP PING reply */
res_chan = sql_query("SELECT c.name FROM chanserv c, botserv_chans bc "
"WHERE bc.bid=%d AND c.scid=bc.scid", bid);
while((row_chan = sql_next_row(res_chan)))
{
IRC_Chan *chan = irc_ChanJoin(user, row_chan[0], 0);
irc_ChanMode(bsu.u, chan, "+ao %s %s", user->nick, user->nick);
}
sql_free(res_chan);
}
sql_free(res);
already_loaded = -1;
}
int ADAK_SQL::LOCK_ROW (const QString id_column_name,const QString table_name, const QString where_info)
{
switch (p_db_driver) {
case SQLITE :
return ADAK_OK;
case PSQL :
{
SQL_QUERY sql_query ( this );
sql_query.PREPARE_SELECT ( QString ("SELECT pg_try_advisory_lock("+id_column_name+") FROM " + table_name + " WHERE " + where_info));
if(sql_query.SELECT() EQ 0 ) {
return ADAK_FAIL;
}
sql_query.NEXT();
if ( sql_query.VALUE(0).toBool() EQ false ) {
return ADAK_FAIL;
}
return ADAK_OK;
}
case MYSQL :
{
SQL_QUERY sql_query ( this );
sql_query.PREPARE_SELECT ( QString ("SELECT GET_LOCK(\""+table_name + "." + where_info+"\",2)"));
if(sql_query.SELECT() EQ 0) {
return ADAK_FAIL;
}
sql_query.NEXT();
if ( sql_query.VALUE(0).toInt() EQ 0 ) {
return ADAK_FAIL;
}
return ADAK_OK;
}
case MSSQL :
{
// donen deger >= 0 sa locklanmistir aksi takdirde lock olmamistir.
SQL_QUERY sql_query ( this );
sql_query.PREPARE_SELECT ( QString("sp_getapplock @Resource = '%1', @LockMode = 'Exclusive',@LockTimeout = 0,@LockOwner = 'Session'").arg(QString ("LOCK(\""+table_name + "." + where_info+"\",2)")) );
if(sql_query.SELECT() EQ 0) {
return ADAK_FAIL;
}
sql_query.NEXT();
QString sql_query_value = sql_query.VALUE(0).toString();
if ( sql_query.VALUE(0).toInt() EQ 0 ) {
return ADAK_FAIL;
}
return ADAK_OK;
}
default :
return ADAK_OK;
break;
}
return true;
}
/*
* Add a login entry to the utmp table.
*
* We log the time (seconds.microseconds), uid, username, ip address,
* hostname and the session id that was assigned to this session.
*/
unsigned long long log_login(void)
{
char *username;
char *ip_addr;
struct timespec login_at;
struct utmp_info *ui;
unsigned long long sid;
unsigned int uid;
MYSQL_RES *res;
MYSQL_ROW row;
pthread_t tid;
pthread_attr_t attr;
clock_gettime(CLOCK_REALTIME, &login_at);
username = make_mysql_safe_string(get_var(qvars, "username"));
ip_addr = make_mysql_safe_string(env_vars.remote_addr);
res = sql_query("SELECT uid FROM passwd WHERE username = '******'",
username);
row = mysql_fetch_row(res);
uid = strtoul(row[0], NULL, 10);
mysql_free_result(res);
/* We need to be sure a new sid isn't inserted here */
sql_query("LOCK TABLES utmp WRITE");
res = sql_query("SELECT IFNULL(MAX(sid), 0) FROM utmp");
row = mysql_fetch_row(res);
sid = strtoull(row[0], NULL, 10) + 1;
/* Divide tv_nsec by 1000 to get a rough microseconds value */
sql_query("INSERT INTO utmp VALUES (%ld.%06ld, %u, '%s', '%s', %d, "
"'', %llu)",
login_at.tv_sec, login_at.tv_nsec / NS_USEC,
uid, username, ip_addr, env_vars.remote_port, sid);
sql_query("UNLOCK TABLES");
mysql_free_result(res);
free(username);
free(ip_addr);
/*
* ui is free'd in the log_utmp_host thread as it will need to
* exist beyond the life of this function.
*/
ui = malloc(sizeof(struct utmp_info));
snprintf(ui->ip, sizeof(ui->ip), "%s", env_vars.remote_addr);
ui->sid = sid;
pthread_attr_init(&attr);
pthread_attr_setdetachstate(&attr, PTHREAD_CREATE_DETACHED);
pthread_create(&tid, &attr, log_utmp_host, (void *)ui);
pthread_attr_destroy(&attr);
return sid;
}
Character *load_player_by_id(Connection *conn, identifier_t charId)
{
char buf[400];
sql_stmt *stmt;
db_begin_transaction();
int len = sprintf(buf,
"select * from character join player on playerId=characterId where characterId=%"
PRId64,
charId);
if (sql_query(buf, len, &stmt) != SQL_OK)
{
log_data("could not prepare sql statement");
return 0;
}
Character *ch = new_char();
ch->pc = new_player(conn);
if (sql_step(stmt) != SQL_DONE)
{
load_player_columns(conn->account, ch, stmt);
}
if (sql_finalize(stmt) != SQL_OK)
{
log_data("unable to finalize statement");
}
load_char_objs(ch);
load_char_affects(ch);
db_end_transaction();
return ch;
}
/*
* Utility routine to do inserts
* Returns: false on failure
* true on success
*/
bool InsertDB(const char *file, int line, JCR *jcr, B_DB *mdb, char *cmd)
{
int num_rows;
if (!sql_query(mdb, cmd)) {
m_msg(file, line, &mdb->errmsg, _("insert %s failed:\n%s\n"), cmd, sql_strerror(mdb));
j_msg(file, line, jcr, M_FATAL, 0, "%s", mdb->errmsg);
if (verbose) {
j_msg(file, line, jcr, M_INFO, 0, "%s\n", cmd);
}
return false;
}
num_rows = sql_affected_rows(mdb);
if (num_rows != 1) {
char ed1[30];
m_msg(file, line, &mdb->errmsg, _("Insertion problem: affected_rows=%s\n"),
edit_uint64(num_rows, ed1));
if (verbose) {
j_msg(file, line, jcr, M_INFO, 0, "%s\n", cmd);
}
return false;
}
mdb->changes++;
return true;
}
void DMR_DEMIRBAS_KARTI::DELETE_RECORD ( int record_id )
{
SQL_QUERY sql_query ( DB );
sql_query.PREPARE_SELECT ( "dmr_demirbaslar","demirbas_kodu , demirbas_adi,fatura_id",
"demirbas_id = :demirbas_id");
sql_query.SET_VALUE ( ":demirbas_id" , record_id );
if ( sql_query.SELECT() EQ 0 ) {
return;
}
sql_query.NEXT();
QString demirbas_kodu = sql_query.VALUE(0).toString();
QString demirbas_adi = sql_query.VALUE(1).toString();
int fatura_id = sql_query.VALUE(2).toInt();
if ( fatura_id > 0 ) {
DMR_ENTEGRASYON_FISI_OLUSTUR(fatura_id , 0);
}
SQL_QUERY delete_query ( DB );
delete_query.PREPARE_DELETE ( "dmr_demirbaslar","demirbas_id = :demirbas_id" );
delete_query.SET_VALUE ( ":demirbas_id" , record_id );
delete_query.DELETE();
GRP_KAYDIN_GRUPLARINI_SIL(E9_PROGRAMI,DEMIRBAS_GRUP_MODULU,record_id);
QString log_detaylari = QObject::tr ( "Demirbaş Kodu / Adı : " );
log_detaylari.append ( demirbas_kodu + " " + demirbas_adi );
E9_LOG_KAYDI_EKLE ( DEMIRBAS_MODULU , LOG_DMR_DEMIRBASLAR , LOG_ISLEM_DELETE , log_detaylari );
}
bool db_list_sql_query(JCR *jcr, B_DB *mdb, const char *query,
OUTPUT_FORMATTER *sendit, e_list_type type,
const char *description, bool verbose)
{
bool retval = false;
db_lock(mdb);
if (!sql_query(mdb, query, QF_STORE_RESULT)) {
Mmsg(mdb->errmsg, _("Query failed: %s\n"), sql_strerror(mdb));
if (verbose) {
sendit->decoration(mdb->errmsg);
}
goto bail_out;
}
sendit->array_start(description);
list_result(jcr, mdb, sendit, type);
sendit->array_end(description);
sql_free_result(mdb);
retval = true;
bail_out:
db_unlock(mdb);
return retval;
}
QVector<CarInfo_tb> DBService::getAllCarInfo_tb()
{
QVector<CarInfo_tb> carInfos;
if(!database.open())
{
qDebug()<<database.lastError();
return QVector<CarInfo_tb>();
}
else
{
QString select_sql("select slm1,slm2,car_name from tb_car_info;");
QSqlQuery sql_query(database);
sql_query.prepare(select_sql);
if(!sql_query.exec())
{
qDebug()<<sql_query.lastError();
}
else
{
while(sql_query.next())
{
CarInfo_tb carInfo;
carInfo.slm1 = sql_query.value(0).toString();
carInfo.slm2 = sql_query.value(1).toString();
carInfo.carName = sql_query.value(2).toString();
carInfo.isValid = true;
carInfos.append(carInfo);
}
}
}
database.close();
return carInfos;
}
bool DBService::insertCarNuMap_tb(const CarNuMap_tb& carNuMap)
{
bool res = false;
if(!database.open())
{
qDebug()<<database.lastError();
return res;
}
else
{
QSqlQuery sql_query(database);
QString update_sql("insert into tb_car_nu_map (car_nu_l,car_nu_g,car_name) values(?,?,?);");
sql_query.prepare(update_sql);
sql_query.addBindValue(QString::number(carNuMap.car_nu_l));
sql_query.addBindValue(QString::number(carNuMap.car_nu_g));
sql_query.addBindValue(carNuMap.carName);
if(!sql_query.exec())
{
qDebug()<<sql_query.lastError();
}
else
{
qDebug()<<"inserted!";
res = true;
}
}
database.close();
return res;
}
void
gen_board_list(struct board_data *board, struct creature *ch)
{
PGresult *res;
char time_buf[30];
int idx, count;
time_t post_time;
res =
sql_query
("select extract(epoch from post_time), name, subject from board_messages where board='%s' order by idnum desc",
tmp_sqlescape(board->name));
count = PQntuples(res);
if (count == 0) {
send_to_char(ch, "This board is empty.\r\n");
return;
}
acc_string_clear();
acc_sprintf
("This is a bulletin board. Usage: READ/REMOVE <messg #>, WRITE <header>\r\n%sThere %s %d message%s on the board.%s\r\n",
CCGRN(ch, C_NRM), (count == 1) ? "is" : "are", count,
(count == 1) ? "" : "s", CCNRM(ch, C_NRM));
for (idx = 0; idx < count; idx++) {
post_time = atol(PQgetvalue(res, idx, 0));
strftime(time_buf, 30, "%b %e, %Y", localtime(&post_time));
acc_sprintf("%s%-2d %s:%s %s %-12s :: %s\r\n",
CCGRN(ch, C_NRM), count - idx, CCRED(ch, C_NRM), CCNRM(ch, C_NRM),
time_buf, tmp_sprintf("(%s)", PQgetvalue(res, idx, 1)),
PQgetvalue(res, idx, 2));
}
page_string(ch->desc, acc_get_string());
}
void PRS_PERSONEL_AILE_FISI::DELETE_LINE(int record_id, int row_number)
{
Q_UNUSED(record_id);
int aile_bilgi_id = table_widget_aile_satirlari->item(row_number,ROW_ID_COLUMN)->text().toInt();
SQL_QUERY sql_query (DB);
sql_query.PREPARE_SELECT(" prs_personel_aile_uyeleri","adi_soyadi",
"aile_bilgi_id = :aile_bilgi_id");
sql_query.SET_VALUE(":aile_bilgi_id" , aile_bilgi_id);
if (sql_query.SELECT() EQ 0 ) {
return;
}
sql_query.NEXT();
QString adi_soyadi = sql_query.VALUE(0).toString();
sql_query.PREPARE_DELETE("prs_personel_aile_uyeleri", "aile_bilgi_id = :aile_bilgi_id");
sql_query.SET_VALUE(":aile_bilgi_id", aile_bilgi_id );
sql_query.DELETE();
QString personel_adi_soyadi = line_edit_personel_adi->text();
QString personel_sicil_no = line_edit_personel_sicil_no->text();
QString log_detaylari = "Aile Bireyi Ekleme";
log_detaylari.append("\nPersonel Adı / Soyadı : " + personel_adi_soyadi +
"Sicil No : " + personel_sicil_no);
log_detaylari.append("\nAile Bireyi : " + adi_soyadi);
K9_LOG_KAYDI_EKLE ( PERSONEL_MODULU , LOG_PRS_PERSONEL , LOG_ISLEM_DELETE , log_detaylari);
}
bool DBService::exec(const QString& sql,bool vaccum)
{
// qDebug()<<"exec sql : "<<sql;
bool res = false;
if(!open())
{
qDebug()<<database.lastError();
return res;
}
else
{
QSqlQuery sql_query(database);
sql_query.exec("PRAGMA foreign_keys = ON");
if(!sql_query.exec(sql))
{
qDebug()<<sql_query.lastError();
}
else
{
qDebug()<<"inserted!";
if(vaccum)
vacuum();
// sql_query.exec("VACUUM");
res = true;
}
}
close();
return res;
}
static void sql_lookup_pass(struct passdb_sql_request *sql_request)
{
struct passdb_module *_module =
sql_request->auth_request->passdb->passdb;
struct sql_passdb_module *module = (struct sql_passdb_module *)_module;
const char *query, *error;
if (t_auth_request_var_expand(module->conn->set.password_query,
sql_request->auth_request,
passdb_sql_escape, &query, &error) <= 0) {
auth_request_log_debug(sql_request->auth_request, AUTH_SUBSYS_DB,
"Failed to expand password_query=%s: %s",
module->conn->set.password_query, error);
sql_request->callback.verify_plain(PASSDB_RESULT_INTERNAL_FAILURE,
sql_request->auth_request);
return;
}
auth_request_log_debug(sql_request->auth_request, AUTH_SUBSYS_DB,
"query: %s", query);
auth_request_ref(sql_request->auth_request);
sql_query(module->conn->db, query,
sql_query_callback, sql_request);
}
/*************************************************************************
*
* Function: sql_select_query
*
* Purpose: Issue a select query to the database
*
*************************************************************************/
static int sql_select_query(rlm_sql_handle_t *handle, rlm_sql_config_t *config, char *querystr) {
rlm_sql_unixodbc_conn_t *conn = handle->conn;
SQLINTEGER column;
SQLLEN len;
int numfields;
int state;
/* Only state = 0 means success */
if ((state = sql_query(handle, config, querystr))) {
return state;
}
numfields=sql_num_fields(handle, config);
if (numfields < 0) {
return -1;
}
/* Reserving memory for result */
conn->row = (char **) rad_malloc((numfields+1)*sizeof(char *));
conn->row[numfields] = NULL;
for(column = 1; column <= numfields; column++) {
SQLColAttributes(conn->statement,((SQLUSMALLINT) column),SQL_COLUMN_LENGTH,NULL,0,NULL,&len);
conn->row[column-1] = (char*)rad_malloc((int)++len);
SQLBindCol(conn->statement, column, SQL_C_CHAR, (SQLCHAR *)conn->row[column-1], len, NULL);
}
return 0;
}
bool DBService::insertCarInfo_tb(const CarInfo_tb& carInfo)
{
bool res = false;
if(!database.open())
{
qDebug()<<database.lastError();
return res;
}
else
{
QSqlQuery sql_query(database);
QString update_sql("insert into tb_car_info (slm1,slm2,car_name) values(?,?,?);");
sql_query.prepare(update_sql);
sql_query.addBindValue(carInfo.slm1);
sql_query.addBindValue(carInfo.slm2);
sql_query.addBindValue(carInfo.carName);
if(!sql_query.exec())
{
qDebug()<<sql_query.lastError();
}
else
{
qDebug()<<"inserted!";
res = true;
}
}
database.close();
return res;
}
CarInfo_tb DBService::getCarInfo_tb(const QString& carName)
{
CarInfo_tb carInfo;
if(!database.open())
{
qDebug()<<database.lastError();
carInfo.isValid = false;
return carInfo;
}
else
{
QString select_sql("select slm1,slm2 from tb_car_info where car_name=?");
QSqlQuery sql_query(database);
sql_query.prepare(select_sql);
sql_query.addBindValue(carName);
if(!sql_query.exec())
{
qDebug()<<sql_query.lastError();
}
else
{
while(sql_query.next())
{
carInfo.carName = carName;
carInfo.slm1 = sql_query.value(0).toString();
carInfo.slm2 = sql_query.value(1).toString();
carInfo.isValid = true;
break;
}
}
}
database.close();
return carInfo;
}
void DVZ_DOVIZLER_BATCH::RUN_BATCH ()
{
SQL_QUERY sql_query ( DB );
sql_query.PREPARE_SELECT ( "dvz_dovizler", "doviz_kodu" );
if ( sql_query.SELECT("doviz_adi ASC") EQ 0 ) {
return;
}
while ( sql_query.NEXT() ) {
for ( int i = 0 ; i < comma_edit_alis_degerleri.size() ; i++ ) {
if ( sql_query.VALUE(0).toString() EQ doviz_kodlari.at(i) ) {
double yeni_alis_degeri = comma_edit_alis_degerleri.at(i)->GET_DOUBLE();
double yeni_satis_degeri = comma_edit_satis_degerleri.at(i)->GET_DOUBLE();
if (yeni_alis_degeri EQ 0.00) {
yeni_alis_degeri = -1;
}
if (yeni_satis_degeri EQ 0.00) {
yeni_satis_degeri = -1;
}
DVZ_UPDATE_DOVIZ_KURLAR(sql_query.VALUE(0).toString(),m_ui->adakDate_kur_tarihi->QDATE(),yeni_alis_degeri,yeni_satis_degeri);
break;
}
}
}
MSG_WARNING( tr ( "Dövizler Kurları Güncellendi." ), NULL );
}
bool DBService::updateCarNuMap_tb(const CarNuMap_tb& carNuMap)
{
bool res = false;
if(!database.open())
{
qDebug()<<database.lastError();
return res;
}
else
{
QSqlQuery sql_query(database);
QString update_sql("update tb_car_nu_map set car_nu_l=?,car_nu_g=? where car_name=?");
sql_query.prepare(update_sql);
sql_query.addBindValue(carNuMap.car_nu_l);
sql_query.addBindValue(carNuMap.car_nu_g);
sql_query.addBindValue(carNuMap.carName);
if(!sql_query.exec())
{
qDebug()<<sql_query.lastError();
}
else
{
qDebug()<<"updated!";
res = true;
}
}
database.close();
return res;
}
struct account *
account_by_name(char *name)
{
PGresult *res;
int acct_id;
// First check to see if we already have it in memory
struct account *acct = g_hash_table_find(account_cache,
account_name_matches,
name);
if (acct)
return acct;
// Apprently, we don't, so look it up on the db
res = sql_query("select idnum from accounts where lower(name)='%s'",
tmp_sqlescape(tmp_tolower(name)));
if (PQntuples(res) != 1)
return NULL;
acct_id = atoi(PQgetvalue(res, 0, 0));
// Now try to load it
CREATE(acct, struct account, 1);
if (load_account(acct, acct_id))
return acct;
free(acct);
return NULL;
}
bool DBService::updateCarInfo_tb(const CarInfo_tb& carInfo)
{
bool res = false;
if(!database.open())
{
qDebug()<<database.lastError();
return res;
}
else
{
QSqlQuery sql_query(database);
QString update_sql("update tb_car_info set slm1=?,slm2=? where car_name=?");
sql_query.prepare(update_sql);
sql_query.addBindValue(carInfo.slm1);
sql_query.addBindValue(carInfo.slm2);
sql_query.addBindValue(carInfo.carName);
if(!sql_query.exec())
{
qDebug()<<sql_query.lastError();
}
else
{
qDebug()<<"updated!";
res = true;
}
}
database.close();
return res;
}
bool ISL_DEFTERI_RAPORU::DEVREDEN_TOPLAM_HESAPLA()
{
SQL_QUERY sql_query ( DB );
sql_query.PREPARE_SELECT ( "isl_fis_satirlari, isl_fisi","satir_kdv_haric_tutar, satir_kdv_tutari, satir_kdv_dahil_tutar, fis_turu ",
"isl_fis_satirlari.fis_id = isl_fisi.fis_id "
"AND fis_tarihi < :baslangic_tarihi" );
sql_query.SET_VALUE ( ":baslangic_tarihi", M_ISL_RV->baslangic_tarihi.toString ( "yyyy.MM.dd" ) );
if ( sql_query.SELECT() EQ 0 ) {
return false;
}
while ( sql_query.NEXT() EQ true ) {
switch ( sql_query.VALUE(3).toInt() ) {
case ENUM_GELIR_FISI :
default :
m_gelir_kdv_haric_toplam += sql_query.VALUE(0).toDouble();
m_gelir_kdv_tutar_toplam += sql_query.VALUE(1).toDouble();
m_gelir_toplam += sql_query.VALUE(2).toDouble();
break;
case ENUM_GIDER_FISI :
m_gider_kdv_haric_toplam += sql_query.VALUE(0).toDouble();
m_gider_kdv_tutar_toplam += sql_query.VALUE(1).toDouble();
m_gider_toplam += sql_query.VALUE(2).toDouble();
break;
}
}
return true;
}
void FAT_IRSALIYE_ARAMA::SETUP_FORM ()
{
SET_PAGE_TITLE( tr ( "FAT - İRSALİYE SEÇİMİ" ) );
REGISTER_TABLE_WIDGET ( m_ui->tableWidget );
REGISTER_ARAMA_BUTTONS_WIDGET ( m_ui->widget_batch_buttons );
SET_HEADERS( QStringList() << tr("irsaliye_id") <<tr("İrs. Seri No") << tr("İrsaliye No") << tr("İrs. Tarihi") );
SET_SORTING ( false );
m_ui->tableWidget->hideColumn(0);
m_ui->tableWidget->setColumnWidth ( 1, 20 );
m_ui->tableWidget->setColumnWidth ( 2, 10 );
m_ui->tableWidget->setColumnWidth ( 3, 200 );
// Programa ilk girildiginde focuslanacak widget setlenmelidir.
SET_FIRST_FOCUS_WIDGET ( m_ui->adakDate_bas_tarihi );
SET_HELP_PAGE ("fat_irsaliye_secimi.html");
m_ui->tableWidget->setColumnWidth( 3 , 10);
SET_SETTING_NAME ( "FAT_IRSALIYE_SECIMI" );
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
SET_FIND_BUTTON_NAME ( "İrsaliye Bul" );
SQL_QUERY sql_query ( DB );
sql_query.PREPARE_SELECT ( "k9_sabit_degerler","irs_faturalandirilacak_gun" ,"sabit_deger_id = :sabit_deger_id");
sql_query.SET_VALUE(":sabit_deger_id" , 1);
if ( sql_query.SELECT() EQ 0 ) {
return;
}
sql_query.NEXT();
int faturandirilacak_gun = sql_query.VALUE(0).toInt();
QDate irsaliye_tarihi_bitis = QDate::fromString ( m_irsaliye_tarihi_bitis, "yyyy.MM.dd" );
int irsaliye_tarihi_bitis_month = irsaliye_tarihi_bitis.month();
QDate irsaliye_tarihi_baslangic = irsaliye_tarihi_bitis.addDays ( -1 * faturandirilacak_gun );
int irsaliye_tarihi_baslangic_month = irsaliye_tarihi_baslangic.month();
if ( irsaliye_tarihi_baslangic_month NE irsaliye_tarihi_bitis_month ) {
m_irsaliye_tarihi_baslangic = QDate( irsaliye_tarihi_bitis.year(), irsaliye_tarihi_bitis_month, 01 ).toString("yyyy.MM.dd");
}
else {
m_irsaliye_tarihi_baslangic = irsaliye_tarihi_baslangic.toString("yyyy.MM.dd");
}
m_ui->adakDate_bas_tarihi->SET_DATE( m_irsaliye_tarihi_baslangic );
m_ui->adakDate_bts_tarihi->SET_DATE( m_irsaliye_tarihi_bitis );
AUTO_START();
}
bool TABLOLARI_YAZ (QWidget * parent )
{
SQL_QUERY sql_query (DB);
sql_query.PREPARE_SELECT("sql_tablolar","tablo_id ,tablo_adi");
int tablo_sayisi = sql_query.SELECT("tablo_adi");
if ( tablo_sayisi EQ 0 ) {
ADAK_ERROR(QObject::tr ("Table is not found."),NULL,parent);
return false;
}
int virgul_sayisi = tablo_sayisi;
file_content += tab( 1, nl ( toString(tablo_sayisi) + ","));
file_content += tab(1, nl("{"));
while ( sql_query.NEXT() EQ true ) {
file_content += tab(2, nl("{"));
file_content += tab(3, nl("\"" + sql_query.VALUE(1).toString() + "\","));
ALANLARI_YAZ( sql_query.VALUE(0).toInt());
file_content += tab(2, "}");
virgul_sayisi--;
if ( virgul_sayisi > 0 ) {
file_content += ",";
}
file_content += "\n";
}
file_content += tab(1, nl("}"));
return true;
}
int MSSQL_PLUGIN::LOCK_ROW (const QString ,const QString table_name, const QString where_info)
{
//FIXME
return ADAK_OK;
// donen deger >= 0 sa locklanmistir aksi takdirde lock olmamistir.
SQL_DDL sql_query ( this );
bool answer = sql_query.EXEC_SQL( QString("sp_getapplock @Resource = '%1', @LockMode = 'Exclusive',@LockTimeout = 2,@LockOwner = 'Session'").arg(QString ("LOCK("+table_name + "." + where_info+",2)")) );
if(answer EQ false ) {
return ADAK_FAIL;
}
if ( sql_query.NUM_OF_ROWS() <= 0 ) {
return ADAK_FAIL;
}
sql_query.NEXT();
if ( sql_query.VALUE(0).toInt() EQ 0 ) {
return ADAK_FAIL;
}
return ADAK_OK;
}
void GRUP_KERNEL::ADD_PARENT_ITEMS()
{
SQL_QUERY sql_query ( m_db );
QString table_name = "";
QString column_name = "";
QString where_name = "";
QString order_by = "";
CREATE_SELECT_QUERY(&table_name,&column_name,&where_name,&order_by);
sql_query.PREPARE_SELECT ( table_name,column_name,where_name,"" );
if ( sql_query.SELECT(order_by) NE 0 ) {
while ( sql_query.NEXT() EQ true ) {
//QString id = sql_query.VALUE(0).toString();
QStringList tree_row_str;
tree_row_str << sql_query.VALUE(3).toString() << sql_query.VALUE(4).toString() <<
sql_query.VALUE(8).toString() << sql_query.VALUE(7).toString() <<
sql_query.VALUE(0).toString() << sql_query.VALUE(1).toString() <<
sql_query.VALUE(6).toString() << sql_query.VALUE(5).toString();
ADD_PARENT_ITEM ( tree_row_str , sql_query.VALUE(8).toInt() );
}
}
}
/*
* Utility routine for updates.
* Returns: false on failure
* true on success
*/
bool UpdateDB(const char *file, int line, JCR *jcr, B_DB *mdb, char *cmd, int nr_afr)
{
int num_rows;
if (!sql_query(mdb, cmd)) {
m_msg(file, line, &mdb->errmsg, _("update %s failed:\n%s\n"), cmd, sql_strerror(mdb));
j_msg(file, line, jcr, M_ERROR, 0, "%s", mdb->errmsg);
if (verbose) {
j_msg(file, line, jcr, M_INFO, 0, "%s\n", cmd);
}
return false;
}
if (nr_afr > 0) {
num_rows = sql_affected_rows(mdb);
if (num_rows < nr_afr) {
char ed1[30];
m_msg(file, line, &mdb->errmsg, _("Update failed: affected_rows=%s for %s\n"),
edit_uint64(num_rows, ed1), cmd);
if (verbose) {
// j_msg(file, line, jcr, M_INFO, 0, "%s\n", cmd);
}
return false;
}
}
mdb->changes++;
return true;
}
void GRUP_KERNEL::ADD_CHILD_ITEMS (QStringList item)
{
int item_id;
item_id = item.at( m_grp_id_column ).toInt();
SQL_QUERY sql_query ( m_db );
QString table_name = "";
QString column_name = "";
QString where_name = "";
QString order_by = "";
CREATE_SELECT_QUERY(&table_name,&column_name,&where_name,&order_by,item_id);
sql_query.PREPARE_SELECT ( table_name,column_name,where_name,"" );
if ( sql_query.SELECT(order_by) NE 0 ) {
while ( sql_query.NEXT() EQ true ) {
QStringList tree_row_str;
tree_row_str << sql_query.VALUE(3).toString() << sql_query.VALUE(4).toString() <<
sql_query.VALUE(8).toString() << sql_query.VALUE(7).toString() <<
sql_query.VALUE(0).toString() << sql_query.VALUE(1).toString() <<
sql_query.VALUE(6).toString() << sql_query.VALUE(5).toString();
ADD_CHILD_ITEM( tree_row_str , sql_query.VALUE(8).toInt() );
}
}
}
Character *load_player_by_name(Connection *conn, const char *name)
{
char buf[400];
sql_stmt *stmt;
db_begin_transaction();
int len = sprintf(buf,
"select * from character natural join player where name='%s'",
escape_sql_str(name));
if (sql_query(buf, len, &stmt) != SQL_OK)
{
log_data("could not prepare sql statement");
return 0;
}
Character *ch = new_char();
ch->pc = new_player(conn);
if (sql_step(stmt) != SQL_DONE)
{
load_player_columns(conn->account, ch, stmt);
}
if (sql_finalize(stmt) != SQL_OK)
{
log_data("unable to finalize statement");
}
load_char_objs(ch);
load_char_affects(ch);
db_end_transaction();
return ch;
}
static sql_rcode_t sql_select_query(rlm_sql_handle_t *handle, rlm_sql_config_t *config, char const *query)
{
rlm_sql_unixodbc_conn_t *conn = handle->conn;
SQLINTEGER i;
SQLLEN len;
int colcount;
int state;
/* Only state = 0 means success */
if ((state = sql_query(handle, config, query))) {
return state;
}
colcount = sql_num_fields(handle, config);
if (colcount < 0) {
return RLM_SQL_ERROR;
}
/* Reserving memory for result */
conn->row = talloc_zero_array(conn, char *, colcount + 1); /* Space for pointers */
for (i = 1; i <= colcount; i++) {
SQLColAttributes(conn->stmt, ((SQLUSMALLINT) i), SQL_COLUMN_LENGTH, NULL, 0, NULL, &len);
conn->row[i - 1] = talloc_array(conn->row, char, ++len);
SQLBindCol(conn->stmt, i, SQL_C_CHAR, (SQLCHAR *)conn->row[i - 1], len, NULL);
}
return RLM_SQL_OK;
}
