This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--- CASE Conditional Expression crosstab using a CTE | |
WITH cte AS ( | |
SELECT salesman, | |
SUM(CASE order_month WHEN 1 THEN order_total ELSE 0 END) AS Jan, | |
SUM(CASE order_month WHEN 2 THEN order_total ELSE 0 END) AS Feb, | |
SUM(CASE order_month WHEN 3 THEN order_total ELSE 0 END) AS Mar, | |
SUM(CASE order_month WHEN 4 THEN order_total ELSE 0 END) AS Apr, | |
SUM(order_total) AS total | |
FROM |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DO $$ | |
DECLARE | |
r RECORD; | |
BEGIN | |
FOR r IN | |
( | |
SELECT table_name | |
FROM information_schema.tables | |
WHERE table_schema=current_schema() | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<Target Name="NpmInstall" BeforeTargets="Build" Condition=" '$(Configuration)' == 'Debug' And !Exists('$(NodeModules)') "> | |
<Exec Command="node --version" ContinueOnError="true"> | |
<Output TaskParameter="ExitCode" PropertyName="ErrorCode" /> | |
</Exec> | |
<Error Condition="'$(ErrorCode)' != '0'" Text="Node.js is required to build and run this project. To continue, please install Node.js from https://nodejs.org/, and then restart your project build process." /> | |
<Message Importance="high" Text="Restoring project dependencies using 'npm'. This may take several minutes..." /> | |
<Exec WorkingDirectory="$(ProjectDir)" Command="npm install" /> | |
</Target> | |
<Target Name="NpmRunBuild" BeforeTargets="Build" DependsOnTargets="NpmInstall"> | |
<Exec WorkingDirectory="$(AssetsRoot)" Command="npm run build" /> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<PropertyGroup> | |
... | |
<AssetsRoot>$(ProjectDir)assets\</AssetsRoot> | |
<NodeModules>$(ProjectDir)node_modules\</NodeModules> | |
<WebsiteRoot>wwwroot</WebsiteRoot> | |
... | |
</PropertyGroup> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
module.exports = { | |
future: { | |
// removeDeprecatedGapUtilities: true, | |
// purgeLayersByDefault: true, | |
}, | |
purge: false, | |
prefix: 'tw-', | |
theme: { | |
extend: {}, | |
}, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/*@tailwind base;*/ | |
@tailwind components; | |
@tailwind utilities; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
module.exports = { | |
content: ['**/*.cshtml', '**/*.js'], | |
css: [ '**/*.css'] | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
,"customDistStructure": { | |
"config": { | |
".css": "css", | |
".js": "js" | |
} | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
"scripts": { | |
"build": "parcel build assets/main.js --out-dir ./wwwroot/dist/ --no-minify --no-cache ", | |
"publish": "parcel build assets/main.js --out-dir ./wwwroot/dist/ --no-source-maps" | |
}, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import 'bootstrap/dist/css/bootstrap.css'; | |
import './css/site.css' | |
// Make jQuery available globally | |
import $ from 'jquery' | |
window.$ = window.jQuery = $ | |
import 'bootstrap' | |
import 'jquery-validation' | |
import 'jquery-validation-unobtrusive' |
NewerOlder