Vision Global TicketSalesScript: Difference between revisions

From Prodigix Wiki
Jump to navigation Jump to search
(Script to review then run for Vision Global Ticket sales import)
 
No edit summary
Line 1: Line 1:
------------------------------------------------------------------------------<br/>
<nowiki>------------------------------------------------------------------------------</nowiki>


--     check to verify the ticket import completed succesfully, change date to the day you run the import<br/>
--     check to verify the ticket import completed succesfully, change date to the day you run the import


------------------------------------------------------------------------------<br/>
<nowiki>------------------------------------------------------------------------------</nowiki>


(      SELECT EventCode <br/>
(      SELECT EventCode


       FROM TicketEventCodes <br/>
       FROM TicketEventCodes


       WHERE CAST(CreatedDate AS DATE) = '10/17/2022' <br/>
       WHERE CAST(CreatedDate AS DATE) = '10/17/2022'  


)
)


------------------------------------------------------------------------------ <br/>
<nowiki>------------------------------------------------------------------------------</nowiki>  


--     Change date to date of most recent ticket import <br/>
--     Change date to date of most recent ticket import


------------------------------------------------------------------------------ <br/>
<nowiki>------------------------------------------------------------------------------</nowiki>


--     check to verify no records returned in following query. If so, do not run anything below <br/>
--     check to verify no records returned in following query. If so, do not run anything below  


------------------------------------------------------------------------------ <br/>
<nowiki>------------------------------------------------------------------------------</nowiki>  


SELECT * <br/>
SELECT *  


FROM TicketSales <br/>
FROM TicketSales  


WHERE distid >= 2147483647 <br/>
WHERE distid >= 2147483647  


AND EventCode IN <br/>
AND EventCode IN  


( <br/>
(  


       SELECT EventCode <br/>
       SELECT EventCode


       FROM TicketEventCodes <br/>
       FROM TicketEventCodes  


       WHERE CAST(CreatedDate AS DATE) = CAST(getdate() as date) <br/>
       WHERE CAST(CreatedDate AS DATE) = CAST(getdate() as date)  


) <br/>
)  


------------------------------------------------------------------------------ <br/>
<nowiki>------------------------------------------------------------------------------</nowiki>  


--     Run top query and copy sponsor ids into second query <br/>
--     Run top query and copy sponsor ids into second query


------------------------------------------------------------------------------ <br/>
<nowiki>------------------------------------------------------------------------------</nowiki>  


--     Update distIDs in first query to have sponsor of current sponsor. Usually returns 3 distIDs. <br/>
--     Update distIDs in first query to have sponsor of current sponsor. Usually returns 3 distIDs.  


--     aka update sponsor of distIDs in first query to their sponsor's sponsor  <br/>
--     aka update sponsor of distIDs in first query to their sponsor's sponsor


------------------------------------------------------------------------------ <br/>
<nowiki>------------------------------------------------------------------------------</nowiki>  


select * <br/>
select *


from DistributorDetail <br/>
from DistributorDetail


where sponsorid >= 2147483647 <br/>
where sponsorid >= 2147483647  


and distid < 2147483647 <br/>
and distid < 2147483647


<br/>


select DistID, SponsorID, * <br/>
select DistID, SponsorID, *  


from distributordetail <br/>
from distributordetail  


where distid in () <br/>
where distid in ()  


<br/>


update DistributorDetail <br/>
update DistributorDetail  


set SponsorID = , UplineDID = <br/>
set SponsorID = , UplineDID =  


where distid =  <br/>
where distid =   


------------------------------------------------------------------------------ <br/>
<nowiki>------------------------------------------------------------------------------</nowiki>  


--     Run queries and change "select *" to "Delete" and run <br/>
--     Run queries and change "select *" to "Delete" and run  


------------------------------------------------------------------------------ <br/>
<nowiki>------------------------------------------------------------------------------</nowiki>


select * <br/>
select *  


from Payment <br/>
from Payment  


where orderid in <br/>
where orderid in  


(       select OrderID <br/>
(       select OrderID  


       from orders <br/>
       from orders  


       where distid >= 2147483647 <br/>
       where distid >= 2147483647


)
)


select * <br/>
select *  


from orderlines <br/>
from orderlines


where orderid in <br/>
where orderid in


(
(


       select OrderID <br/>
       select OrderID  


       from orders <br/>
       from orders


       where distid >= 2147483647 <br/>
       where distid >= 2147483647  


)
)


select * <br/>
select *  


from orders <br/>
from orders  


where distid >= 2147483647 <br/>
where distid >= 2147483647  


select * <br/>
select *  


from DistributorDetail <br/>
from DistributorDetail  


where distid >= 2147483647 <br/>
where distid >= 2147483647  


select * <br/>
select *  


from Distributor <br/>
from Distributor  


where distid >= 2147483647
where distid >= 2147483647

Revision as of 22:55, 9 March 2023

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

--     check to verify the ticket import completed succesfully, change date to the day you run the import

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

(      SELECT EventCode

       FROM TicketEventCodes

       WHERE CAST(CreatedDate AS DATE) = '10/17/2022'

)

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

--     Change date to date of most recent ticket import

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

--     check to verify no records returned in following query. If so, do not run anything below

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

SELECT *

FROM TicketSales

WHERE distid >= 2147483647

AND EventCode IN

(

       SELECT EventCode

       FROM TicketEventCodes

       WHERE CAST(CreatedDate AS DATE) = CAST(getdate() as date)

)

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

--     Run top query and copy sponsor ids into second query

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

--     Update distIDs in first query to have sponsor of current sponsor. Usually returns 3 distIDs.

--     aka update sponsor of distIDs in first query to their sponsor's sponsor

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

select *

from DistributorDetail

where sponsorid >= 2147483647

and distid < 2147483647


select DistID, SponsorID, *

from distributordetail

where distid in ()


update DistributorDetail

set SponsorID = , UplineDID =

where distid = 

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

--     Run queries and change "select *" to "Delete" and run

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

select *

from Payment

where orderid in

(       select OrderID

       from orders

       where distid >= 2147483647

)

select *

from orderlines

where orderid in

(

       select OrderID

       from orders

       where distid >= 2147483647

)

select *

from orders

where distid >= 2147483647

select *

from DistributorDetail

where distid >= 2147483647

select *

from Distributor

where distid >= 2147483647

Retrieved from "https://wiki.prodigix.com/index.php?title=Vision_Global_TicketSalesScript&oldid=232"