working on it ...

Filters

Explore Public Snippets

Sort by

Found 9,510 snippets

    public by simonwalker modified 8 hours ago  12  0  3  0

    COMING SOON & MAINTENANCE MODE for Magento 2

    Magento 2 Maintenance Mode and Coming Soon Page extension help you to preserve the interest of your visitors when your Website is going through maintenance. 
    You can enable Email subscription form on Coming Soon & Maintenance Mode, also you can add Social Media Links to engage your visitors. 
    
    Key Features
    
    1.	3 Website Modes- Live, Coming Soon, Maintenance Mode
    2.	Enable Coming Soon Page with User Sign-Up Form
    3.	Activate Maintenance Mode with Countdown Timer
    4.	Add Media to Coming Soon & Maintenance  Mode Pages
    5.	White-List Website Traffic with Respect to IP Addresses
    6.	Display Social Links to Keep Customers Engaged
    7.	Option to Allow Visitors to Access CMS Pages
    
    
    Complete Detail & Demo - https://marketplace.magento.com/fme-custommaintenancepage.html

    public by simonwalker modified 9 hours ago  11  0  3  1

    CUSTOM REGISTRATION FIELDS for Magento 2

    // Enter here the actual content of the snippet.						
    Magento 2 Custom Registration Form Field is a feature-rich extension which allows you to add extra fields to the Sign-up form of your Website.
    You can add additional fields in just a few easy steps and also set them to mandatory or optional.
    You can add up-to 13 types of custom fields.
    •	Text Field
    •	Text Area
    •	File Upload
    •	Image Upload
    •	Date
    •	Drop Down
    •	Multiple Select
    •	Yes/No option
    •	Radio
    •	Checkboxes
    •	Text Editor
    •	Audio Upload
    •	Video Upload
    You can make fields non-editable once user entered the data. In this way you can prevent customers change their data after registration.
    
    Key Features
    1.	Add Unlimited Custom Fields to Registration Page
    2.	Position & Sort Fields Anywhere on Registration Form
    3.	Add Multiple-Level Dependable Fields
    4.	Make Fields Mandatory or Optional
    5.	Configure Data Input Validation for Fields
    6.	Show/Hide New Field in Registration Email & My Account
    7.	Restrict Additional Fields By Store Views
    8.	Make Field Non-Editable Once Data I Entered
    
    
    More Feature Visit- https://marketplace.magento.com/fme-additional-customer-attributes.html
    

    public by ZeeRQ modified Mar 15, 2019  29  1  2  0

    ULTIMATE SEO OPTIMIZER for Magento 2

    // 	ULTIMATE SEO OPTIMIZER for Magento 2
    Magento 2 Ultimate SEO Optimizer extension is all in one pack of seven SEO Extensions for your store that significantly reduces your search optimization work load and cost. This Magento 2 SEO extension gives you a combination of 7 powerful tools that automate your SEO tasks such as creating:
     (1) SEO Meta tags
     (2) Image Alt tags
     (3) Rich Snippets
     (4) Sitemap
     (5) No-Follow No-Index tags
     (6) Canonical Tags
     (7) Multilingual Hreflang tags.
     This makes your online presence SEO equipped and improves your online rankings on SERPs.
     
    Key Features:
    •	Add Extended Google Rich Snippet Tags
    •	Handle Content Language Duplicates with Hreflang Tags
    •	Add No Index No Follow Tags to Any Page
    •	Add Canonical Tags to Prevent Duplication
    •	Auto-create SEO Meta Title, Description & Keywords
    •	Generate SEO Optimized Alt Tags for Product Images
    •	Build XML & HTML Sitemaps for Store
    
    To explore more about SEO Extension For Magento 2 visit following URL
    https://www.fmeextensions.com/seo-extension-for-magento-2.html
    

    public by sjschmalfeld modified Feb 1, 2019  590  3  4  0

    SQL Duplicates

    ;WITH cte AS
    (SELECT *, ROW_NUMBER() OVER (PARTITION BY col1, col2, col3, col4 ORDER BY (SELECT 0)) AS DuplicateRowNumber
        FROM table
    )
    SELECT * FROM cte WHERE DuplicateRowNumber > 1
    
    
    or----
    
    ;WITH cte as
    (SELECT PEOPLE.*, Loan.LoanID, ROW_NUMBER() OVER (PARTITION BY SocialSecurityNo ORDER BY SocialSecurityNo) AS DuplicateRowNumber
    FROM people INNER JOIN LOAN ON FK_PeopleID=PeopleID WHERE ISNULL(SocialSecurityNo,'') <> '' AND SocialSecurityNo <> '--' AND SocialSecurityNo <> '000-00-0000' AND loan.Status='active' )
    
    SELECT * INTO #TEMP99 FROM CTE WHERE cte.DuplicateRowNumber > 1
    
    SELECT *,b.SocialSecurityNo FROM dbo.Loan 
    	INNER JOIN (SELECT PeopleID,SocialSecurityNo FROM PEOPLE WHERE SocialSecurityNo	 
    							IN (SELECT SocialSecurityNo FROM #temp99)) b 
    	ON B.PeopleID=LOAN.FK_PeopleID
    	WHERE LOAN.Status='ACTIVE'
    
    DROP TABLE #TEMP99  
    
    
    -- Another way
    	--GET RID OF #NewAddressCandidates ADDESSES ALEADY IN THE ADDRESS TABLE
    	DELETE FROM #NewAddressCandidates WHERE EXISTS (
    	SELECT t.[Address1] 
    				,t.Address2
    				,t.City
    				,t.[State]
    				,SUBSTRING(t.Zip,1,5) AS ZIP, 
    				SUBSTRING(t.Zip,7,4) AS ZIP4 
    		FROM #NewAddressCandidates T 
    			INTERSECT  
    		SELECT [Address1] ,[Address2],[City],[State],[Zip],ZIP4 FROM dbo.[Address])				
    		
    		
    -- Another way
    	;WITH NODUP AS 
    		(SELECT  A.ADDRESS1,A.ADDRESS2,A.CITY,A.STATE,A.ZIP,A.ZIP4
    			  , row_number() OVER ( PARTITION BY  A.ADDRESS1,A.ADDRESS2,A.CITY,A.STATE,A.ZIP,A.ZIP4 ORDER BY  A.ADDRESS1,A.ADDRESS2,A.CITY,A.STATE,A.ZIP,A.ZIP4 ) AS nr
    		FROM    #NewAddressCandidates A)
    	DELETE FROM NODUP WHERE NR > 1;	
    	
    	SELECT * INTO  #UniqueNewAddresses  FROM #NewAddressCandidates WHERE EXISTS (
    	SELECT t.[Address1] 
    				,t.Address2
    				,t.City
    				,t.[State]
    				,SUBSTRING(t.Zip,1,5) AS ZIP, 
    				SUBSTRING(t.Zip,7,4) AS ZIP4 			
    		FROM #NewAddressCandidates T 
    			EXCEPT 
    		SELECT [Address1] ,[Address2],[City],[State],[Zip],ZIP4 FROM dbo.[Address])
    	
    	// Now to remove the duplicate rows, use the same table and use EXCEPT operator with an 
    	// empty result set returned by the same table	
    	// USING except operator	
    	SELECT col1,col2
      FROM DuplicateRcordTable
      EXCEPT
      SELECT col1,col2
      FROM DuplicateRcordTable WHERE 1=0
    																				

    public by DinhoPutz modified Jan 30, 2019  47  2  3  0

    Função para converter minutos para horas (SQL Oracle)

    PLSQL - SQL Oracle
    -- Criando nova função
    create or replace function converter (
        numero in  number 
    ) return varchar2
    is
        minutos varchar2(10);
    begin
        
    return 
    
    	case length 
        
         (case instr((numero / 60), '.')  
            when 2 then '0'  || substr((numero / 60), 1 ,1)
            when 3 then substr((numero / 60), 1 ,2)
        else to_char(numero / 60)
        end || '.' || lpad(mod(numero, 60), 2, 0))  
    	
    			when 4 then '0' || 
    			case instr((numero / 60), '.')  
    			when 2 then '0'  || substr((numero / 60), 1 ,1)
    			when 3 then substr((numero / 60), 1 ,2)
    		else to_char(numero / 60)
        end || '.' || lpad(mod(numero, 60), 2, 0) 
       
       else 
    		 case instr((numero / 60), '.')  
    			when 2 then '0'  || substr((numero / 60), 1 ,1)
    			when 3 then substr((numero / 60), 1 ,2)
    		else to_char(numero / 60)
        end || '.' || lpad(mod(numero, 60), 2, 0)   -- temos os minutos
       
       end ;
        
    end converter;
    /
    
    
    select  converter(valor), valor as valors from horario where  valor is not null

    public by DinhoPutz modified Jan 30, 2019  48  0  3  0

    Como obter o espaço em disco ocupado por cada tabela do Banco de Dados

    Como obter o espaço em disco ocupado por cada tabela do Banco de Dados O código abaixo retorno espaço em disco ocupado por cada tabela do banco de dados em em execução.
    SELECT
        t.NAME AS Entidade,
        p.rows AS Registros,
        SUM(a.total_pages) * 8 AS EspacoTotalKB,
        SUM(a.used_pages) * 8 AS EspacoUsadoKB,
        (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS EspacoNaoUsadoKB
    FROM
        sys.tables t
    INNER JOIN
        sys.indexes i ON t.OBJECT_ID = i.object_id
    INNER JOIN
        sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
    INNER JOIN
        sys.allocation_units a ON p.partition_id = a.container_id
    LEFT OUTER JOIN
        sys.schemas s ON t.schema_id = s.schema_id
    WHERE
        t.NAME NOT LIKE 'dt%'
        AND t.is_ms_shipped = 0
        AND i.OBJECT_ID > 25
        AND P.rows > 0
    --     and t.NAME like 'PEC_pre%'
    GROUP BY
        t.Name, s.Name, p.Rows
    ORDER BY
        EspacoTotalKB DESC

    public by DinhoPutz modified Jan 30, 2019  50  3  3  0

    Verificar origem de eventos contábeis (Totvs RM)

    Verificar origem de eventos contábeis (Totvs RM), a partir de qual sistema foram gerados. Basicamente ele faz uma busca no banco de dados SQL para verificar onde foi feito o lançamento contábil.
    SELECT T.CODEVENTO, 
    T.NOME,
    C.NUMEROINTERNO,
    C.DESCRICAO,
    ISNULL(C.CODCONTA, 'Default'),
    C.CODFRM,
    -- Converter código para nomes
    Case when T.CODAPLIC = 'F' THEN 'Financeiro'
    	when T.CODAPLIC = 'T' THEN 'Nucleus'
    	when T.CODAPLIC = 'P' THEN 'Folha de Pagamento'
    	when T.CODAPLIC = 'D' THEN 'Fiscal'
    	when T.CODAPLIC = 'I' THEN 'Patrimônio'
    	when T.CODAPLIC = 'X' THEN 'SGI - Incorporação'
    	when T.CODAPLIC = 'S' THEN 'Classis - Educacional'
    	ELSE 'Desconhecido' END
    	
    	-- Tabela de eventos contábeis
    	FROM         TEVENTOSCONT T INNER
    	
    	-- Tabela de Itens do Evento Contábil
    	JOIN         TITMEVC C ON T.CODCOLIGADA = C.CODCOLIGADA
    	AND T.CODEVENTO = C.CODEVENTO;
    												

    public by DinhoPutz modified Aug 14, 2018  403  0  3  0

    Remover caracteres especiais e quebra-linhas de um resultado em uma tabela

    Substituir o texto, na verdade, por outra coisa, seja por nada ou por um espaço vazio, talvez. Ideal para resolver aqueles problema na exportação de um resultado para CSV para deve ser aberto no Excel e aquele maldito ponto e vírgula (;) acaba levando parte do texto para outra coluna. Aqui também removemos tabulações, quebralinhas e outros.
    SELECT
    REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(nomeDaColuna,CHAR(13) + Char(10) ,''), CHAR(10), ''), CHAR(13), ''), CHAR(9), ''),';','-'),'  ', ' ') as 'Um nome novo e legal' 
    FROM NOMEDATABELA

    public by MuhammadAkbar modified Nov 16, 2017  194  7  3  0

    How to See/Hack saved Passwoods in Chrome

    			Many of people do not know and they do not care about own browser privacy . alot of people when they Sign up on any site and Chrome ask for save Passwords and people save passwords . actually they Do not know where their Password saved and anyone can easilly access their passwords they have saved in Chrome browser.so Today i will tell you how you can See saved passwords in Chrome and you can See/Hack saved Passwoods in Chrome. its is so easy
    
    steps. so lets start Now See/Hack saved Passwoods in ChromeView-Saved-Passwords-Chrome
    
    
    Steps below to View saves password In chrome Brower
    
                                              1: Open Chrome Brower
    
    
                                         2: Then paste this on Chrome brower
    
    "chrome://settings/passwords"
    
    when you will enter in Chrome it will be show like this 
    
    11
    
     
    
    Now Click on Any Tab it will show like this
    
    11 (1)
    
    
    when you Click on Show Button it will show the Save password in chrome
    
    you can see all password save in Chrome like this i hope this toturial will help you to find Hidden password in chrome if you need any help you and Comment below i will reply instant about See/Hack saved Passwoods in Chrome.
    						
    					http://www.watchmoviesonlineclub.com	
    					https://www.apkcheap.com
    					https://apkmirrorapp.com

    public by sjschmalfeld modified Nov 8, 2017  296  1  4  0

    Getting Min or Max value without aggregates

    SQL Server Transact SQL
    // Enter here the actual content of the snippet.
    // Select max value without using MAX()
    
    //Version 1
    SELECT *
      FROM SO.dbo.MaxNoAgg mna1
    LEFT JOIN SO.dbo.MaxNoAgg mna2 ON (mna2.salary > mna1.salary)
    WHERE mna2.mna_id IS NULL;
    
    //version 2
    SELECT age
    FROM Owner o1
    WHERE NOT EXISTS (SELECT 1 FROM Owner o2 WHERE o2.age > o1.age)            						
    • Public Snippets
    • Channels Snippets