예제 #1
0
void PlayerListArea::updateList()
{
    while(mainWidgetGLayout->count() > 0)
    {
        QWidget* widget = mainWidgetGLayout->itemAt(0)->widget();
        mainWidgetGLayout->removeWidget(widget);
        delete widget;
    }
    QSqlQuery query_select("select * from playlistTB ORDER BY tvId DESC");
    query_select.exec();
    while(query_select.next())
    {

        //tvId VARCHAR( 30 ) NOT NULL,tvName VARCHAR( 30 ),tvno_hrefs VARCHAR( 30 ),historyNo VARCHAR( 30 )
        QString tvId =query_select.value("tvId").toString();//
        QString tvName =query_select.value("tvName").toString();
        QString tvno_hrefs =query_select.value("tvno_hrefs").toString();
        QString historyNo =query_select.value("historyNo").toString();
        QString source =query_select.value("source").toString();
        if(source.contains("qiyi"))
        {
            source = "爱奇艺";
        }else if(source.contains("leshi"))
        {
            source = "乐视";
        }else if(source.contains("tudou"))//
        {
            source = "土豆";
        }else if(source.contains("youku"))
        {
            source = "优酷";
        }else if(source.contains("imgotv"))
        {
            source = "芒果";
        }else if(source.contains("fengxing"))
        {
            source = "风行";
        }else if(source.contains("qqvideo"))
        {
            source = "qq影视";
        }else if(source.contains("huashu"))
        {
            source = "华数TV";
        }

        listWidgetItem = new PlayerListWidgetItem(0,tvId,tvName+"("+source+")");
        connect(listWidgetItem,SIGNAL(sendPlay(QString,QString)),this,SLOT(sendPlay(QString,QString)));
        connect(listWidgetItem,SIGNAL(updatePlayList()),this,SLOT(updateList()));
        mainWidgetGLayout->addWidget(listWidgetItem);
        QStringList tvno_hrefList =  tvno_hrefs.split("$");
        tvno_hrefList.removeAll("");
        foreach (QString tvno_href , tvno_hrefList) {
            QStringList tempList = tvno_href.split("#");
            listWidgetItem->addSerial(tempList.first(),historyNo);
        }
        listWidgetItem->setMaximumHeight((listWidgetItem->getRow()+1)*50);

    }
예제 #2
0
파일: friend.c 프로젝트: erichuang1994/fbbs
/**
 * 获取关注和拉黑某人的用户列表
 * @param[in] uid 要查询的用户ID
 * @param[out] followers 关注该用户的用户列表
 * @param[out] blacklisters 拉黑该用户的用户列表
 */
void friend_load_followers_and_blacklisters(user_id_t uid,
		friend_uid_list_t **followers, friend_uid_list_t **blacklisters)
{
	if (!followers || !blacklisters)
		return;

	query_t *q = query_new(0);
	query_select(q, "follower");
	query_from(q, "follows");
	query_where(q, "user_id = %"DBIdUID, uid);
	*followers = query_exec(q);

	q = query_new(0);
	query_select(q, "user_id");
	query_from(q, "blacklists");
	query_where(q, "blocked = %"DBIdUID, uid);
	*blacklisters = query_exec(q);
}
예제 #3
0
파일: board.c 프로젝트: caidongyun/fbbs
/*
{
	groups: [
		{
			name: OPTIONAL TEXT,
			descr: OPTIONAL TEXT,
			boards: [
				{ id: INTEGER, name: TEXT, unread: OPTIONAL BOOLEAN },
				...
			]
		},
		...
	]
}
*/
int api_board_fav(void)
{
	if (!session_id())
		return WEB_ERROR_LOGIN_REQUIRED;

	xml_node_t *root = set_response_root("bbs-board-fav",
			XML_NODE_ANONYMOUS_JSON, XML_ENCODING_UTF8);
	xml_node_t *groups = xml_new_node("groups", XML_NODE_CHILD_ARRAY);
	xml_add_child(root, groups);

	query_t *q = query_new(0);
	query_select(q, "board, name, folder");
	query_from(q, "fav_boards");
	query_where(q, "user_id = %"DBIdUID, session_uid());
	db_res_t *boards = query_exec(q);

	q = query_new(0);
	query_select(q, "id, name, descr");
	query_from(q, "fav_board_folders");
	query_where(q, "user_id = %"DBIdUID, session_uid());
	db_res_t *folders = query_exec(q);

	if (folders && boards) {
		attach_group(groups, boards, FAV_BOARD_ROOT_FOLDER);
		for (int i = db_res_rows(folders) - 1; i >= 0; --i) {
			int id = db_get_integer(folders, i, 0);
			xml_node_t *group = attach_group(groups, boards, id);
			xml_attr_string(group, "name", db_get_value(folders, i, 1), true);
			xml_attr_string(group, "descr", db_get_value(folders, i, 2), true);
		}
	}

	db_clear(folders);
	db_clear(boards);
	return WEB_OK;
}
예제 #4
0
void PRS_KARTI_IMPORT::IMPORT_ROW( QStringList kayit_bilgisi_list )
{
    if ( kayit_bilgisi_list.size() <= 0 ) {
        return;
    }

    SQL_QUERY query_select( DB );

    query_select.PREPARE_SELECT( "prs_personeller" , "personel_id" , "sicil_no=:sicil_no");
    query_select.SET_VALUE( ":sicil_no"  , kayit_bilgisi_list.at( 1 ) );

    if( query_select.SELECT() NE 0 ){
        return ;
    }

    double cari_borc   = kayit_bilgisi_list.at(7).toDouble();
    double cari_alacak = kayit_bilgisi_list.at(8).toDouble();

    int sube_id = SUBE_GET_SUBE_ID();
    int personel_borclari_ent_hesap_id = SUBE_GET_SUBE_ENT_HESAP_ID(sube_id, "personel_borclari_ent_hesap_id");
    int prs_avanslari_ent_hesap_id     = SUBE_GET_SUBE_ENT_HESAP_ID(sube_id, "prs_avanslari_ent_hesap_id");

    CARI_HESAP_STRUCT         PRS_HESAP_KARTI  ;
    CARI_FIS_SATIRI_STRUCT    PRS_FIS_SATIRI ;

    //! [1] CARI HESAP EKLENIYOR
    CARI_SET_HESAP_STRUCT_DEFAULTS( &PRS_HESAP_KARTI );

    PRS_HESAP_KARTI.kimlik_no       =  kayit_bilgisi_list.at( 0 );
    PRS_HESAP_KARTI.cari_hesap_kodu =  kayit_bilgisi_list.at( 1 );
    PRS_HESAP_KARTI.cari_hesap_ismi =  kayit_bilgisi_list.at( 3 ).mid(0, 60);
    PRS_HESAP_KARTI.para_birimi_id  =  DVZ_GET_DOVIZ_ID( kayit_bilgisi_list.at(9) ) ;
    PRS_HESAP_KARTI.cinsiyet        =  kayit_bilgisi_list.at( 10 );
    PRS_HESAP_KARTI.medeni_hali     =  kayit_bilgisi_list.at( 11 );
    PRS_HESAP_KARTI.sehir           =  kayit_bilgisi_list.at( 12 );
    PRS_HESAP_KARTI.ilce            =  kayit_bilgisi_list.at( 13 );
    PRS_HESAP_KARTI.semt            =  kayit_bilgisi_list.at( 14 );
    PRS_HESAP_KARTI.program_id      =  E9_PROGRAMI ;
    PRS_HESAP_KARTI.modul_id        =  PERSONEL_MODULU ;
    PRS_HESAP_KARTI.cari_kart_turu  =  SAHIS_KAYDI;
    PRS_HESAP_KARTI.cari_kart_tipi  =  ENUM_CARI_PERSONEL;
    PRS_HESAP_KARTI.muh_hesap_id    =  personel_borclari_ent_hesap_id;


    int cari_hesap_id = CARI_KART_OLUSTUR( SAHIS_KAYDI, &PRS_HESAP_KARTI ) ;
    //! [1] END CARI HESAP

    //! [2] PERSONEL KAYDI EKLENIYOR

    SQL_QUERY query( DB );
    query.PREPARE_INSERT("prs_personeller","personel_id",
                         "sube_id, cari_hesap_id,"
                         "sicil_no,"
                         "sigorta_no,"
                         "ucret_sekli, brut_ucret, "
                         "calisma_sekli, kumulatif_vergi_matrahi, "
                         "bir_ay_once_kalan_ek_odenek, iki_ay_once_kalan_ek_odenek, "
                         "prs_avanslar_hesap_id, prs_borclar_hesap_id, isten_ayrildi_mi");

    query.SET_VALUE( ":cari_hesap_id",               cari_hesap_id );
    query.SET_VALUE( ":sicil_no",                    kayit_bilgisi_list.at( 1 ) );
    query.SET_VALUE( ":sigorta_no",                  kayit_bilgisi_list.at( 2 ) );
    query.SET_VALUE( ":ucret_sekli",                 PRS_BRUT );
    query.SET_VALUE( ":calisma_sekli",               ENUM_AYLIK   );
    query.SET_VALUE( ":brut_ucret",                  kayit_bilgisi_list.at( 5 ).toDouble() );
    query.SET_VALUE( ":kumulatif_vergi_matrahi",     kayit_bilgisi_list.at( 6 ).toDouble() );
    query.SET_VALUE( ":bir_ay_once_kalan_ek_odenek", 0.00 );
    query.SET_VALUE( ":iki_ay_once_kalan_ek_odenek", 0.00 );
    query.SET_VALUE( ":prs_borclar_hesap_id",        personel_borclari_ent_hesap_id);
    query.SET_VALUE( ":prs_avanslar_hesap_id",       prs_avanslari_ent_hesap_id);
    query.SET_VALUE( ":isten_ayrildi_mi",            0 );
    query.SET_VALUE( ":sube_id",                     sube_id );

    int personel_id = query.INSERT();

    query.PREPARE_INSERT("prs_personel_kisisel_blgler", "kisisel_bilgi_id", "personel_id, ise_giris_tarihi");
    query.SET_VALUE     (":personel_id", personel_id );
    query.SET_VALUE     (":ise_giris_tarihi", kayit_bilgisi_list.at( 4 ) );
    query.INSERT();

    query.PREPARE_INSERT("prs_personel_nufus_blgler ","nufus_id", "personel_id");
    query.SET_VALUE( ":personel_id" , personel_id );
    query.INSERT();

    query.PREPARE_INSERT("prs_personel_notlari ","notlar_id", "personel_id ");
    query.SET_VALUE( ":personel_id" , personel_id );
    query.INSERT();

   //! [2]



   //! NOT : CARI ALISI FISINI SADECE CARI MODULU OLUSTURA BILIR
   //! BUNDAN DLLAYI MODUL ID OLARAK CARI GITMESI LAZIM......

    if ( cari_borc NE 0.00 OR cari_alacak NE 0.00 ) {

        if( m_fis_id EQ -1 ){

            PRS_FIS =  new CARI_FIS_STRUCT ;

            CARI_CLEAR_FIS_STRUCT( PRS_FIS );

            PRS_FIS->cari_hesap_id        =  0;
            PRS_FIS->program_id           =  E9_PROGRAMI ;
            PRS_FIS->modul_id             =  CARI_MODULU ;
            PRS_FIS->fis_turu             =  ENUM_CARI_ACILIS_FISI ;
            PRS_FIS->fis_no               =  CARI_SIRADAKI_FIS_NO_AL( MALI_YIL_FIRST_DATE().toString("yyyy.MM.dd") ) ;
            PRS_FIS->cari_para_birimi_id  =  PRS_HESAP_KARTI.para_birimi_id ;
            PRS_FIS->fis_tarihi           =  MALI_YIL_FIRST_DATE().toString("yyyy.MM.dd");
            PRS_FIS->aciklama             =  tr("PERSONEL KARTI - İmport İşlemi Esnasında Üretilmiştir.");
            PRS_FIS->base_fis_id          =  0;

            m_fis_id = CARI_FIS_EKLE( PRS_FIS ) ;
        }

        CARI_CLEAR_FIS_SATIRI_STRUCT( &PRS_FIS_SATIRI );

        PRS_FIS_SATIRI.cari_hesap_id         =  cari_hesap_id ;
        PRS_FIS_SATIRI.fis_id                =  m_fis_id ;
        PRS_FIS_SATIRI.program_id            =  E9_PROGRAMI ;
        PRS_FIS_SATIRI.modul_id              =  CARI_MODULU ;
        PRS_FIS_SATIRI.doviz_id              =  PRS_HESAP_KARTI.para_birimi_id;

        //! IMPORT ISLEMINDE SADECE BIRI ALINIR
        if ( cari_borc >= cari_alacak ) {
            cari_borc -= cari_alacak;
            cari_alacak = 0.00;
        }
        else {
            cari_alacak -= cari_borc;
            cari_borc    = 0.00;
        }

        if( cari_borc > 0 ){
            PRS_FIS_SATIRI.cari_para_birimi_tutari = cari_borc;
            PRS_FIS_SATIRI.alacak_tutari           = 0;
            PRS_FIS_SATIRI.borc_tutari             = cari_borc;

            CARI_FIS_SATIRI_EKLE( PRS_FIS , &PRS_FIS_SATIRI );
        }
        if ( cari_alacak > 0 )  {
            PRS_FIS_SATIRI.borc_tutari              = 0 ;
            PRS_FIS_SATIRI.alacak_tutari            = cari_alacak;
            PRS_FIS_SATIRI.cari_para_birimi_tutari  = cari_alacak;

            CARI_FIS_SATIRI_EKLE( PRS_FIS , &PRS_FIS_SATIRI );
        }
    }

    if ( GET_GRUP_IDLERI()->size() > 0 ) {

        GRP_KAYDI_GRUPLARA_EKLE( E9_PROGRAMI, PERSONEL_MODULU, personel_id , GET_GRUP_IDLERI() );
    }
}
예제 #5
0
파일: event.c 프로젝트: dotike/pkg
int
event_callback(void *data, struct pkg_event *ev)
{
	struct pkg *pkg = NULL, *pkg_new, *pkg_old;
	int *debug = data;
	struct pkg_event_conflict *cur_conflict;
	const char *filename;

	if (msg_buf == NULL) {
		msg_buf = sbuf_new_auto();
	}

	/*
	 * If a progressbar has been interrupted by another event, then
	 * we need to add a newline to prevent bad formatting.
	 */
	if (progress_started && ev->type != PKG_EVENT_PROGRESS_TICK &&
	    !progress_interrupted) {
		putchar('\n');
		progress_interrupted = true;
	}

	switch(ev->type) {
	case PKG_EVENT_ERRNO:
		warnx("%s(%s): %s", ev->e_errno.func, ev->e_errno.arg,
		    strerror(ev->e_errno.no));
		break;
	case PKG_EVENT_ERROR:
		warnx("%s", ev->e_pkg_error.msg);
		break;
	case PKG_EVENT_NOTICE:
		if (!quiet)
			printf("%s\n", ev->e_pkg_notice.msg);
		break;
	case PKG_EVENT_DEVELOPER_MODE:
		warnx("DEVELOPER_MODE: %s", ev->e_pkg_error.msg);
		break;
	case PKG_EVENT_UPDATE_ADD:
		if (quiet || !isatty(STDOUT_FILENO))
			break;
		printf("\rPushing new entries %d/%d", ev->e_upd_add.done, ev->e_upd_add.total);
		if (ev->e_upd_add.total == ev->e_upd_add.done)
			printf("\n");
		break;
	case PKG_EVENT_UPDATE_REMOVE:
		if (quiet || !isatty(STDOUT_FILENO))
			break;
		printf("\rRemoving entries %d/%d", ev->e_upd_remove.done, ev->e_upd_remove.total);
		if (ev->e_upd_remove.total == ev->e_upd_remove.done)
			printf("\n");
		break;
	case PKG_EVENT_FETCH_BEGIN:
		if (quiet)
			break;
		filename = strrchr(ev->e_fetching.url, '/');
		if (filename != NULL) {
			filename++;
		} else {
			/*
			 * We failed at being smart, so display
			 * the entire url.
			 */
			filename = ev->e_fetching.url;
		}
		job_status_begin(msg_buf);
		progress_debit = true;
		sbuf_printf(msg_buf, "Fetching %s", filename);

		break;
	case PKG_EVENT_FETCH_FINISHED:
		progress_debit = false;
		break;
	case PKG_EVENT_INSTALL_BEGIN:
		if (quiet)
			break;
		else {
			nbdone++;
			job_status_begin(msg_buf);

			pkg = ev->e_install_begin.pkg;
			pkg_sbuf_printf(msg_buf, "Installing %n-%v...\n", pkg,
			    pkg);
			sbuf_finish(msg_buf);
			printf("%s", sbuf_data(msg_buf));
		}
		break;
	case PKG_EVENT_INSTALL_FINISHED:
		if (quiet)
			break;
		pkg = ev->e_install_finished.pkg;
		if (pkg_has_message(pkg)) {
			if (messages == NULL)
				messages = sbuf_new_auto();
			pkg_sbuf_printf(messages, "Message for %n-%v:\n%M\n",
			    pkg, pkg, pkg);
		}
		break;
	case PKG_EVENT_EXTRACT_BEGIN:
		if (quiet)
			break;
		else {
			job_status_begin(msg_buf);
			pkg = ev->e_install_begin.pkg;
			pkg_sbuf_printf(msg_buf, "Extracting %n-%v", pkg, pkg);
		}
		break;
	case PKG_EVENT_EXTRACT_FINISHED:
		break;
	case PKG_EVENT_ADD_DEPS_BEGIN:
		++add_deps_depth;
		break;
	case PKG_EVENT_ADD_DEPS_FINISHED:
		--add_deps_depth;
		break;
	case PKG_EVENT_INTEGRITYCHECK_BEGIN:
		if (quiet)
			break;
		printf("Checking integrity...");
		break;
	case PKG_EVENT_INTEGRITYCHECK_FINISHED:
		if (quiet)
			break;
		printf(" done (%d conflicting)\n", ev->e_integrity_finished.conflicting);
		break;
	case PKG_EVENT_INTEGRITYCHECK_CONFLICT:
		if (*debug == 0)
			break;
		printf("\nConflict found on path %s between %s and ",
		    ev->e_integrity_conflict.pkg_path,
		    ev->e_integrity_conflict.pkg_uid);
		cur_conflict = ev->e_integrity_conflict.conflicts;
		while (cur_conflict) {
			if (cur_conflict->next)
				printf("%s, ", cur_conflict->uid);
			else
				printf("%s", cur_conflict->uid);

			cur_conflict = cur_conflict->next;
		}
		printf("\n");
		break;
	case PKG_EVENT_DEINSTALL_BEGIN:
		if (quiet)
			break;
		nbdone++;

		job_status_begin(msg_buf);

		pkg = ev->e_install_begin.pkg;
		pkg_sbuf_printf(msg_buf, "Deinstalling %n-%v...\n", pkg, pkg);
		sbuf_finish(msg_buf);
		printf("%s", sbuf_data(msg_buf));
		break;
	case PKG_EVENT_DEINSTALL_FINISHED:
		if (quiet)
			break;
		break;
	case PKG_EVENT_DELETE_FILES_BEGIN:
		if (quiet)
			break;
		else {
			job_status_begin(msg_buf);
			pkg = ev->e_install_begin.pkg;
			pkg_sbuf_printf(msg_buf, "Deleting files for %n-%v",
			    pkg, pkg);
		}
		break;
	case PKG_EVENT_DELETE_FILES_FINISHED:
		break;
	case PKG_EVENT_UPGRADE_BEGIN:
		if (quiet)
			break;
		pkg_new = ev->e_upgrade_begin.n;
		pkg_old = ev->e_upgrade_begin.o;
		nbdone++;

		job_status_begin(msg_buf);

		switch (pkg_version_change_between(pkg_new, pkg_old)) {
		case PKG_DOWNGRADE:
			pkg_sbuf_printf(msg_buf, "Downgrading %n from %v to %v...\n",
			    pkg_new, pkg_old, pkg_new);
			break;
		case PKG_REINSTALL:
			pkg_sbuf_printf(msg_buf, "Reinstalling %n-%v...\n",
		    pkg_old, pkg_old);
			break;
		case PKG_UPGRADE:
			pkg_sbuf_printf(msg_buf, "Upgrading %n from %v to %v...\n",
			    pkg_new, pkg_old, pkg_new);
			break;
		}
		sbuf_finish(msg_buf);
		printf("%s", sbuf_data(msg_buf));
		break;
	case PKG_EVENT_UPGRADE_FINISHED:
		if (quiet)
			break;
		pkg_new = ev->e_upgrade_finished.n;
		if (pkg_has_message(pkg_new)) {
			if (messages == NULL)
				messages = sbuf_new_auto();
			pkg_sbuf_printf(messages, "Message for %n-%v:\n %M\n",
				pkg_new, pkg_new, pkg_new);
		}
		break;
	case PKG_EVENT_LOCKED:
		pkg = ev->e_locked.pkg;
		pkg_printf("\n%n-%v is locked and may not be modified\n", pkg, pkg);
		break;
	case PKG_EVENT_REQUIRED:
		pkg = ev->e_required.pkg;
		pkg_printf("\n%n-%v is required by: %r%{%rn-%rv%| %}", pkg, pkg, pkg);
		if (ev->e_required.force == 1)
			fprintf(stderr, ", deleting anyway\n");
		else
			fprintf(stderr, "\n");
		break;
	case PKG_EVENT_ALREADY_INSTALLED:
		if (quiet)
			break;
		pkg = ev->e_already_installed.pkg;
		pkg_printf("the most recent version of %n-%v is already installed\n",
				pkg, pkg);
		break;
	case PKG_EVENT_NOT_FOUND:
		printf("Package '%s' was not found in "
		    "the repositories\n", ev->e_not_found.pkg_name);
		break;
	case PKG_EVENT_MISSING_DEP:
		warnx("Missing dependency '%s-%s'",
		    pkg_dep_name(ev->e_missing_dep.dep),
		    pkg_dep_version(ev->e_missing_dep.dep));
		break;
	case PKG_EVENT_NOREMOTEDB:
		fprintf(stderr, "Unable to open remote database \"%s\". "
		    "Try running '%s update' first.\n", ev->e_remotedb.repo,
		    getprogname());
		break;
	case PKG_EVENT_NOLOCALDB:
		fprintf(stderr, "Local package database nonexistent!\n");
		break;
	case PKG_EVENT_NEWPKGVERSION:
		newpkgversion = true;
		printf("New version of pkg detected; it needs to be "
		    "installed first.\n");
		break;
	case PKG_EVENT_FILE_MISMATCH:
		pkg = ev->e_file_mismatch.pkg;
		pkg_fprintf(stderr, "%n-%v: checksum mismatch for %Fn\n", pkg,
		    pkg, ev->e_file_mismatch.file);
		break;
	case PKG_EVENT_PLUGIN_ERRNO:
		warnx("%s: %s(%s): %s",
		    pkg_plugin_get(ev->e_plugin_errno.plugin, PKG_PLUGIN_NAME),
		    ev->e_plugin_errno.func, ev->e_plugin_errno.arg,
		    strerror(ev->e_plugin_errno.no));
		break;
	case PKG_EVENT_PLUGIN_ERROR:
		warnx("%s: %s",
		    pkg_plugin_get(ev->e_plugin_error.plugin, PKG_PLUGIN_NAME),
		    ev->e_plugin_error.msg);
		break;
	case PKG_EVENT_PLUGIN_INFO:
		if (quiet)
			break;
		printf("%s: %s\n",
		    pkg_plugin_get(ev->e_plugin_info.plugin, PKG_PLUGIN_NAME),
		    ev->e_plugin_info.msg);
		break;
	case PKG_EVENT_INCREMENTAL_UPDATE:
		if (!quiet)
			printf("%s repository update completed. %d packages processed.\n",
			    ev->e_incremental_update.reponame,
			    ev->e_incremental_update.processed);
		break;
	case PKG_EVENT_DEBUG:
		fprintf(stderr, "DBG(%d)[%d]> %s\n", ev->e_debug.level,
			(int)getpid(), ev->e_debug.msg);
		break;
	case PKG_EVENT_QUERY_YESNO:
		return ( ev->e_query_yesno.deft ?
			query_yesno(true, ev->e_query_yesno.msg, "[Y/n]") :
			query_yesno(false, ev->e_query_yesno.msg, "[y/N]") );
		break;
	case PKG_EVENT_QUERY_SELECT:
		return query_select(ev->e_query_select.msg, ev->e_query_select.items,
			ev->e_query_select.ncnt, ev->e_query_select.deft);
		break;
	case PKG_EVENT_SANDBOX_CALL:
		return ( event_sandboxed_call(ev->e_sandbox_call.call,
				ev->e_sandbox_call.fd,
				ev->e_sandbox_call.userdata) );
		break;
	case PKG_EVENT_SANDBOX_GET_STRING:
		return ( event_sandboxed_get_string(ev->e_sandbox_call_str.call,
				ev->e_sandbox_call_str.result,
				ev->e_sandbox_call_str.len,
				ev->e_sandbox_call_str.userdata) );
		break;
	case PKG_EVENT_PROGRESS_START:
		progressbar_start(ev->e_progress_start.msg);
		break;
	case PKG_EVENT_PROGRESS_TICK:
		progressbar_tick(ev->e_progress_tick.current,
		    ev->e_progress_tick.total);
		break;
	case PKG_EVENT_BACKUP:
		sbuf_cat(msg_buf, "Backing up");
		sbuf_finish(msg_buf);
		break;
	case PKG_EVENT_RESTORE:
		sbuf_cat(msg_buf, "Restoring");
		sbuf_finish(msg_buf);
		break;
	default:
		break;
	}

	return 0;
}
예제 #6
0
void CARI_KART_IMPORT::IMPORT_ROW( QStringList kayit_bilgisi_list  )
{
    if ( kayit_bilgisi_list.size() <= 0 ) {
        return;
    }

    QString firma_sahis_kodu = kayit_bilgisi_list.at(0).mid(0, 60) ;

    SQL_QUERY query_select( DB );

    query_select.PREPARE_SELECT( "car_hesaplar" , "cari_hesap_id" , "cari_hesap_kodu=:cari_hesap_kodu");
    query_select.SET_VALUE( ":cari_hesap_kodu"  , firma_sahis_kodu );

    if( query_select.SELECT() NE 0 ){
        return ;
    }

    int sube_id = SUBE_GET_SUBE_ID();

    double cari_borc   = kayit_bilgisi_list.at(3).toDouble();
    double cari_alacak = kayit_bilgisi_list.at(4).toDouble();

    CARI_HESAP_STRUCT         CARI_KART  ;
    CARI_FIS_SATIRI_STRUCT    CARI_FIS_SATIRI ;

    CARI_SET_HESAP_STRUCT_DEFAULTS( &CARI_KART );

    CARI_KART.cari_hesap_kodu =  kayit_bilgisi_list.at( 0 );
    CARI_KART.cari_hesap_ismi =  kayit_bilgisi_list.at( 1 ).mid(0, 60);
    CARI_KART.para_birimi_id  =  DVZ_GET_DOVIZ_ID( kayit_bilgisi_list.at(2) ) ;

    QString tum_telefon = kayit_bilgisi_list.at( 5 );
    QString telefon   = "";
    QString alan_kodu = "";
    QString ulke_kodu = "";

    TELEFON_BILGISINI_PARSE_ET( ulke_kodu, alan_kodu, telefon, tum_telefon );

    CARI_KART.is_tel_ulke_kodu =  ulke_kodu;
    CARI_KART.is_tel_alan_kodu =  alan_kodu;
    CARI_KART.is_telefonu      =  telefon;

    QString tum_fax = kayit_bilgisi_list.at( 6 );
    QString fax   = "";
    QString fax_alan_kodu = "";
    QString fax_ulke_kodu = "";

    TELEFON_BILGISINI_PARSE_ET( fax_ulke_kodu, fax_alan_kodu, fax, tum_fax );

    CARI_KART.fax_ulke_kodu    =  fax_ulke_kodu;
    CARI_KART.fax_alan_kodu    =  fax_alan_kodu;
    CARI_KART.fax              =  fax;

    CARI_KART.vergi_dairesi    =  kayit_bilgisi_list.at( 7 );
    CARI_KART.vergi_no         =  kayit_bilgisi_list.at( 8 );

    QString tum_adres = kayit_bilgisi_list.at( 9 );
    QString adres_satiri_1 = "";
    QString adres_satiri_2 = "";
    QString adres_satiri_3 = "";

    ADRES_BILGISINI_PARSE_ET( adres_satiri_1, adres_satiri_2, adres_satiri_3, tum_adres );

    CARI_KART.adres_satiri_1  =  adres_satiri_1;
    CARI_KART.adres_satiri_2  =  adres_satiri_2;
    CARI_KART.adres_satiri_3  =  adres_satiri_3;

    CARI_KART.sehir           =  kayit_bilgisi_list.at( 10 );
    CARI_KART.ilce            =  kayit_bilgisi_list.at( 11 );
    CARI_KART.semt            =  kayit_bilgisi_list.at( 12 );

    CARI_KART.program_id      =  K9_PROGRAMI ;
    CARI_KART.modul_id        =  CARI_MODULU ;
    CARI_KART.cari_kart_turu  =  FIRMA_KAYDI;
    CARI_KART.cari_kart_tipi  =  ENUM_CARI_ALICI;
    CARI_KART.muh_hesap_id    =  SUBE_GET_SUBE_ENT_HESAP_ID(sube_id, "cari_alici_ent_hesap_id");

    int cari_hesap_id = CARI_KART_OLUSTUR( FIRMA_KAYDI, &CARI_KART ) ;

    if( m_fis_id EQ -1 ){

        CARI_FIS =  new CARI_FIS_STRUCT ;

        CARI_CLEAR_FIS_STRUCT( CARI_FIS );

        CARI_FIS->cari_hesap_id        =  cari_hesap_id ;
        CARI_FIS->program_id           =  K9_PROGRAMI ;
        CARI_FIS->modul_id             =  CARI_MODULU ;
        CARI_FIS->fis_turu             =  ENUM_CARI_ACILIS_FISI ;
        CARI_FIS->fis_no               =  CARI_SIRADAKI_FIS_NO_AL( MALI_YIL_FIRST_DATE().toString("yyyy.MM.dd") ) ;
        CARI_FIS->cari_para_birimi_id  =  CARI_KART.para_birimi_id ;
        CARI_FIS->fis_tarihi           =  MALI_YIL_FIRST_DATE().toString("yyyy.MM.dd");
        CARI_FIS->aciklama             =  tr("CARİ AÇILIŞ FİŞİ - İmport İşlemi Esnasında Üretilmiştir.");
        CARI_FIS->kaydedilecek_sirket  =  SIRKET_1 ;
        CARI_FIS->base_fis_id          =  0;

        m_fis_id = CARI_FIS_EKLE( CARI_FIS ) ;
    }

    CARI_CLEAR_FIS_SATIRI_STRUCT( &CARI_FIS_SATIRI );

    CARI_FIS_SATIRI.cari_hesap_id         =  cari_hesap_id ;
    CARI_FIS_SATIRI.fis_id                =  m_fis_id ;
    CARI_FIS_SATIRI.program_id            =  K9_PROGRAMI ;
    CARI_FIS_SATIRI.modul_id              =  CARI_MODULU ;
    CARI_FIS_SATIRI.kaydedilecek_sirket   =  SIRKET_1;
    CARI_FIS_SATIRI.doviz_id              =  CARI_KART.para_birimi_id;

    //! IMPORT ISLEMINDE SADECE BIRI ALINIR
    if ( cari_borc >= cari_alacak ) {
        cari_borc -= cari_alacak;
        cari_alacak = 0.00;
    }
    else {
        cari_alacak -= cari_borc;
        cari_borc    = 0.00;
    }

    if( cari_borc > 0 ){
        CARI_FIS_SATIRI.cari_para_birimi_tutari = cari_borc;
        CARI_FIS_SATIRI.alacak_tutari           = 0;
        CARI_FIS_SATIRI.borc_tutari             = cari_borc;

        CARI_FIS_SATIRI_EKLE( CARI_FIS , &CARI_FIS_SATIRI );
    }
    if ( cari_alacak > 0 )  {
        CARI_FIS_SATIRI.borc_tutari              = 0 ;
        CARI_FIS_SATIRI.alacak_tutari            = cari_alacak;
        CARI_FIS_SATIRI.cari_para_birimi_tutari  = cari_alacak;

        CARI_FIS_SATIRI_EKLE( CARI_FIS , &CARI_FIS_SATIRI );
    }

    if ( GET_GRUP_IDLERI()->size() > 0 ) {
        GRP_KAYDI_GRUPLARA_EKLE( K9_PROGRAMI, CARI_MODULU, cari_hesap_id, GET_GRUP_IDLERI() );
    }
}