Skip to content

Instantly share code, notes, and snippets.

View chadsten's full-sized avatar

Chadsten chadsten

  • Colorado
View GitHub Profile
<?php
$techs = array('html','css','javascript');
$example_data = array('data1','data2','data3');
foreach ($techs as $tech) {
$response_updated = $example_data;
$new_array[$tech] = array_pop($response_updated);
}
SELECT
Epicor10.Erp.PartPlant.Company, Epicor10.Erp.PartPlant.Plant A, Epicor10.Erp.PartPlant.PartNum, Epicor10.Erp.PartPlant.MinimumQty,
FROM
Epicor10.Erp.PartPlant, Epicor10.Erp.Part, Epicor10.Erp.PartUOM, Epicor10.Erp.Vendor,
(SELECT MAX(PartNum), SUM((CASE WHEN 75 < ((ROUND(Epicor10.Erp.PartPlant.MaximumQty / 2, 0) + 1) / Epicor10.Erp.PartPlant.MaximumQty) * 100
THEN (ROUND(Epicor10.Erp.PartPlant.MaximumQty / 2, 0) + 1) * 2
ELSE Epicor10.Erp.PartPlant.MaximumQty
END)
FROM Epicor10.Erp.PartPlant WHERE Epicor10.Erp.PartPlant.MinimumQty > 0 AND Epicor10.Erp.PartPlant.MaximumQty > 0) AS Modulo
SELECT Epicor10.Erp.PartPlant.Company, Epicor10.Erp.PartPlant.Plant, Epicor10.Erp.PartPlant.PartNum, Epicor10.Erp.PartPlant.MinimumQty,
ROUND(Epicor10.Erp.PartPlant.MaximumQty / 2, 0) + 1 AS SuggestedMin, Epicor10.Erp.PartPlant.MaximumQty
FROM
(SELECT (CASE WHEN 75 < ((ROUND(Epicor10.Erp.PartPlant.MaximumQty / 2, 0) + 1) / Epicor10.Erp.PartPlant.MaximumQty)
* 100 THEN (ROUND(Epicor10.Erp.PartPlant.MaximumQty / 2, 0) + 1) * 2 ELSE Epicor10.Erp.PartPlant.MaximumQty END AS SuggestedMax ) AS Modulo
Epicor10.Erp.PartPlant LEFT OUTER JOIN
Epicor10.Erp.Part ON Epicor10.Erp.PartPlant.Company = Epicor10.Erp.Part.Company AND
Epicor10.Erp.PartPlant.PartNum = Epicor10.Erp.Part.PartNum LEFT OUTER JOIN
SELECT Epicor10.Erp.PartPlant.Company, Epicor10.Erp.PartPlant.Plant, Epicor10.Erp.PartPlant.PartNum, Epicor10.Erp.PartPlant.MinimumQty,
ROUND(Epicor10.Erp.PartPlant.MaximumQty / 2, 0) + 1 AS SuggestedMin, Epicor10.Erp.PartPlant.MaximumQty,
CASE WHEN 75 < ((ROUND(Epicor10.Erp.PartPlant.MaximumQty / 2, 0) + 1) / Epicor10.Erp.PartPlant.MaximumQty)
* 100 THEN (ROUND(Epicor10.Erp.PartPlant.MaximumQty / 2, 0) + 1) * 2 ELSE Epicor10.Erp.PartPlant.MaximumQty END AS SuggestedMax,
Epicor10.Erp.PartPlant.LeadTime, Epicor10.Erp.Vendor.VendorID, Epicor10.Erp.PartPlant.ReOrderLevel AS ReOrderToMax
FROM Epicor10.Erp.PartPlant LEFT OUTER JOIN
Epicor10.Erp.Vendor ON Epicor10.Erp.PartPlant.Company = Epicor10.Erp.Vendor.Company AND
Epicor10.Erp.PartPlant.VendorNum = Epicor10.Erp.Vendor.VendorNum
WHERE (Epicor10.Erp.PartPlant.BuyToOrder = 'false') AND (Epicor10.Erp.PartPlant.Pla
===================================
===================================
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)
------------------------------
Program Location:
at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
SELECT Erp.VendPart.Company, Erp.VendPart.PartNum, Erp.VendPart.PUM, Erp.VendPart.EffectiveDate, Erp.VendPart.BaseUnitPrice, Erp.VendPart.VenPartNum,
Erp.Vendor.VendorID
FROM Erp.VendPart INNER JOIN
Erp.Vendor ON Erp.VendPart.Company = Erp.Vendor.Company AND Erp.VendPart.VendorNum = Erp.Vendor.VendorNum
WHERE (Erp.VendPart.PartNum IN
(SELECT VendPart_1.PartNum
FROM Erp.VendPart AS VendPart_1 INNER JOIN
Erp.Vendor AS Vendor_1 ON VendPart_1.Company = Vendor_1.Company AND VendPart_1.VendorNum = Vendor_1.VendorNum
GROUP BY VendPart_1.PartNum
HAVING (COUNT(*) > 1)))
SELECT TOP (100) PERCENT CAST(RIGHT(InvcHead.FiscalYear, 2) AS VARCHAR(2)) + '-' + CAST(InvcHead.FiscalPeriod AS VARCHAR(2)) AS FiscalPeriod, InvcHead.InvoiceType,
InvcHead.SalesRepList, SUBSTRING(InvcHead.SalesRepList, 1, CASE WHEN CHARINDEX('~', InvcHead.SalesRepList) > 0 THEN charindex('~',
InvcHead.SalesRepList) - 1 ELSE LEN(InvcHead.SalesRepList) END) AS SalesRep1, SalesRep1.Name AS Rep1Name, InvcHead.RepSplit1,
SUBSTRING(InvcHead.SalesRepList, 8, CASE WHEN CHARINDEX('~', InvcHead.SalesRepList) > 0 THEN charindex('~', InvcHead.SalesRepList)
- 1 ELSE LEN(InvcHead.SalesRepList) END) AS SalesRep2, SalesRep2.Name AS Rep2Name, InvcHead.RepSplit2, SUBSTRING(InvcHead.SalesRepList, 15,
CASE WHEN CHARINDEX('~', InvcHead.SalesRepList) > 0 THEN charindex('~', InvcHead.SalesRepList) - 1 ELSE LEN(InvcHead.SalesRepList) END) AS SalesRep3,
SalesRep3.Name AS Rep3Name, InvcHead.Rep
#--------------------------------------------------------------------#
# ClearLag Configuration File #
#--------------------------------------------------------------------#
# Configure to your liking, reload the config by tying: /lagg reload #
# - #
# Here is a helpful tutorial on this configuration setup! (Updated) #
# http://dev.bukkit.org/bukkit-plugins/clearlagg/pages/config-setup/ #
#--------------------------------------------------------------------#
# All possible mob names: https://goo.gl/cch8YK #
#--------------------------------------------------------------------#
SELECT [Company]
,[PartNum]
,[PUM]
,[EffectiveDate]
,[BaseUnitPrice]
,[VenPartNum]
FROM [Epicor10].[Erp].[VendPart]
WHERE [PartNum] IN (SELECT [PartNum] FROM [Epicor10].[Erp].[VendPart] WHERE [EffectiveDate] = '1/2/2016')
AND [EffectiveDate] = '1/1/2016'
shapely-scripts.js?ver=20160115:139 Uncaught TypeError: $(...).flexslider is not a function(anonymous function) @ shapely-scripts.js?ver=20160115:139i @ jquery.js?ver=1.12.4:2fireWith @ jquery.js?ver=1.12.4:2ready @ jquery.js?ver=1.12.4:2K @ jquery.js?ver=1.12.4:2
embed?uri=spotify%3Auser%3Awhattheferguson%3Aplaylist%3A3IEejV7dTnblV8ltoqlBHh:352 GET https://dkcnbgrira.spotilocal.com:4370/service/version.json?service=remote&…otify%253Auser%253Awhattheferguson%253Aplaylist%253A3IEejV7dTnblV8ltoqlBHh net::ERR_CONNECTION_REFUSEDi._request @ embed?uri=spotify%3Auser%3Awhattheferguson%3Aplaylist%3A3IEejV7dTnblV8ltoqlBHh:352i._detectPort @ embed?uri=spotify%3Auser%3Awhattheferguson%3Aplaylist%3A3IEejV7dTnblV8ltoqlBHh:352(anonymous function) @ embed?uri=spotify%3Auser%3Awhattheferguson%3Aplaylist%3A3IEejV7dTnblV8ltoqlBHh:352
embed?uri=spotify%3Auser%3A128343550%3Aplaylist%3A4d4XQDYYpJdvFsATUHrVCN:172 GET https://rsrjfuulpc.spotilocal.com:4370/service/version.json?service=remote&…i%3Dspotify%253Auser%253A128343550%253