Blog Of Sem: October 2019

LOGO OBJECTS EXPORT TO XML

UnityObjects.Data OF = M.NewObjectData(UnityObjects.DataObjectType.doSalesOrderSlip);
....

string FISNO = DateTime.Now.ToString("yyyyMMddHHmmss").ToString();
EMF.ExportToXML("GL_VOUCHERS", "C:/Users/PC/Desktop/devr/" + FISNO + ".xml");
if (!OF.Post())
....


"SALES_ORDER" = XML OLARAK LOGODAN KAYDEDİNCE EN ÜSTTTE XMLİN ALTINDAKİDİR

LOGO J-PLATFORM İŞLEMLERİ

C:\LOGO\J-GUAR\SELFSERVIS\UniServer\www\HrSelfService\app\View\Themed\MainTheme\Users\login.ctp

şifremi unutummu sil : 
----------------------
<div class="row">
<a id="forgotPasswordLink" href="#forgotSection"><?php echo $resLib::getLocalStrRes($formResDomain, 7, "Şifremi Unuttum")?></a>
</div>


sosyal medyaları sil : 
----------------------
<div id="socialWidgets">
<?php if (!empty($configParam)){?>
<a target="_blank" href="<?php echo $configParam->facebookAddress?>">
<i class="lbs-icon lbs-icon-facebook lbs-icon-bg lbs-icon-2x"></i>
</a>
<a target="_blank" href="<?php echo $configParam->twitterAddress?>">
<i class="lbs-icon lbs-icon-twitter lbs-icon-bg lbs-icon-2x"></i>
</a>
<a target="_blank" href="<?php echo $configParam->linkedinAddress?>">
<i class="lbs-icon lbs-icon-linkedin lbs-icon-bg lbs-icon-2x"></i>
</a>
<?php
}
else {?>
<a target="_blank" href="http://www.facebook.com/logoyazilim">
<i class="lbs-icon lbs-icon-facebook lbs-icon-bg lbs-icon-2x"></i>
</a>
<a target="_blank" href="http://twitter.com/logo_bs">
<i class="lbs-icon lbs-icon-twitter lbs-icon-bg lbs-icon-2x"></i>
</a>
<a target="_blank" href="http://www.linkedin.com/company/13830">
<i class="lbs-icon lbs-icon-linkedin lbs-icon-bg lbs-icon-2x"></i>
</a>
<?php } ?>
</div>

