Blog Of Sem: 2018

Aspxgridview selected ve toplu işlemleri

--aşağıdaki kod bütün seçili rowlara işlem yapar
List<object> SelectedUsers = grid.GetSelectedFieldValues(new string[] { "ID", "TUTAR" });
foreach (object user in SelectedUsers)
{
IList items = user as IList;
if (items == null) return;
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CarringtonWebConnectionString1"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("update ACIKHESAP set ODEME_DURUMU=1, ODENEN_TUTAR=" + items[1].ToString() + " where ID=" + items[0].ToString(), con);
cmd.ExecuteNonQuery();
}

---aşağıdaki kod seçili seçili deil farketmez hepsine işlem yapar
for (int i = 0; i < grid.VisibleRowCount; i++)
{
var items = grid.GetRowValues(i, new string[] { "ID", "TUTAR" }) as object[];
// ASPxListBox1.Items.Add(rowValues[0].ToString());
//you can add these key in a list here

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CarringtonWebConnectionString1"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("update ACIKHESAP set ODEME_DURUMU=2, ODENEN_TUTAR=" + items[1].ToString() + " where ID=" + items[0].ToString(), con);
cmd.ExecuteNonQuery();

Sql toplu hareket görenleri kasmadan silme

declare @counter int
declare @numOfRecords int
declare @batchsize int

set @numOfRecords = 700924 --burdaki rakam databasei acip tables yazisini secip f7 basinca rowcountu en cok olan rakam

set @counter = 0
set @batchsize = 2500

set rowcount @batchsize
while @counter < (@numOfRecords/@batchsize) +1
begin
set @counter = @counter + 1
delete Erp_InventoryReceiptItem

update Erp_Invoice set InventoryReceiptId = null

update Erp_InventoryReceiptAttachment set InventoryReceiptId = null

delete Erp_InventoryReceiptAttachment

delete Erp_InvoiceAttachment

delete Erp_WorkOrderProduction
UPDATE Erp_InventoryReceiptItem set InventoryReceiptId=null
delete Erp_InventoryReceipt

update Erp_InventoryReceipt set InvoiceId=null
delete Erp_Invoice

delete Erp_BankAccountTotal

delete Erp_BankCredit
update Erp_CurrentAccountReceipt set BankReceiptId=null
delete Erp_BankReceiptItem

update Erp_ChequeReceipt set BankReceiptId=null

delete Erp_ChequeReceiptItem

delete Erp_ChequeReceiptAttachment

delete Erp_ChequeReceipt

delete Erp_BankReceiptAttachment

delete Erp_BankReceipt

delete Erp_CashTotalItem

delete Erp_CashTotal

delete Erp_Cheque

delete Erp_OrderReceiptItem

delete Erp_OrderReceiptAttachment

delete Erp_OrderReceipt

delete Erp_ContractItem

delete Erp_ContractAttachment

delete Erp_Contract

update Erp_InventoryReceipt set CurrentAccountReceiptId = null
delete Erp_CurrentAccountReceiptItem

delete Erp_CurrentAccountReceiptAttachment

delete Erp_CurrentAccountReceipt

delete Erp_CurrentAccountTotal

delete Erp_QuotationReceiptItem

delete Erp_QuotationReceiptAttachment

delete Erp_QuotationReceipt

delete Erp_DemandReceiptItem

delete Erp_DemandReceiptAttachment

delete Erp_DemandReceipt

delete Erp_WorkOrderItem

delete Erp_WorkOrderAttachment

delete Erp_WorkOrderExplanation

delete Erp_WorkOrder

delete Erp_GLReceiptItem
update Erp_InventoryReceipt set GLReceiptId=null

delete Erp_GLReceipt

Delete Erp_InventoryTotal

delete Erp_ReceiptPaymentItem

delete Meta_ForexRate

delete Erp_ServiceTotal

Delete Erp_GLAccountTotal

delete Erp_BankAccountTotal
update Erp_InventoryReceipt set PosReceiptId=null
delete erp_pos
delete Erp_InventoryReceipt
delete RPL_TaskTarget
delete Rpl_TaskItem
delete RPL_Task
delete Rpl_Xref
delete [LiveHareketler].[dbo].[Replication]
end
set rowcount 0

truncate table Log_Transaction

shrink işlemi:
USE LiveHareketler;
GO
ALTER DATABASE LiveHareketler
SET RECOVERY SIMPLE;
GO

--Datadakı log dosyasını shrınk yap yani database sağ tıkla task shrink files log->reorganize page 0 ve tamam ve sonrasındada yine databasee sağ tık task shrink database ok

ALTER DATABASE LiveHareketler
SET RECOVERY FULL;
GO

visual studio asp datasource olarak xmli kullanmak

new empty web project
insert new web page adı index.aspx
insert new item xml
içine :
<?xml version="1.0" encoding="utf-8" ?>
<Students>
<Student
StudentID="1"
FirstName="A"
LastName="AA"
TotalMarks="100">
</Student>
<Student
StudentID="2"
FirstName="B"
LastName="BB"
TotalMarks="200">
</Student>
<Student
StudentID="3"
FirstName="C"
LastName="CC"
TotalMarks="500">
</Student>
<Student
StudentID="4"
FirstName="D"
LastName="DD"
TotalMarks="700">
</Student>
</Students>

ve gridview at ve datasource xmlden xml dosyasını seç

alastyr plesk windows hostinge pcdeki sql serverden baglanma

once pleski acip sol tarafdan databesisden yeni kullanici yarat
ms sql secili olsun allow remote connections from secip altina who.isden ipni yaz

daha sonra database yeni database server sql server

sql serverede
server name sadece ornekserver.com yazilmasi yeterli
login pleskte database kısmında user managementta yaratilan kullanici ve parola

-------------------
visual studio asp proje deploy,
pleske visual studio aspxlerin projelerini ataiblmek icin alastyre pleskte web deployu aktif etmelerini soyle.
bu tarz link mail atacaklar sana https://mywebsite.xyz:8172/msdeploy.axd?site=mywebsite.xyz
bunu visual studioda solutiona sag tikla publishden web deployu secerek.

server: https://mywebsite.xyz:8172/msdeploy.axd?site=mywebsite.xyz
site: mywebsite.xyz/sw/test
user name:mywebsite (hostu alirken attiklari kullanici adi)
password:parola (hostu alirken attiklari kullanici adi)
destination url:mywebsite.xyz/sw/test

git ile projeyi sifirdan githuba yukleme

once projenin oldugu klasore sag tikla git bash here de

githubda new repositiries yarat ornek ad : asp_admin_panel_master_session
git init
git remote add origin https://github.com/semt20/asp_admin_panel_master_session.git
git add .
git commit -m "initial commit"
git push origin master

Visual studio gitlabdaki deişen kodları almak için :
team explorer
Sync
Fetch
Pull

devexpress aspx 17.2 localisation language

devexpress aspx turkcelestirme once projede web.confige gir ve <globalization culture="tr-Tr" uiCulture="tr-Tr"/> ekle daha sonra devexpressin sitesinden
https://localization.devexpress.com/Localization/List turkceyi indir projenin bulundugu bin icine tr diye klasor ac ve icine at aynı zamanda C:\Program Files (x86)\DevExpress 17.2\Components\Bin\Framework\ burdada tr diye bir klasor ac ve icine at

ASPXGRIDVIEW İşlemleri

Gridviewde seçili satırın bilgisini alabilme :
protected void ASPxGridView1_SelectionChanged(object sender, EventArgs e)
{
var products = ASPxGridView1.GetSelectedFieldValues("NAME");
Label1.Text = products[0].ToString();
}

Gridviewin Sonuna İşlemler Seç eklemek için source da sona ekle

<dx:GridViewDataHyperLinkColumn Caption="İşlemler" FieldName="ID">

</dx:GridViewDataHyperLinkColumn>

</Columns>

</dx:ASPxGridView>

Gridview devexpress 7.2 sonrası için gecerli export Gridview
<Columns>un altina ekle
<SettingsExport EnableClientSideExportAPI="true" ExcelExportMode="WYSIWYG" />

<Columns>un ustune ekle
  <Toolbars>
            <dx:GridViewToolbar EnableAdaptivity="true">
                <Items>
                    <dx:GridViewToolbarItem Command="ExportToPdf" />
                    <dx:GridViewToolbarItem Command="ExportToXls" />
                    <dx:GridViewToolbarItem Command="ExportToXlsx" />
                    <dx:GridViewToolbarItem Command="ExportToDocx" />
                    <dx:GridViewToolbarItem Command="ExportToRtf" />
                    <dx:GridViewToolbarItem Command="ExportToCsv" />
                </Items>
            </dx:GridViewToolbar>
        </Toolbars>

Gridview grup category combobox ve baglantisi
birinci sqldatasource_musteriler yarat ve bunu aspxgridviewe bind
Ikinci datasource sqldatasource_musterigruplari yarat bu bir yere bind olmayacak

Sqlden iki tablo yarat birinin adi musteri(id,adi,grupid) olsun
digeride musteri_grup (id,grup_adi) olsun

aspxgridview designerda columnsa tikla combobox column ekle captionunu grup yap, Fieldname grupid sec, sag tabda comboboxpropertiesde datasourceid musteri_gruplarini sec text field grup_adi , valuefield=id

Gridview Horizontal scrollbar

<dx:ASPxGridView Width="100%" ID="ASPxGridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" KeyFieldName="ID" OnCellEditorInitialize="ASPxGridView1_CellEditorInitialize">

<Settings ShowFilterRow="True" ShowGroupPanel="True" />

<Settings HorizontalScrollBarMode="Auto" />

<Settings VerticalScrollBarMode="Auto" />

Datasource eklemede hata alırsan sol taraftan server explorerden modify deyip save passwordu seç

Gridview Required zorunlu alan ayari
Designerda ac ve columnsdan zorunlu alana tıkla ve sağda textboxpropertiesden en aşağıda validation settingste requiredi true yap

Master Detail Grid
ONCE 2 TANE SQLDATASOURCE VE 2 TANE ASPXGRIDVIEW YARAT BIRI MUSTERILER DIGERI MUSTERI HAREKETLER
MUSTERILERI NORMAL TABLODAN AL ASPXGRIDVIEW MUSTERILERIN SETTINGS DETAILDE DETAILROWU TRUE YAP,

MUSTERI HAREKETLERINIDE AL WHERE KISMINA TIKLA COLUMN MUSTERI_ID OPERATOR " = " , SOURCE SESSION , SESSION FIELD = MUSTERI_ID

VE DAHA SONRA KODA EKLE
protected void ASPxGridViewmusterihareketler_BeforePerformDataSelect(object sender, EventArgs e)
{
Session["MUSTERI_ID"] = (sender as ASPxGridView).GetMasterRowKeyValue();
}

SON OLARAKDA ASPXGRIDVIEWMUSTERILERE TIKLA EDITTEMPLATE VE DETAILROWU SEC VE ASPXGRIDMUSTERIHAREKETLERINI ICINE SURUKLE VE END TEMPLATE YAP

Gridviewda son kolumun genişliğini max yapmak
<Columns>
<dx:GridViewCommandColumn ShowDeleteButton="True" ShowEditButton="True" ShowNewButtonInHeader="True" VisibleIndex="0">
</dx:GridViewCommandColumn>
<dx:GridViewDataTextColumn FieldName="ID" ReadOnly="True" VisibleIndex="1">
<EditFormSettings Visible="False" />
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="ADI" VisibleIndex="2" Width="100%">
</dx:GridViewDataTextColumn>
</Columns>

gridview detay masterda detay width sorunu once masterin altina ekle :
<dx:ASPxGridView Width="100%"
<Settings HorizontalScrollBarMode="Auto" />
<Settings VerticalScrollBarMode="Auto" />

sonra masterin son colomunun widthini %100 yap
<dx:GridViewDataTextColumn FieldName="ADI" VisibleIndex="2" Width="100%">

sonra detaya ekle
<dx:ASPxGridView2 Width="100%"
<Settings HorizontalScrollBarMode="Auto" />
<Settings VerticalScrollBarMode="Auto" />

Github visual studio asp .net core projesi alip uyumlamak

git clone https://github.com/etrupja/DrinkAndGo.git

sonra projeyi aç appsettings.jsondan veritabanını deiş
Data Source=DESKTOP-PA213SA;Initial Catalog=dtest;Persist Security Info=True;User ID=sa;Password=2323211

view other window package manager consolea gir
ve aşağıya yazz önce
add-migration "Initial"
update-database

Live Hareket Goren istenmeyen malzemeleri toplu olarak sqlden silme

Silinmesi isdenilen malzemelerin recidleri () lerin icine yazilir

--update Erp_InventoryPriceList set UnitSetItemId = null where InventoryId in
--()

--delete Erp_InventoryPriceList where InventoryId in
--()

--delete Erp_RecipeItem from Erp_RecipeItem RI
--where RecipeId = (Select RecId from Erp_Recipe R where R.RecId = RI.RecipeId and R.InventoryId in
--()
--)

--delete Erp_Recipe where InventoryId in
--()

--update Erp_Inventory Set RecipeUnitItemId = null where RecId in
--()

--update Erp_InventoryUnitItemSize set InventoryId = null where InventoryId in
--()

--delete Erp_InventoryUnitItemSize where InventoryId in
--()

--delete Erp_InventoryBarcode where InventoryId in
--()

--delete Erp_InventoryWarehouse where InventoryId in
--()

--delete Erp_Project where InventoryId in
--()

--delete Erp_FixedAssetDepreciation where InventoryId in
--()

--delete Erp_InventoryExplanation where InventoryId in
--()

--delete Erp_InventoryAlternative where InventoryId in
--()

--delete Erp_FixedAssetExpense where InventoryId in
--()

--delete Erp_InventoryAttachment where InventoryId in
--()

--delete Erp_InitialCostItem from Erp_InitialCostItem IC
--where InitialCostId = (Select RecId from Erp_InitialCost I where I.RecId = IC.InitialCostId and I.InventoryId in
--()
--)

--delete Erp_InitialCost where InventoryId in
--()

--delete Erp_RecipeItem where InventoryId in
--()

--delete Erp_RouteItem from Erp_RouteItem RI where RouteId = (select RecId from Erp_Route R where RI.RouteId=R.RecId and R.InventoryId in
--()
--)

--delete Erp_Route where InventoryId in
--()

--delete Erp_Inventory where RecId in
--()

Bootstrap Pass ID to Modal

Visual c# asp icin windows 10 asp yükleme

Sentez Live Dev - Sql Queryden Hareketlerin Silinmesi

Aşağıdaki sorgu liveda (peşin satışsız,ncrsız) kartlar dışında hareketleri siler:(malzeme fişleri ,irsaliyeler,faturalar,teklifler,sipariş,muhasebe fişi,banka çek fişleri).
Sildikten sonra shrink yapılmalı aşağıda nasıl yapıldığı anlatılmıştır.Yaklaşık 14 gblık datayı 700mba düşürdü.

delete Erp_InventoryReceiptItem
update Erp_Invoice set InventoryReceiptId = null
update Erp_InventoryReceiptAttachment set InventoryReceiptId = null
delete Erp_InventoryReceiptAttachment
delete Erp_InvoiceAttachment
delete Erp_WorkOrderProduction
delete Erp_InventoryReceipt
delete Erp_Invoice
delete Erp_BankAccountTotal
delete Erp_BankCredit
delete Erp_BankReceiptItem
update Erp_ChequeReceipt set BankReceiptId=null
delete Erp_ChequeReceiptItem
delete Erp_ChequeReceiptAttachment
delete Erp_ChequeReceipt
delete Erp_BankReceiptAttachment
delete Erp_BankReceipt
delete Erp_CashTotalItem
delete Erp_CashTotal
delete Erp_Cheque
delete Erp_OrderReceiptItem
delete Erp_OrderReceiptAttachment
delete Erp_OrderReceipt
delete Erp_ContractItem
delete Erp_ContractAttachment
delete Erp_Contract
delete Erp_CurrentAccountReceiptItem
delete Erp_CurrentAccountReceiptAttachment
delete Erp_CurrentAccountReceipt
delete Erp_CurrentAccountTotal
delete Erp_QuotationReceiptItem
delete Erp_QuotationReceiptAttachment
delete Erp_QuotationReceipt
delete Erp_DemandReceiptItem
delete Erp_DemandReceiptAttachment
delete Erp_DemandReceipt
delete Erp_WorkOrderItem
delete Erp_WorkOrderAttachment
delete Erp_WorkOrderExplanation
delete Erp_WorkOrder
delete Erp_GLReceiptItem
delete Erp_GLReceipt
Delete Erp_InventoryTotal
delete Erp_ReceiptPaymentItem
delete Meta_ForexRate
delete Erp_ServiceTotal
Delete Erp_GLAccountTotal
delete Erp_BankAccountTotal
truncate table Log_Transaction

shrink işlemi:
USE LiveHareketler;
GO
ALTER DATABASE LiveHareketler
SET RECOVERY SIMPLE;
GO

--Datadakı log dosyasını shrınk yap yani database sağ tıkla task shrink files log->reorganize page 0 ve tamam ve sonrasındada yine databasee sağ tık task shrink database ok

ALTER DATABASE LiveHareketler
SET RECOVERY FULL;
GO

Laravel Php QuickAdmin Github

https://github.com/LaravelDaily/quickadmin

c:\wamp64\www icine LaravelDaily klasor yarat not php 7 ve ustu olmalı systen enviromant path..
eğer pcde hem iis hem wamp kullanıyorsun portlar cakisacak wampin portunu deis

C:\wamp64\bin\apache\apache2.4.35\conf\httpd.conf
Listen 0.0.0.0:80>>Listen 0.0.0.0:8081
Listen [::0]:80>>Listen [::0]:8081

c:\wamp64\www icine LaravelDaily klasor yarat
ve cmdde oraya git
composer global require laravel/installer
composer create-project laravel/laravel QuickAdmin --prefer-dist

cd QuickAdmin
composer clear-cache
composer require laraveldaily/quickadmin

open;
C:\wamp64\www\LaravelDaily\QuickAdmin\config\app.php

in the $providers array;
Laraveldaily\Quickadmin\QuickadminServiceProvider::class,

C:\wamp64\www\LaravelDaily\QuickAdmin\.env
*database connection is required. Check your .env file
DB_CONNECTION=mysql

DB_HOST=localhost

DB_PORT=3306

DB_DATABASE=quickadmin

DB_USERNAME=root

DB_PASSWORD=

---------------------
C:\wamp64\www\LaravelDaily\QuickAdmin\app\Providers\AppServiceProvider.php dosyasını duzenle
use Illuminate\Support\Facades\Schema;
public function boot()
{
Schema::defaultStringLength(191);
}
------------------
php artisan quickadmin:install
kullanıcı adı eposta sifre belirle
--------------------
C:\wamp64\www\LaravelDaily\QuickAdmin\app\Http\Kernel.php
bu kismin icine asagidakini ekle protected $routeMiddleware = [
'role' => \Laraveldaily\Quickadmin\Middleware\HasPermissions::class,

--------------
datatablellarda export etmesini isdersen : bu dosyayı bul ekle
C:\wamp64\www\LaravelDaily\QuickAdmin\resources\views\admin\partials\javascripts.blade.php

<script src="https://cdn.datatables.net/buttons/1.5.2/js/dataTables.buttons.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.flash.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/vfs_fonts.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.html5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.print.min.js"></script>

ve bu boyle olsun
$('#datatable').dataTable( {
"language": {
"url": "{{ trans('quickadmin::strings.datatable_url_language') }}"
},
dom: 'Bfrtip'
});
---------------
dili türkçeleştirmek için bu dosyadan:C:\wamp64\www\LaravelDaily\QuickAdmin\resources\lang\vendor\laraveldaily\en\admin.php
-----------------
eger menuden fazlaliklari kaldirmak isdersen dosyayı düzenle : C:\wamp64\www\LaravelDaily\QuickAdmin\resources\views\admin\partials\sidebar.blade.php

son olarak
php artisan serve ve http://127.0.0.1:8000/admin git

sql server insert trigger basit yol

Logo trigger ozel kod

https://www.youtube.com/watch?v=JFHKa3PEYuQ

CREATE TRIGGER KOD
ON LG_005_01_INVOICE
FOR INSERT
AS
DECLARE @GRPCODE INT, @SPECODE NVARCHAR(20), @LOGICALREF INT

SELECT @GRPCODE = GRPCODE, @SPECODE = SPECODE, @LOGICALREF = LOGICALREF FROM INSERTED

IF (@GRPCODE =1)
BEGIN
UPDATE LG_005_01_INVOICE SET SPECODE = 'ALIŞ' WHERE LOGICALREF = @LOGICALREF
END
ELSE
BEGIN
UPDATE LG_005_01_INVOICE SET SPECODE ='SATIŞ' WHERE LOGICALREF =@LOGICALREF
END

Sql Server HIZLI Sorgu

select * into #satislar from logo_view_satislar_2014_2015 --sql serverde masterin altinda tempdbye atar sadece kullanılan sezondaki kisi erisebilir sql kapanip acilirsa sifirlanir

select yil,sum(toplamtutar) from #satislar group by yil

https://youtu.be/Tl-NWu1VPMc?t=5309

React native app

https://nodejs.org/en/download/ indir ve kur
https://www.sublimetext.com/3 kur
sublime ac->view->show consolea gir ve burdaki kodlari ekle
https://packagecontrol.io/installation
android studio ve bluestack kur
https://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
Windows x64 207.22 MB jdk-8u191-windows-x64.exe kur

cmd
npm install -g expo-cli
npm install -g react-native-cli
npm install -g create-react-native-app
react-native init projectNameHere
cd projectNameHere
react-native run-android

ENVIRMNT USER PATH
%LOCALAPPDATA%\Android\sdk\platform-tools

SYSTEM PATH:C:\Program Files\Java\jdk1.8.0_191
SYSTEM NEW JAVA_HOME C:\Program Files\Java\jdk1.8.0_191
F:\masaustussd\react native\test\android\ klasorunun icine local.properties isminde dosya YARAT ve icine sdk.dir = C:\\Users\\Pnp\\AppData\\Local\\Android\\sdk

Sentez Live Erp Kesin Yevmiyeyi Silme

OIuşan Sorunlar:
- Kesin Yevmiye Tarihinden Önce İşlem Yapılamaz .
- entegrasyon fişi yevmiye madde numarasına sahip. Bu fiş üzerinden işlem yapamazsınız .

select RegBookNo, * from Erp_GLReceipt --RegBookNo boş deilse yevmiye oluşturulmuş demektir

select * from Erp_GLRegBook --yevmiye oluşan fiş

update Erp_GLReceipt set RegBookNo = null --yevmiye oluştuysa sil

SQL SERVER SISTEMI KASMADAN SILME WHILE

DECLARE @Rowcount INT = 1 WHILE @Rowcount > 0 BEGIN DELETE TOP (50000) FROM LG_013_01_PAYTRANS where ORGLOGOID LIKE 'TNYF%'
SET @Rowcount = @@ROWCOUNT
END

ps3 crack filezilla

ethernet kablsonu bagla
Settings > Network Settings > Settings and Connection Status List. ipyi not et
sarkı usbsini ps3e tak
pacckate setupa gir
sarkı usbsinin içindeki ortadaki programı kur
multimanin oldugu kısımda fileboxa gir ve bilgisardan filezillayı ac
Host: Your PS3's IP address
Port: 21
Logon type: Normal
User: anonymous
Password: (Clear it out and leave it blank)
On the "Transfer settings" tab:
Transfer mode: active
Tick "Limit number of simultaneous connections" and set it to 1
connect okeydir
oyunu "dev_hdd0/GAMEZ" icine at
ve multimane gir refresh yap

LOGO GO XML VERI ALMA SATIN ALMA FATURASI

ILK TYPEIN ALTINA <NUMBER>FATURA NO22</NUMBER> OLURSA DOCNOLARDIR
IKINCI TYPIN ALTINA <INVOICE_NUMBER>FATURA NO22</INVOICE_NUMBER>

ASAGIYI XML OLARAK KAYDET

<?xml version="1.0" encoding="UTF-8"?>
<PURCHASE_INVOICES>
<INVOICE DBOP="INS">
<TYPE>1</TYPE>

<DATE>05.04.2017</DATE>
<TIME>389550080</TIME>
<AUXIL_CODE>1</AUXIL_CODE>
<ARP_CODE>SATICI001</ARP_CODE>
<POST_FLAGS>247</POST_FLAGS>
<VAT_RATE>3</VAT_RATE>
<TOTAL_DISCOUNTED>24</TOTAL_DISCOUNTED>
<TOTAL_GROSS>24</TOTAL_GROSS>
<TOTAL_NET>24</TOTAL_NET>
<TC_NET>24</TC_NET>
<RC_XRATE>1</RC_XRATE>
<RC_NET>24</RC_NET>
<CREATED_BY>1</CREATED_BY>
<DATE_CREATED>05.04.2018</DATE_CREATED>
<HOUR_CREATED>23</HOUR_CREATED>
<MIN_CREATED>57</MIN_CREATED>
<SEC_CREATED>51</SEC_CREATED>
<CURRSEL_TOTALS>2</CURRSEL_TOTALS>
<DATA_SITEID>1</DATA_SITEID>
<DISPATCHES>
<DISPATCH>
<TYPE>1</TYPE>

<DATE>05.04.2017</DATE>
<TIME>389550146</TIME>
<AUXIL_CODE>1</AUXIL_CODE>
<ARP_CODE>SATICI001</ARP_CODE>
<INVOICED>1</INVOICED>
<TOTAL_DISCOUNTED>24</TOTAL_DISCOUNTED>
<TOTAL_GROSS>24</TOTAL_GROSS>
<TOTAL_NET>24</TOTAL_NET>
<RC_RATE>1</RC_RATE>
<RC_NET>24</RC_NET>
<CREATED_BY>1</CREATED_BY>
<DATE_CREATED>05.04.2018</DATE_CREATED>
<HOUR_CREATED>23</HOUR_CREATED>
<MIN_CREATED>57</MIN_CREATED>
<SEC_CREATED>52</SEC_CREATED>
<CURRSEL_TOTALS>2</CURRSEL_TOTALS>
<DATA_SITEID>1</DATA_SITEID>
<ORIG_NUMBER>0000000000051667</ORIG_NUMBER>
<ORGLOGOID />
<DEDUCTIONPART1>2</DEDUCTIONPART1>
<DEDUCTIONPART2>3</DEDUCTIONPART2>
<AFFECT_RISK>0</AFFECT_RISK>
<DISP_STATUS>1</DISP_STATUS>
</DISPATCH>
</DISPATCHES>
<TRANSACTIONS>
<TRANSACTION>
<TYPE>0</TYPE>
<MASTER_CODE>AŞI0008</MASTER_CODE>
<QUANTITY>1</QUANTITY>
<PRICE>24</PRICE>
<TOTAL>24</TOTAL>
<CURR_PRICE>160</CURR_PRICE>
<PC_PRICE>24</PC_PRICE>
<RC_XRATE>1</RC_XRATE>
<UNIT_CODE>ADET</UNIT_CODE>
<UNIT_CONV1>1</UNIT_CONV1>
<UNIT_CONV2>1</UNIT_CONV2>
<VAT_INCLUDED>1</VAT_INCLUDED>
<VAT_BASE>24</VAT_BASE>
<BILLED>1</BILLED>
<TOTAL_NET>24</TOTAL_NET>
<DATA_SITEID>1</DATA_SITEID>
<DISPATCH_NUMBER>0000000000051667</DISPATCH_NUMBER>
<DETAILS />
<DIST_ORD_REFERENCE>0</DIST_ORD_REFERENCE>
<CAMPAIGN_INFOS>
<CAMPAIGN_INFO />
</CAMPAIGN_INFOS>
<EDT_CURR>160</EDT_CURR>
<EDT_PRICE>24</EDT_PRICE>
<ORGLOGOID />
<DEFNFLDSLIST />
<MONTH>4</MONTH>
<YEAR>2017</YEAR>
<PRCLISTREF>740</PRCLISTREF>
<PREACCLINES />
</TRANSACTION>
</TRANSACTIONS>
<PAYMENT_LIST>
<PAYMENT>
<DATE>05.04.2017</DATE>
<MODULENR>4</MODULENR>
<SIGN>1</SIGN>
<TRCODE>1</TRCODE>
<TOTAL>24</TOTAL>
<PROCDATE>05.04.2017</PROCDATE>
<REPORTRATE>1</REPORTRATE>
<DISCOUNT_DUEDATE>05.04.2017</DISCOUNT_DUEDATE>
<PAY_NO>1</PAY_NO>
<DISCTRLIST />
<DISCTRDELLIST>0</DISCTRDELLIST>
</PAYMENT>
</PAYMENT_LIST>
<ORGLOGOID />
<DEFNFLDSLIST />
<DEDUCTIONPART1>2</DEDUCTIONPART1>
<DEDUCTIONPART2>3</DEDUCTIONPART2>
<DATA_LINK_REFERENCE>720683</DATA_LINK_REFERENCE>
<INTEL_LIST>
<INTEL />
</INTEL_LIST>
<AFFECT_RISK>0</AFFECT_RISK>
<PREACCLINES />
</INVOICE>
<INVOICE DBOP="INS">
<TYPE>1</TYPE>
<DATE>05.04.2017</DATE>
<TIME>389550080</TIME>
<AUXIL_CODE>1</AUXIL_CODE>
<ARP_CODE>SATICI001</ARP_CODE>
<POST_FLAGS>247</POST_FLAGS>
<VAT_RATE>3</VAT_RATE>
<TOTAL_DISCOUNTED>24</TOTAL_DISCOUNTED>
<TOTAL_GROSS>24</TOTAL_GROSS>
<TOTAL_NET>24</TOTAL_NET>
<TC_NET>24</TC_NET>
<RC_XRATE>1</RC_XRATE>
<RC_NET>24</RC_NET>
<CREATED_BY>1</CREATED_BY>
<DATE_CREATED>05.04.2018</DATE_CREATED>
<HOUR_CREATED>23</HOUR_CREATED>
<MIN_CREATED>57</MIN_CREATED>
<SEC_CREATED>51</SEC_CREATED>
<CURRSEL_TOTALS>2</CURRSEL_TOTALS>
<DATA_SITEID>1</DATA_SITEID>
<DISPATCHES>
<DISPATCH>
<TYPE>1</TYPE>
<DATE>05.04.2017</DATE>
<TIME>389550146</TIME>
<AUXIL_CODE>1</AUXIL_CODE>
<ARP_CODE>SATICI001</ARP_CODE>
<INVOICED>1</INVOICED>
<TOTAL_DISCOUNTED>24</TOTAL_DISCOUNTED>
<TOTAL_GROSS>24</TOTAL_GROSS>
<TOTAL_NET>24</TOTAL_NET>
<RC_RATE>1</RC_RATE>
<RC_NET>24</RC_NET>
<CREATED_BY>1</CREATED_BY>
<DATE_CREATED>05.04.2018</DATE_CREATED>
<HOUR_CREATED>23</HOUR_CREATED>
<MIN_CREATED>57</MIN_CREATED>
<SEC_CREATED>52</SEC_CREATED>
<CURRSEL_TOTALS>2</CURRSEL_TOTALS>
<DATA_SITEID>1</DATA_SITEID>
<ORIG_NUMBER>0000000000051667</ORIG_NUMBER>
<ORGLOGOID />
<DEDUCTIONPART1>2</DEDUCTIONPART1>
<DEDUCTIONPART2>3</DEDUCTIONPART2>
<AFFECT_RISK>0</AFFECT_RISK>
<DISP_STATUS>1</DISP_STATUS>
</DISPATCH>
</DISPATCHES>
<TRANSACTIONS>
<TRANSACTION>
<TYPE>0</TYPE>
<MASTER_CODE>AŞI0008</MASTER_CODE>
<QUANTITY>1</QUANTITY>
<PRICE>24</PRICE>
<TOTAL>24</TOTAL>
<CURR_PRICE>160</CURR_PRICE>
<PC_PRICE>24</PC_PRICE>
<RC_XRATE>1</RC_XRATE>
<UNIT_CODE>ADET</UNIT_CODE>
<UNIT_CONV1>1</UNIT_CONV1>
<UNIT_CONV2>1</UNIT_CONV2>
<VAT_INCLUDED>1</VAT_INCLUDED>
<VAT_BASE>24</VAT_BASE>
<BILLED>1</BILLED>
<TOTAL_NET>24</TOTAL_NET>
<DATA_SITEID>1</DATA_SITEID>
<DISPATCH_NUMBER>0000000000051667</DISPATCH_NUMBER>
<DETAILS />
<DIST_ORD_REFERENCE>0</DIST_ORD_REFERENCE>
<CAMPAIGN_INFOS>
<CAMPAIGN_INFO />
</CAMPAIGN_INFOS>
<EDT_CURR>160</EDT_CURR>
<EDT_PRICE>24</EDT_PRICE>
<ORGLOGOID />
<DEFNFLDSLIST />
<MONTH>4</MONTH>
<YEAR>2017</YEAR>
<PRCLISTREF>740</PRCLISTREF>
<PREACCLINES />
</TRANSACTION>
</TRANSACTIONS>
<PAYMENT_LIST>
<PAYMENT>
<DATE>05.04.2017</DATE>
<MODULENR>4</MODULENR>
<SIGN>1</SIGN>
<TRCODE>1</TRCODE>
<TOTAL>24</TOTAL>
<PROCDATE>05.04.2017</PROCDATE>
<REPORTRATE>1</REPORTRATE>
<DISCOUNT_DUEDATE>05.04.2017</DISCOUNT_DUEDATE>
<PAY_NO>1</PAY_NO>
<DISCTRLIST />
<DISCTRDELLIST>0</DISCTRDELLIST>
</PAYMENT>
</PAYMENT_LIST>
<ORGLOGOID />
<DEFNFLDSLIST />
<DEDUCTIONPART1>2</DEDUCTIONPART1>
<DEDUCTIONPART2>3</DEDUCTIONPART2>
<DATA_LINK_REFERENCE>720683</DATA_LINK_REFERENCE>
<INTEL_LIST>
<INTEL />
</INTEL_LIST>
<AFFECT_RISK>0</AFFECT_RISK>
<PREACCLINES />
</INVOICE>

</PURCHASE_INVOICES>

LOGO TIGER KAPANMAMIS FATURALARIN LISTESI

SELECT PAYTRANS.CARDREF, PAYTRANS.MODULENR, PAYTRANS.FICHEREF, PAYTRANS.TRCODE, SUM(PAYTRANS.TOTAL) AS FATURA_TOPLAMI, SUM(PAYTRANS.PAID) AS KAPANAN_TUTAR,
SUM(PAYTRANS.TOTAL) - SUM(PAYTRANS.PAID) AS KALAN_TUTAR, CLCARD.CODE, CLCARD.DEFINITION_, CLCARD.TOWN,CLCARD.DISTRICT, CLCARD.TELNRS2, PAYTRANS.PROCDATE AS FATURA_TARIHI,
PAYTRANS.DATE_ AS ODEME_TARIHI,

( SELECT ( SELECT DEFINITION_ FROM lg_001_PAYPLANS WHERE LOGICALREF = PAYDEFREF ) FROM lg_001_03_INVOICE WHERE LOGICALREF = PAYTRANS.FICHEREF ) AS ODEME_PLANI

FROM lg_001_03_PAYTRANS AS PAYTRANS
LEFT OUTER JOIN lg_001_CLCARD AS CLCARD ON PAYTRANS.CARDREF = CLCARD.LOGICALREF

WHERE PAYTRANS.CARDREF IN ( SELECT LOGICALREF FROM lg_001_CLCARD AS SYN_CLCARD WHERE CODE LIKE '131 %') AND
( SELECT PAYDEFREF FROM lg_001_03_INVOICE WHERE LOGICALREF = PAYTRANS.FICHEREF) IN( 41, 43, 39 ) AND
PAYTRANS.MODULENR IN( 4 ) AND
PAYTRANS.PROCDATE <> PAYTRANS.DATE_ AND
PAYTRANS.DATE_ <= '2016-10-11 00:00:00.000'

GROUP BY PAYTRANS.CARDREF, PAYTRANS.MODULENR, PAYTRANS.FICHEREF, PAYTRANS.TRCODE, CLCARD.CODE, CLCARD.DEFINITION_, CLCARD.TOWN,CLCARD.DISTRICT, CLCARD.TELNRS2, PAYTRANS.PROCDATE, PAYTRANS.DATE_

HAVING SUM(PAYTRANS.TOTAL) - SUM(PAYTRANS.PAID) > 0.99

ORDER BY PAYTRANS.CARDREF;

Excelde (Large) Kritere Göre En büyük Tarihi , 2nci En büyük Tarihi, 3ncu En büyük Tarihi Bulmak

=IFERROR(LARGE(IF($A$2:$A$9=A2,$B$2:$B$9),1),"")

=IFERROR(LARGE(IF($A$2:$A$9=A2,$B$2:$B$9),2),"")
=IFERROR(LARGE(IF($A$2:$A$9=A2,$B$2:$B$9),3),"")

KanBoard Pano , Database ve Mail Yollama Ayarları

https://github.com/kanboard/kanboard indirip ftpye at direk çalışır...
Aşağıdaki sorguda Panoyu türkçe yapabilirsin. Ama database silip baştan yükleyince sıfırlanır.

update `columns` set title ='On Hazirlik' WHERE title ='Backlog';
update `columns` set title ='Yapilacaklar' WHERE title ='Ready';
update `columns` set title ='Tamamlandi' WHERE title ='Done';
update `columns` set title ='Yapiliyor' WHERE title ='Work in progress';
------------------------------------------------

Eğer Backlogun hiç cıkmasını isdemezsen
delete from `columns` WHERE title ='tBacklog'

---------------------------------------------------
NOT TÜRKÇE KARAKTER KULLANMA
Bir sonraki yeni proje yaratmalarında backlog otomatik olarak gelmesin ve diğer panolar türkçe olarak gelsin isdeniyorusa /app/Model/BoardModel.php içindeki return array(t('Backlog'), t('Ready'), t('Work in progress'), t('Done')); satırını şu şekilde yap
return array( t('Yapilacaklar'), t('Yapiliyor'), t('Tamamlandi'));

--------------

Eğer Database mail ayarlarını yapacaksan ana roottaki config.default.php adını config.php yapip değerlerini vermelisin ornegin default sqldb veritabanı olarak kullanılır ama mysql kullanılması isdeniyorsa ayarının config.php'nin içinden yapılması gerekir. Mail ayarınında aynı yerden yapılması gerekir(gönderen maili).

MYSQL Ayar örneği;
// Sendmail command to use when the transport is "sendmail"
define('MAIL_SENDMAIL_COMMAND', '/usr/sbin/sendmail -bs');

// Run automatically database migrations
// If set to false, you will have to run manually the SQL migrations from the CLI during the next Kanboard upgrade
// Do not run the migrations from multiple processes at the same time (example: web page + background worker)
define('DB_RUN_MIGRATIONS', true);

// Database driver: sqlite, mysql or postgres (sqlite by default)
define('DB_DRIVER', 'mysql');

// Mysql/Postgres username
define('DB_USERNAME', 'pnpwebdisign_trl');

// Mysql/Postgres password
define('DB_PASSWORD', '12ssssw');

// Mysql/Postgres hostname
define('DB_HOSTNAME', 'localhost');

// Mysql/Postgres database name
define('DB_NAME', 'pnpwebdisign_trl');

// Mysql/Postgres custom port (null = default port)
define('DB_PORT', null);

// Mysql SSL key
define('DB_SSL_KEY', null);
------------------------

Gmailden Mail Yollama Ayarı;

// Enable/disable email configuration from the user interface
define('MAIL_CONFIGURATION', true);

// E-mail address used for the "From" header (notifications)
define('MAIL_FROM', 'pxxxx@gmail.com');

// Mail transport available: "smtp", "sendmail", "mail" (PHP mail function), "postmark", "mailgun", "sendgrid"
define('MAIL_TRANSPORT', 'smtp');

// SMTP configuration to use when the "smtp" transport is chosen
define('MAIL_SMTP_HOSTNAME', 'smtp.gmail.com');
define('MAIL_SMTP_PORT', 465);
define('MAIL_SMTP_USERNAME', 'pxxxx@gmail.com');
define('MAIL_SMTP_PASSWORD', '123sxe');
define('MAIL_SMTP_ENCRYPTION', 'ssl'); // Valid values are "null", "ssl" or "tls"

// Sendmail command to use when the transport is "sendmail"
define('MAIL_SENDMAIL_COMMAND', '/usr/sbin/sendmail -bs');

---------------------
Notificationlar mail olarak giderken mail başlığında admin via kanboard vb... yazar onu deiştirmek için /trello/1/app/Core/Mail/client.phpde

$author = e('%s via Kanboard', $this->helper->user->getFullname());

$author = e('%s Tarafından Gönderilen Bilgilendirme', $this->helper->user->getFullname());

Sql Server Shrink Database and Log

--log dosyasını bul
SELECT name FROM sys.master_files WHERE type_desc = 'LOG' and physical_name like '%Jam%'

ALTER DATABASE DevJamieS
SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE (DevJamieS_log, 1)
GO
ALTER DATABASE DevJamieS
SET RECOVERY FULL

------------

USE LKSDB;
GO
ALTER DATABASE LKSDB
SET RECOVERY SIMPLE;
GO

--datadakı log dosyasını shrınk yap

ALTER DATABASE LKSDB
SET RECOVERY FULL;
GO

Sentez Live Erp Komplike Fiyat Politikası

Örneğin bir ürün birden fazla cariye farklı fiyat ve indirimlerde satılıyorsa malzemenin altında fiyat kısmına kodun hiçbir önemi olmamakla beraber carisel bazlı fiyat/indirim tanımlaması yapılması gerekmektedir fakat bu tanımlamarda cari kartın altınada ve malzeme kartının altında fiyat kodu tanımlanmamalıdır. Fakat 1 tanede genel müşteriler için cari deilde sadece 1 fiyat kodu tanımlanıp (herhangi indirim yada fiyat politikası olmayan müşteriler için) kaydedince. Fatura kesiminde malzemede carisel bazlı fiyat tanımı yapılan bir cariyi seçince 1 fiyat kodunu getirmekte diye bir sorun cıkacakdır. Bununda çözümü 1 fiyat kodunun öncelik kısmını 9999 yapılırsa çözülür.

carinin altında ne indirim ne fiyat kod olmayacak
malzmelerin altında ne indirim ne fiyat kod olmayacak cari olacak
1 toptan fiyatta cari olmayacak öncelik 2 olacak
diğerlerinde 1 dışındakilerde öncelik 1 olacak

Excel Kriterli Subtotal (Alttoplam)

=SUMPRODUCT(SUBTOTAL(9,OFFSET(B3:B6,ROW(A3:A6)-MIN(ROW(A3:A6)),,1)),--(A3:A6="çek"))

Sql Server 2008 to xml

SELECT InventoryCode,InventoryName Product, isnull(Price,0) Price
FROM Erp_Inventory
left join Erp_InventoryPriceList on Erp_InventoryPriceList.InventoryId = Erp_Inventory.RecId
FOR XML PATH('MALZEMELER'), ROOT('BILGILER')

Büyük tablodan sqlden verileri silme

bu etkili alttakiler deil fazla
declare @counter int
declare @numOfRecords int
declare @batchsize int

set @numOfRecords = (SELECT COUNT(*) AS NumberOfRecords FROM Erp_InventoryReceiptItem with(nolock) where ParentItemId is not null)
set @counter = 0
set @batchsize = 2500

set rowcount @batchsize
while @counter < (@numOfRecords/@batchsize) +1
begin
set @counter = @counter + 1
Update Erp_InventoryReceiptItem set ParentItemId = null;
end
set rowcount 0
----------------------------------------------
alttakiler:

USE LIVE_UNIMAR_YENI
GO

-- Set to simple mode
ALTER DATABASE LIVE_UNIMAR_YENI SET RECOVERY SIMPLE;
GO

-- Get count of records
SELECT COUNT(*) AS Total FROM Erp_InventoryReceiptItem
GO

-- Delete in batches
DECLARE @VAR_ROWS INT = 1;
WHILE (@VAR_ROWS > 0)
BEGIN
DELETE TOP (100000) FROM Erp_InventoryReceiptItem
SET @VAR_ROWS = @@ROWCOUNT;
CHECKPOINT;
END;
GO

-- Set to full mode
ALTER DATABASE LIVE_UNIMAR_YENI SET RECOVERY FULL;
GO

UzakMasaUstu RDP TERMSVR CRACK 2012 dahil

https://github.com/stascorp/rdpwrap/releases
https://github.com/stascorp/rdpwrap/releases/download/v1.6.2/RDPWrap-v1.6.2.zip
bunu indir ve install.bata bas serverde

bu güncellemyi sil yoksa düşer KB4486563

Devexpress gridview Dinamik Satır Ekleme (sil butonuyla)

Bir tane devexpress gridview yarat ve kodlar aşağıda

using DevExpress.XtraEditors.Repository;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace TIPEXE
{
public partial class Form1 : Form
{
public class BILGILER
{

public BILGILER()
{
}

public string BARKOD { get; set; }
public string ADI { get; set; }
public string SİL { get; set; }

}
public BindingList<BILGILER> _Grid_data;
public Form1()
{
InitializeComponent();

}
private void button3_Click(object sender, EventArgs e)
{
_Grid_data.Add(new BILGILER()
{
BARKOD = "asd",
ADI = "assaas"
});
RepositoryItemButtonEdit SILDUGMESI = new RepositoryItemButtonEdit();
SILDUGMESI.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.HideTextEditor;
SILDUGMESI.Buttons[0].Kind = DevExpress.XtraEditors.Controls.ButtonPredefines.Glyph;
SILDUGMESI.Buttons[0].Image = Bitmap.FromFile("resimler\\simgeler\\SIL.png");
SILDUGMESI.Buttons[0].Caption = "SİL";
SILDUGMESI.ButtonClick += SILDUGMESI_ButtonClick;
gridControl1.RepositoryItems.Add(SILDUGMESI);
gridView1.Columns["SİL"].ColumnEdit = SILDUGMESI;
}
private void SILDUGMESI_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
gridView1.DeleteSelectedRows();
}
private void bunifuFlatButton3_Click(object sender, EventArgs e)
{
Form2 form2 = new Form2();
form2.Show();
}

private void Form1_Load(object sender, EventArgs e)
{
_Grid_data = new BindingList<BILGILER>();
gridControl1.DataSource = _Grid_data;
gridView1.PopulateColumns();
//bunifuFlatButton4.BackColor = Color.Teal;
//bunifuFlatButton4.Activecolor = Color.Teal;
}
}
}

ncr tena live aktarım tamsayı hatası

V0100000000000202830000000000000004160000000001099560000000015166TM12690208011
V0610000000000281688000000002560800000000000000000000000000000000TM12690208011 -OLMAYAN TAMSAYI HATASI
V0610000000000281688000000000560800000000000000000000000000000000TM12690208011 -OLAN

TAMSAYI 3 KARAKTERDEN ONDALIK SAYI 8 KARAKTERDEN FAZLA YAZILAMAZ

kobit route shopmanager vade hizli sentez

cari_list

SELECT
case when VadeOp.fisTermDate <= GETDATE() then 1 else 0 end as Vade,'aaa' as GroupCode,1 as guns,
ca.RecId, ca.TradeName, ca.CurrentAccountCode, ca.GroupId, ca.CurrentAccountName, ca.PriceGroupCode, t.Name + ' - ' + ca.TaxNo as TaxLine
FROM Erp_CurrentAccount ca
left join Meta_TaxOffice t on ca.TaxOfficeId=t.RecId
left join VadeOp on ca.CurrentAccountCode = (select top 1 [Cari Hesap Kodu] from VadeOp where Kalan>1 and Tipi != '' )
where ca.CompanyId = 1
order by ca.RecId;

Sentez Live Ncr Transfer

servere (sentezin sqlin bulundugu) ncr vmwarei kurallar ve xp kurallar içine ipsini alırlar ornek 192.168.0.100
daha sonra ncr ayarları yapılır burda onemli olan malzemelerin içindede fiyatlardada departman olması yoksa fiyatları yollamaz.
Dikkat grup kodu 15 karakterden fazlaysa malzeme listesinde sağ tık ncr gonderde gondermeyebilir.
Kdv tanımlı olması lazım
FİYAT KODLARI MUHAKKAK TANIMLI OLMASI LAZIM 0 OLSA BİLE TANIMLI OLMASI LAZIM VE DEPARTMANLARI

FİYAT GÜNCELLERKEN NCR YAZARKASADAN ANA EKRANA GİDİLMESİ LAZIM

VMWARE \\192.168.254.10\root\DataBase CONDTPLU.DBF DOSYASINDA NCRDAKİ ÜRÜNLERİN LİSTESİ

DİKKAT ET BARKODLAR AYNI OLMAMALI YOKSA AKTARMAZ.

SENTEZ V6 HAREKET GÖRMEYEN ÜRÜNLERİ SİLME

DELETE from SKART FROM SKART LEFT JOIN SFISD ON SFISD.MKOD = SKART.KOD
WHERE SFISD.MKOD IS NULL

LIVE REST TERAZILI BARKODLU URUNLER

sentez live HesapPlani Sehirler Meta_Data

önce Google Drive\sentez yazılım Meta_Data.rar dosyasını live.exenin bulundugu klasore at ve sqlden meta_dbversion u sil
ve programı çalıştır hesap plani gelmeli

visual studio installer vsi bundle 2015

visual studio 2015 installer
https://marketplace.visualstudio.com/items?itemName=VisualStudioClient.MicrosoftVisualStudio2015InstallerProjects
indir kur

daha sonra visu9al studio projen acıkken sağ taraftaki proje listesine add new project other project types visual studio installer bas
setup projecti seç
sağ aşaıda ayarlardan programın gereken yerlerini doldur
author program adı version gibi
daha sorna proje ağacında sağda üstte setupa sağ tık view file system ve yine aynı yere sağ tıkla project output primary seçerek ok bas
en son yine setupa sağ tıkla rebuild yap okdir

https://www.youtube.com/watch?v=HeDBYc3ybxc

SQL SERVER PIVOT TABLE SINIRSIZ COLUMN

DECLARE @cols AS NVARCHAR(MAX),
@query AS NVARCHAR(MAX);

select @cols = STUFF((SELECT distinct ',' + QUOTENAME(ADI)
FROM ZV_LOGO_MALZEME GROUP BY ADI
FOR XML PATH(''), TYPE
).value('.', 'NVARCHAR(MAX)')
,1,1,'')

set @query = 'SELECT KODU,' + @cols + ' from
(
select KODU,ADI
from ZV_LOGO_MALZEME
) x
pivot
(
COUNT(ADI)
for ADI in (' + @cols + ')
) p
'

execute(@query)

--------------

İKİ FARKLI TABLODAN
DECLARE @cols AS NVARCHAR(MAX),
@query AS NVARCHAR(MAX);

select @cols = STUFF((SELECT distinct ',' + QUOTENAME(DEFINITION_)
FROM LG_SLSMAN GROUP BY DEFINITION_
FOR XML PATH(''), TYPE
).value('.', 'NVARCHAR(MAX)')
,1,1,'')

set @query = 'SELECT STGRPCODE,' + @cols + ' from
(
select LG_013_ITEMS.STGRPCODE,DEFINITION_
from LG_SLSMAN
CROSS JOIN LG_013_ITEMS where LG_013_ITEMS.STGRPCODE<>''''

) x
pivot
(
MIN(DEFINITION_)
for DEFINITION_ in (' + @cols + ')
) p
'

execute(@query)

version 6 depo bazlı stoklar ve cari bakiyeleri

depo bazlı ürünler

select DEPO.ADI WarehouseName,SKART.KOD URUN_KODU,SKART.ADI URUN_ADI,SUM((TGIRIS-TCIKIS)) Quantity
from SKARTK
LEFT JOIN SKART ON SKARTK.KOD = SKART.KOD
left join DEPO ON SKARTK.DEPO = DEPO.KOD
where (SKARTK.SIRKET='08' AND SKART.SIRKET='08' AND DEPO.SIRKET = '08')
where (SKARTK.SIRKET='_ActiveCompanyId_' AND SKART.SIRKET='_ActiveCompanyId_' AND DEPO.SIRKET = '_ActiveCompanyId_')
GROUP BY DEPO.ADI,SKART.ADI,SKART.KOD

cari bakiyeleri
select CKART.KOD,CKART.ADI,ISNULL(sum(cast(CARID.BORC AS DECIMAL(10,2)) - cast(CARID.ALACAK AS DECIMAL(10,2))),0) BAKIYE from CKART left join CARID on (CKART.SIRKET=CARID.SIRKET and CKART.KOD=CARID.CKOD) where
--CKART.SIRKET='08' AND
CKART.SIRKET='_ActiveCompanyId_' AND
CKART.SAYI1 >= 0 and CKART.SAYI1 <= 999999999999999 and
CKART.SAYI2 >= 0 and CKART.SAYI2 <= 999999999999999 and
CKART.SAYI3 >= 0 and CKART.SAYI3 <= 999999999999999 and
CKART.SAYI4 >= 0 and CKART.SAYI4 <= 999999999999999 and
CKART.SAYI5 >= 0 and CKART.SAYI5 <= 999999999999999 and INUSE=1
GROUP BY CKART.KOD,CKART.ADI
ORDER BY CKART.ADI

Sentez Live Şifre sormadan direk başlasın

"D:\DATALAR\LIVE\LIVE.exe" /u:Sentez /p:111234 /c:01

u kullanıcı kodu
p parola
c şirket company

windows mobile el terminali windows 10 çalıştır

https://www.youtube.com/watch?v=VBKlFYQktV4
indir : https://www.microsoft.com/en-us/download/details.aspx?id=3182
services.msc
Windows Mobile-2003-based device connectivity
logondan locala ve altındakini tikle

sonra cmdye yaz
REG ADD HKLM\SYSTEM\CurrentControlSet\Services\RapiMgr /v SvcHostSplitDisable /t REG_DWORD /d 1 /f

REG ADD HKLM\SYSTEM\CurrentControlSet\Services\WcesComm /v SvcHostSplitDisable /t REG_DWORD /d 1 /f

sonra pcye restart at

Sentez Live web ayarı

/Live/WebApp/LiveWebReport_3004.zip indir

liveweb denetim masasından windows özellik yükleden internet information service>world wide web services>application development features .netler aspleri seç ve yükle

daha sonra Internet Information Services (IIS) Manager aç Add Website ye bas LiveWebReport_3004.zip nereye cıkarttıysan orayı göster ve o klasore everyone yetkisi ver, Daha sonra yine iisden application poolsdan ekledğin siteye çift tıkla .net clr version v4 olsun ve classic olsun ok de ve recyclea bas, LiveServer.exeyi çalıştır ve siteye gir

Sentez Dev Mizan Excele

excelde
data -> from other source -> from microsoft query>new data source ilişklendirmeyi yap sorguyada aşağıdakileri yapıştır...

profilerda mizanı çekerken kod:

exec sp_executesql N' if object_id(''tempdb..#GLReceiptBalanceTmp'') is not null drop table #GLReceiptBalanceTmp create table #GLReceiptBalanceTmp ( CompanyId int,AccountId int, AccountCode nvarchar(25) collate database_default, AccountName nvarchar(50) collate database_default ,Debit decimal(28,8),Credit decimal(28,8),DebitBalance decimal(28,8),CreditBalance decimal(28,8) ,ForexDebit decimal(28,8),ForexCredit decimal(28,8),ForexDebitBalance decimal(28,8),ForexCreditBalance decimal(28,8) ,ForexCalculateDebit decimal(28,8),ForexCalculateCredit decimal(28,8),ForexCalculateDebitBalance decimal(28,8),ForexCalculateCreditBalance decimal(28,8) ,InflowQty decimal(28,8),OutflowQty decimal(28,8)) insert into #GLReceiptBalanceTmp (CompanyId,AccountId,AccountCode,AccountName,Debit,Credit,DebitBalance,CreditBalance,ForexDebit,ForexCredit,ForexDebitBalance,ForexCreditBalance ,ForexCalculateDebit,ForexCalculateCredit,ForexCalculateDebitBalance,ForexCalculateCreditBalance,InflowQty,OutflowQty) select A.CompanyId,A.RecId AccountId,A.AccountCode AccountCode,A.AccountName AccountName,isnull(sum(AR.Debit),0) Debit,0 Credit ,case when isnull(sum(AR.Debit),0)>isnull(sum(AR.Credit),0) then round((isnull(sum(AR.Debit),0)-isnull(sum(AR.Credit),0)),2) else 0 end DebitBalance ,case when isnull(sum(AR.Debit),0)<isnull(sum(AR.Credit),0) then round((isnull(sum(AR.Credit),0)-isnull(sum(AR.Debit),0)),2) else 0 end CreditBalance ,isnull(sum(AR.ForexAmount),0)ForexDebit,0 ForexCredit,isnull(sum(AR.ForexAmount),0)ForexDebitBalance,0 ForexCreditBalance ,0 ForexCalculateDebit,0 ForexCalculateCredit,0 ForexCalculateDebitBalance,0 ForexCalculateCreditBalance ,isnull(sum(AR.Quantity),0)InflowQty,0 OutflowQty from Erp_GLAccount A with (nolock) inner join Erp_GLReceiptItem AR with (nolock) on (A.RecId=AR.AccountId) left join Erp_GLReceipt ARB with (nolock) on (ARB.RecId=AR.GLReceiptId) left join Erp_CostCenter CC with (nolock) on (CC.RecId=AR.CostCenterId) left join Erp_Project P with (nolock) on (P.RecId=AR.ProjectId) where A.CompanyId = 5 and (A.IsDeleted is null or A.IsDeleted = 0) and (AR.IsDeleted is null or AR.IsDeleted = 0) and AR.Debit <> 0 and isnull(AR.ReceiptType,0) in (1 , 2 , 3 , 4 , 5) and AR.ReceiptDate between @0ARErp_GLReceiptItemReceiptDate1 and @0ARErp_GLReceiptItemReceiptDate2 group by A.CompanyId,A.RecId,A.AccountCode,A.AccountName
union all select A.CompanyId,A.RecId AccountId,A.AccountCode AccountCode,A.AccountName AccountName,0 Debit,isnull(sum(AR.Credit),0) Credit ,case when isnull(sum(AR.Debit),0)>isnull(sum(AR.Credit),0) then round((isnull(sum(AR.Debit),0)-isnull(sum(AR.Credit),0)),2) else 0 end DebitBalance ,case when isnull(sum(AR.Debit),0)<isnull(sum(AR.Credit),0) then round((isnull(sum(AR.Credit),0)-isnull(sum(AR.Debit),0)),2) else 0 end CreditBalance ,0 ForexDebit,isnull(sum(AR.ForexAmount),0) ForexCredit,0 ForexDebitBalance,isnull(sum(AR.ForexAmount),0) ForexCreditBalance ,0 ForexCalculateDebit,0 ForexCalculateCredit,0 ForexCalculateDebitBalance,0 ForexCalculateCreditBalance ,0 InflowQty,isnull(sum(AR.Quantity),0) OutflowQty from Erp_GLAccount A with (nolock) inner join Erp_GLReceiptItem AR with (nolock) on (A.RecId=AR.AccountId) left join Erp_GLReceipt ARB with (nolock) on (ARB.RecId=AR.GLReceiptId) left join Erp_CostCenter CC with (nolock) on (CC.RecId=AR.CostCenterId) left join Erp_Project P with (nolock) on (P.RecId=AR.ProjectId) where A.CompanyId = 5 and (A.IsDeleted is null or A.IsDeleted = 0) and (AR.IsDeleted is null or AR.IsDeleted = 0) and AR.Credit <> 0 and isnull(AR.ReceiptType,0) in (1 , 2 , 3 , 4 , 5) and AR.ReceiptDate between @0ARErp_GLReceiptItemReceiptDate1 and @0ARErp_GLReceiptItemReceiptDate2 group by A.CompanyId,A.RecId,A.AccountCode,A.AccountName if object_id(''tempdb..#GLAccountBalanceTmp'') is not null drop table #GLAccountBalanceTmp create table #GLAccountBalanceTmp ( CompanyId int,AccountId int, AccountCode nvarchar(25) collate database_default, AccountName nvarchar(50) collate database_default ,Debit decimal(28,8),Credit decimal(28,8),DebitBalance decimal(28,8),CreditBalance decimal(28,8) ,DBalance decimal(28,8),CBalance decimal(28,8),ForexDebit decimal(28,8),ForexCredit decimal(28,8) ,ForexDebitBalance decimal(28,8),ForexCreditBalance decimal(28,8),FDBalance decimal(28,8),FCBalance decimal(28,8) ,ForexCalculateDebit decimal(28,8),ForexCalculateCredit decimal(28,8) ,ForexCalculateDebitBalance decimal(28,8),ForexCalculateCreditBalance decimal(28,8),FCDBalance decimal(28,8),FCCBalance decimal(28,8) ,InflowQty decimal(28,8),OutflowQty decimal(28,8)) insert into #GLAccountBalanceTmp (CompanyId,AccountId,AccountCode,AccountName,Debit,Credit,DebitBalance,CreditBalance,DBalance,CBalance,ForexDebit,ForexCredit ,ForexDebitBalance,ForexCreditBalance,FDBalance,FCBalance,ForexCalculateDebit,ForexCalculateCredit,ForexCalculateDebitBalance,ForexCalculateCreditBalance ,FCDBalance,FCCBalance,InflowQty,OutflowQty) select CompanyId,AccountId,AccountCode,AccountName,isnull(sum(Debit),0)Debit,isnull(sum(Credit),0)Credit,isnull(sum(DebitBalance),0)DebitBalance,isnull(sum(CreditBalance),0)CreditBalance ,case when isnull(sum(DebitBalance),0)>isnull(sum(CreditBalance),0) then round(isnull(sum(DebitBalance),0)-isnull(sum(CreditBalance),0),2) else 0 end DBalance ,case when isnull(sum(DebitBalance),0)<isnull(sum(CreditBalance),0) then round(isnull(sum(CreditBalance),0)-isnull(sum(DebitBalance),0),2) else 0 end CBalance ,isnull(sum(ForexDebit),0)ForexDebit,isnull(sum(ForexCredit),0)ForexCredit,isnull(sum(ForexDebitBalance),0)ForexDebitBalance,isnull(sum(ForexCreditBalance),0)ForexCreditBalance ,case when isnull(sum(ForexDebitBalance),0)>isnull(sum(ForexCreditBalance),0) then round(isnull(sum(ForexDebitBalance),0)-isnull(sum(ForexCreditBalance),0),2) else 0 end FDBalance ,case when isnull(sum(ForexDebitBalance),0)<isnull(sum(ForexCreditBalance),0) then round(isnull(sum(ForexCreditBalance),0)-isnull(sum(ForexDebitBalance),0),2) else 0 end FCBalance ,isnull(sum(ForexCalculateDebit),0)ForexCalculateDebit,isnull(sum(ForexCalculateCredit),0)ForexCalculateCredit ,isnull(sum(ForexCalculateDebitBalance),0)ForexCalculateDebitBalance,isnull(sum(ForexCalculateCreditBalance),0)ForexCalculateCreditBalance ,case when isnull(sum(ForexCalculateDebitBalance),0)>isnull(sum(ForexCalculateCreditBalance),0) then round(isnull(sum(ForexCalculateDebitBalance),0)-isnull(sum(ForexCalculateCreditBalance),0),2) else 0 end FCDBalance ,case when isnull(sum(ForexCalculateDebitBalance),0)<isnull(sum(ForexCalculateCreditBalance),0) then round(isnull(sum(ForexCalculateCreditBalance),0)-isnull(sum(ForexCalculateDebitBalance),0),2) else 0 end FCCBalance ,isnull(sum(InflowQty),0)InflowQty,isnull(sum(OutflowQty),0)OutflowQty from #GLReceiptBalanceTmp group by CompanyId,AccountId,AccountCode,AccountName having round(isnull(sum(Debit),0),2) <> round(isnull(sum(Credit),0),2) select A.CompanyId,'''' [Şirket],isnull((select MF.ForexCode from Meta_Forex MF where MF.RecId=A.ForexId),'''') [Dvz],'''' [HDvz],A.AccountCode [Hesap Kodu],A.AccountName [Hesap Adı],A.SpecialCode [Özel Kod],0.0 [Devir Borç],0.0 [Devir Alacak],sum(isnull(B.Debit,0)) [Borç],sum(isnull(B.Credit,0)) [Alacak],case when sum(isnull(B.DBalance,0)) > sum(isnull(B.CBalance,0)) then sum(isnull(B.DBalance,0)) - sum(isnull(B.CBalance,0)) when sum(isnull(B.DBalance,0)) < sum(isnull(B.CBalance,0)) then sum(isnull(B.CBalance,0)) - sum(isnull(B.DBalance,0)) else 0 end [Bakiye],case when sum(isnull(B.DBalance,0)) > sum(isnull(B.CBalance,0)) then ''BB'' when sum(isnull(B.DBalance,0)) < sum(isnull(B.CBalance,0)) then ''AB'' else '''' end [Bakiye Tipi],sum(isnull(B.DBalance,0)) [Borç Bakiye],sum(isnull(B.CBalance,0)) [Alacak Bakiye],sum(isnull(B.ForexDebit,0)) [Döviz Borç],sum(isnull(B.ForexCredit,0)) [Döviz Alacak],case when sum(isnull(B.FDBalance,0)) > sum(isnull(B.FCBalance,0)) then round(sum(isnull(B.FDBalance,0)) - sum(isnull(B.FCBalance,0)),2) when sum(isnull(B.FDBalance,0)) < sum(isnull(B.FCBalance,0)) then round(sum(isnull(B.FCBalance,0)) - sum(isnull(B.FDBalance,0)),2) else 0 end [Döviz Bakiye],case when sum(isnull(B.FDBalance,0)) > sum(isnull(B.FCBalance,0)) then ''BB'' when sum(isnull(B.FDBalance,0)) < sum(isnull(B.FCBalance,0)) then ''AB'' else '''' end [Döviz Bakiye Tipi],sum(isnull(B.FDBalance,0)) [Döviz Borç Bakiye],sum(isnull(B.FCBalance,0)) [Döviz Alacak Bakiye],sum(isnull(B.ForexCalculateDebit,0)) [Hesaplanan Döviz Borç],sum(isnull(B.ForexCalculateCredit,0)) [Hesaplanan Döviz Alacak],case when sum(isnull(B.FCDBalance,0)) > sum(isnull(B.FCCBalance,0)) then round(sum(isnull(B.FCDBalance,0)) - sum(isnull(B.FCCBalance,0)),2)when sum(isnull(B.FCDBalance,0)) < sum(isnull(B.FCCBalance,0)) then round(sum(isnull(B.FCCBalance,0)) - sum(isnull(B.FCDBalance,0)),2) else 0 end [Hesaplanan Döviz Bakiye],case when sum(isnull(B.FCDBalance,0)) > sum(isnull(B.FCCBalance,0)) then ''BB'' when sum(isnull(B.FCDBalance,0)) < sum(isnull(B.FCCBalance,0)) then ''AB'' else '''' end [Hesaplanan Döviz Bakiye Tipi],sum(isnull(B.FCDBalance,0)) [Hesaplanan Döviz Borç Bakiye],sum(isnull(B.FCCBalance,0)) [Hesaplanan Döviz Alacak Bakiye],sum(isnull(B.InflowQty,0)) [Giriş Miktarı],sum(isnull(B.OutflowQty,0)) [Çıkış Miktarı],sum(isnull(B.InflowQty,0)) - sum(isnull(B.OutflowQty,0)) [Kalan],-1 CAccount from Erp_GLAccount A with (nolock) left join #GLAccountBalanceTmp B on (B.AccountId in(select AA.RecId from Erp_GLAccount AA where AA.CompanyId=A.CompanyId and AA.AccountCode like rtrim(A.AccountCode)+''%'' )) where A.CompanyId = 5 and (A.IsDeleted is null or A.IsDeleted = 0) group by A.CompanyId,A.ForexId,A.AccountCode,A.AccountName,A.SpecialCode having round(isnull(sum(B.Debit),0),2) <> round(isnull(sum(B.Credit),0),2) order by A.AccountCode

if object_id(''tempdb..#GLReceiptTmp'') is not null drop table #GLReceiptTmp if object_id(''tempdb..#GLReceiptBalanceTmp'') is not null drop table #GLReceiptBalanceTmp if object_id(''tempdb..#GLAccountBalanceTmp'') is not null drop table #GLAccountBalanceTmp ',N'@0ARErp_GLReceiptItemReceiptDate1 datetime,@0ARErp_GLReceiptItemReceiptDate2 datetime',@0ARErp_GLReceiptItemReceiptDate1='2017-01-01 00:00:00',@0ARErp_GLReceiptItemReceiptDate2='2018-12-31 23:59:00'

snt v6 cr

sentez v6 cr
önce sentezin yüklü olduğu pcde VolumeSerial.exe çalıştırıp serialnumberi bir yere not et ör: B43D-9414. ve d sürücüsünün adı ornegin sentez se onuda not et ve sentez.prm yi kopyala

daha sonra kendi pcnden VolumeSerial.exe yönetici olarak calıstır ve new numbera yaz : B43D9414 ok de

daha sonra sürücünün adı lisanslı pcde neyse onu yap d yi

Sentez live dev replikasyon

port 1347 - serverdede clienttede internet sağlayıcılarından statik ip talep etmeleri gerekir. server ve client iç iplerine 1347 portunu yönlendirmeleri gerekir ve server iç ipleri statik olması gerekir...