logoyu sil (değiştirebilirsinde ama <img src="data:image/png;base64,resimkodu?> olmalı: 
------------
<?=$this->element('firmInfo', array('classes' => 'row'))?>

LOGO YANSITMA ŞABLONU QUERYISI

DECLARE @GIDER_BASL_HESAP_KODU VARCHAR(50), @GIDER_BITIS_HESAP_KODU VARCHAR(50), @GIDER_HESAP_KODU VARCHAR(50), @GIDER_YANSITMA_HESAP_KODU VARCHAR(50), @GELIR_YANSITMA_HESAP_KODU VARCHAR(50), @TARIH_BASL VARCHAR(50), @TARIH_BITIS VARCHAR(50), @FIRMNR VARCHAR(3),
@ACIKLAMA_YANSITMA1  VARCHAR(150),@ACIKLAMA_YANSITMA2  VARCHAR(150),@ACIKLAMA_GELIRLERIKAPAT   VARCHAR(150),@ACIKLAMA_GIDERLERIKAPAT    VARCHAR(150)
SET @FIRMNR='212';
SET @GIDER_HESAP_KODU = '690.01.01.000'
SET @GIDER_BASL_HESAP_KODU='720.01.01.001'
SET @GIDER_BITIS_HESAP_KODU='720.01.01.002'
SET @GIDER_YANSITMA_HESAP_KODU = '721.01.01.001'
SET @GELIR_YANSITMA_HESAP_KODU = '620.01.01.001'
SET @TARIH_BASL= '1-1-2018'
SET @TARIH_BITIS='12-31-2018'
SET @ACIKLAMA_YANSITMA1='24.10.2019 tarihli dönem içi yansıtma kaydı';
SET @ACIKLAMA_YANSITMA2='24.10.2019 tarihli dönem sonu yansıtma kaydı';
SET @ACIKLAMA_GELIRLERIKAPAT='24.10.2019 Tarihli Gelir Kapatma Kaydı';
SET @ACIKLAMA_GIDERLERIKAPAT='24.10.2019 Tarihli Gider Kapatma Kaydı';
--YANSITMA1
SELECT * FROM (
SELECT *
FROM
(
    SELECT '1-YANSITMA1' TUR,
           @GELIR_YANSITMA_HESAP_KODU BORC_HESAP,
@GIDER_YANSITMA_HESAP_KODU  ALACAK_HESAP,@ACIKLAMA_YANSITMA1 ACIKLAMA,
           BRANCH ISYERINR,
           (
               SELECT NAME FROM L_CAPIDIV D WHERE D.NR = GLTRN.BRANCH AND D.FIRMNR = @FIRMNR
           ) ISYERI,
           GLTRN.TRCURR,
           CONVERT(DECIMAL(10, 2), SUM(GLTRN.DEBIT)) DEBIT,
           CONVERT(DECIMAL(10, 2), SUM(GLTRN.CREDIT)) CREDIT,
           CONVERT(DECIMAL(10, 2), SUM(GLTRN.REPORTNET * (1 - 2 * GLTRN.SIGN))) REPORTNET,
           CONVERT(DECIMAL(10, 2), SUM(GLTRN.TRNET * (1 - 2 * GLTRN.SIGN))) TRNET_TUTAR,   CONVERT(DECIMAL(10, 2), SUM(GLTRN.TRNET * (1 - 2 * GLTRN.SIGN))) SON
    FROM LG_212_01_EMFLINE GLTRN WITH (NOLOCK)
    WHERE (GLTRN.DATE_ >= CONVERT(DATETIME, @TARIH_BASL, 101))
          AND (GLTRN.DATE_ <= CONVERT(DATETIME, @TARIH_BITIS, 101))
          AND (GLTRN.CANCELLED = 0)
          AND (GLTRN.TRCODE NOT IN ( 5 ))
          AND --
        ACCOUNTCODE
          BETWEEN @GIDER_BASL_HESAP_KODU AND @GIDER_BITIS_HESAP_KODU
    GROUP BY GLTRN.TRCURR,
             BRANCH
) AS T
WHERE T.TRNET_TUTAR <> 0
--YANSITMA2
UNION ALL
SELECT *
FROM
(
    SELECT '2-YANSITMA2' TUR,
            @GIDER_YANSITMA_HESAP_KODU BORC,
           ACCOUNTCODE ALACAK,@ACIKLAMA_YANSITMA2 ACIKLAMA,
           BRANCH ISYERINR,
           (
               SELECT NAME FROM L_CAPIDIV D WHERE D.NR = GLTRN.BRANCH AND D.FIRMNR = @FIRMNR
           ) ISYERI,
           GLTRN.TRCURR,
           CONVERT(DECIMAL(10, 2), SUM(GLTRN.DEBIT)) DEBIT,
           CONVERT(DECIMAL(10, 2), SUM(GLTRN.CREDIT)) CREDIT,
           CONVERT(DECIMAL(10, 2), SUM(GLTRN.REPORTNET * (1 - 2 * GLTRN.SIGN))) REPORTNET,
           CONVERT(DECIMAL(10, 2), SUM(GLTRN.TRNET * (1 - 2 * GLTRN.SIGN))) TRNET_TUTAR,   CONVERT(DECIMAL(10, 2), SUM(GLTRN.TRNET * (1 - 2 * GLTRN.SIGN))) SON
    FROM LG_212_01_EMFLINE GLTRN WITH (NOLOCK)
    WHERE (GLTRN.DATE_ >= CONVERT(DATETIME,@TARIH_BASL, 101))
          AND (GLTRN.DATE_ <= CONVERT(DATETIME,@TARIH_BITIS, 101))
          AND (GLTRN.CANCELLED = 0)
          AND (GLTRN.TRCODE NOT IN ( 5 ))
          AND --
        ACCOUNTCODE
         BETWEEN @GIDER_BASL_HESAP_KODU AND @GIDER_BITIS_HESAP_KODU
    GROUP BY GLTRN.TRCURR,ACCOUNTCODE,BRANCH
) AS T
WHERE T.TRNET_TUTAR <> 0
--GELİRLERİ KAPAT
UNION ALL
SELECT  * from (
SELECT *
FROM
(
    SELECT '3-GELİRLERİ KAPAT' TUR,
            @GIDER_HESAP_KODU BORC,
           ACCOUNTCODE ALACAK,@ACIKLAMA_GELIRLERIKAPAT ACIKLAMA,
           BRANCH ISYERINR,
           (
               SELECT NAME FROM L_CAPIDIV D WHERE D.NR = GLTRN.BRANCH AND D.FIRMNR = @FIRMNR
           ) ISYERI,
           GLTRN.TRCURR,
           CONVERT(DECIMAL(10, 2), SUM(GLTRN.DEBIT)) DEBIT,
           CONVERT(DECIMAL(10, 2), SUM(GLTRN.CREDIT)) CREDIT,
           CONVERT(DECIMAL(10, 2), SUM(GLTRN.REPORTNET * (1 - 2 * GLTRN.SIGN))) REPORTNET,
           CONVERT(DECIMAL(10, 2), SUM(GLTRN.TRNET * (1 - 2 * GLTRN.SIGN))) TRNET_TUTAR,
    CONVERT(DECIMAL(10, 2), SUM(GLTRN.DEBIT))- CONVERT(DECIMAL(10, 2), SUM(GLTRN.CREDIT)) SON
    FROM LG_212_01_EMFLINE GLTRN WITH (NOLOCK)
    WHERE (GLTRN.DATE_ >= CONVERT(DATETIME,@TARIH_BASL, 101))
          AND (GLTRN.DATE_ <= CONVERT(DATETIME, @TARIH_BITIS, 101))
          AND (GLTRN.CANCELLED = 0)
          AND (GLTRN.TRCODE NOT IN ( 5 ))
          AND
    (ACCOUNTCODE LIKE  LEFT(@GIDER_HESAP_KODU,1) +'%' AND ACCOUNTCODE<@GIDER_HESAP_KODU)
    GROUP BY ACCOUNTCODE,GLTRN.TRCURR,BRANCH
) AS T
WHERE
 (DEBIT-CREDIT>0)  ) AS T2    WHERE SON>0
--GIDERLERİ KAPAT
UNION ALL
SELECT  * from ( 
SELECT *
FROM
(
    SELECT '4-GIDERLERİ KAPAT' TUR,
            ACCOUNTCODE   BORC,
           @GIDER_HESAP_KODU  ALACAK,@ACIKLAMA_GIDERLERIKAPAT ACIKLAMA,
           BRANCH ISYERINR,
           (
               SELECT NAME FROM L_CAPIDIV D WHERE D.NR = GLTRN.BRANCH AND D.FIRMNR = @FIRMNR
           ) ISYERI,
           GLTRN.TRCURR,
           CONVERT(DECIMAL(10, 2), SUM(GLTRN.DEBIT)) DEBIT,
           CONVERT(DECIMAL(10, 2), SUM(GLTRN.CREDIT)) CREDIT,
           ABS(CONVERT(DECIMAL(10, 2), SUM(GLTRN.REPORTNET * (1 - 2 * GLTRN.SIGN)))) REPORTNET,
           ABS(CONVERT(DECIMAL(10, 2), SUM(GLTRN.TRNET * (1 - 2 * GLTRN.SIGN)))) TRNET_TUTAR,
   CONVERT(DECIMAL(10, 2), SUM(GLTRN.CREDIT))- CONVERT(DECIMAL(10, 2), SUM(GLTRN.DEBIT)) SON
    FROM LG_212_01_EMFLINE GLTRN WITH (NOLOCK)
    WHERE (GLTRN.DATE_ >= CONVERT(DATETIME, @TARIH_BASL, 101))
          AND (GLTRN.DATE_ <= CONVERT(DATETIME,@TARIH_BITIS, 101))
          AND (GLTRN.CANCELLED = 0)
          AND (GLTRN.TRCODE NOT IN ( 5 ))
          AND --
          (ACCOUNTCODE LIKE  LEFT(@GIDER_HESAP_KODU,1) +'%' AND ACCOUNTCODE<@GIDER_HESAP_KODU)
    GROUP BY ACCOUNTCODE,GLTRN.TRCURR,BRANCH
) AS T
WHERE
T.CREDIT-T.DEBIT>0   ) AS T2   
 ) AS YANSITMASABLONU ORDER BY TUR,YANSITMASABLONU.ISYERINR,YANSITMASABLONU.TRCURR

C# BIR FORMDAN AÇIK BAŞKA BIR FORMA BILGI AKTARIMI

ÖNCELİKLE AKTARILACAK OLAN FORMDAKI CONTROLLERIN MODIFY PRIVATEDEN PUBLICE DEGISTIRILMELI.


public partial class MAINFORM : Form
    {
         SECONDFORM SF;
     }


      public MAINFORM()
{

}

        private void simpleButton1_Click(object sender, EventArgs e)
        {

            gb_UC_CONTAINER.Controls.Clear();
            UCP = new SICILLERHAREKET(M, CFG, C);
            gb_UC_CONTAINER.Controls.Add(UCP);
            UCP.Dock = DockStyle.Fill;
        }

 private void sle_PROJELER_EditValueChanged(object sender, EventArgs e)
{
  SF.te_PROJE.Text = (string)sle_PROJELER.EditValue;
}

LOGO TIGER 3 SQL AY , AMBAR VE MALZEME BAZLI STOK DURUM RAPORU

USE [LEVENT]
GO

/****** Object:  View [dbo].[BM_211_STOKAYLIK]    Script Date: 14.10.2019 17:13:13 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER view [dbo].[BM_211_STOKAYLIK] as
SELECT TOP 100 PERCENT  tarih, ambar,'0' [isyeri],
  CASE ITEMS2.CARDTYPE
               WHEN 1 THEN
                   'TICARI MAL'
               WHEN 2 THEN
                   'KARMA KOLI'
               WHEN 3 THEN
                   'DEPOZITOLU MAL'
               WHEN 4 THEN
                   'SABIT KIYMET'
               WHEN 10 THEN
                   'HAMMADDE'
               WHEN 11 THEN
                   'YARI MAMUL'
               WHEN 12 THEN
                   'MAMUL'
               WHEN 13 THEN
                   'TUKETIM MALI'
               WHEN 20 THEN
                   'GENEL MALZEME SINIFI'
               WHEN 21 THEN
                   'TABLOLU MALZEME SINIFI'
               ELSE
                   CONVERT(VARCHAR(20), CARDTYPE)
           END AS mal_tur,
ITEMS2.CODE mal_kod, ITEMS2.NAME mal_ad ,BIRIM.CODE birim ,


       ISNULL(
       (
           SELECT SUM(ONHAND)
           FROM LV_211_01_STINVTOT STINVTOT
           WHERE STINVTOT.STOCKREF = ITEMS2.LOGICALREF
                 AND STINVTOT.INVENNO = ambarnr
               --  AND STINVTOT.DATE_ <= DATEADD(MONTH, DATEDIFF(MONTH, 0, DATEADD(m, 0, tarih)), 0)
     AND  YEAR(STINVTOT.DATE_) * 100 + MONTH(STINVTOT.DATE_)<=tarih
       ),
       0
             ) stok


FROM (
SELECT DISTINCT tarih ,whouse.NR ambarnr, WHOUSE.NAME ambar,MALZEMELER.STOCKREF  FROM (
select DISTINCT  YEAR(STLINE.DATE_) * 100 + MONTH(STLINE.DATE_) tarih from LG_211_01_STLINE STLINE
WHERE YEAR(STLINE.DATE_) * 100 + MONTH(STLINE.DATE_) <=YEAR(GETDATE())*100+MONTH(GETDATE())
 ) AS T
  CROSS JOIN  L_CAPIWHOUSE WHOUSE
  CROSS JOIN  LG_211_ITEMS ITEMS
  LEFT JOIN
  (
     SELECT STLINE.STOCKREF ,   STLINE.SOURCEINDEX
         
    FROM LG_211_01_STLINE STLINE WITH (NOLOCK)
        LEFT JOIN LG_211_01_STFICHE STFIC
            ON STLINE.STFICHEREF = STFIC.LOGICALREF
    WHERE (
              (STFIC.TRCODE IN ( 2, 3, 4, 7, 8, 9, 35, 36, 37, 38, 39 ))
              OR (STFIC.CLIENTREF = 0)
              OR (STFIC.TRCODE IN ( 1, 5, 6, 10, 26, 30, 31, 32, 33, 34 ))
              OR (STFIC.CLIENTREF = 0)
              OR (STFIC.TRCODE IN ( 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 50, 51 ))
          )
          AND (STFIC.CANCELLED = 0)
          AND STLINE.LINETYPE IN ( 0, 1, 5, 6, 8, 9, 10 )
          AND
          (
              (STFIC.STATUS IN ( 0, 1 ))
              OR (STFIC.TRCODE IN ( 11, 12, 13, 14, 25, 26, 50, 51 ))
          )
          AND
          (
              (STFIC.STATUS IN ( 0, 1 ))
              OR (STFIC.TRCODE <> 25)
          )
          AND
          (
              (STFIC.PRODSTAT = 0)
              OR (STFIC.TRCODE IN ( 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 ))
          )
          AND (STFIC.DEVIR IN ( 0, 1 ))
  ) as MALZEMELER ON MALZEMELER.STOCKREF=ITEMS.LOGICALREF AND MALZEMELER.SOURCEINDEX=NR
  WHERE WHOUSE.FIRMNR=211
  --ORDER BY tarih
  ) AS T2 LEFT JOIN LG_211_ITEMS ITEMS2 ON STOCKREF=ITEMS2.LOGICALREF
    LEFT OUTER JOIN LG_211_UNITSETL BIRIM WITH (NOLOCK)
            ON BIRIM.UNITSETREF = ITEMS2.UNITSETREF
               AND BIRIM.MAINUNIT = 1
  -- where ITEMS2.CODE='ESARF-001'
   order by tarih
GO


LOGO OBJECTS REGISTERLEME TÜRLERİ

c:\Windows\SysWOW64>REGSVR32 C:\Users\Public\Documents\TIGER3ENTERPRISE\LOBJECTS.DLL