index.js 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278
  1. const { Keystone } = require('@keystonejs/keystone');
  2. const { PasswordAuthStrategy } = require('@keystonejs/auth-password');
  3. const { Text, Checkbox, Password } = require('@keystonejs/fields');
  4. const { GraphQLApp } = require('@keystonejs/app-graphql');
  5. const { AdminUIApp } = require('@keystonejs/app-admin-ui');
  6. const { StaticApp } = require('@keystonejs/app-static');
  7. //const { expressSession } = require('express-session');
  8. //const { FileSessionStore } = require('session-file-store')(expressSession);
  9. const fs = require('fs');
  10. // Lists
  11. const CashregistersSchema = require('./schema/cashregisters.js');
  12. const CashregisterdocsSchema = require('./schema/cashregisterdocs.js');
  13. const CompaniesSchema = require('./schema/companies.js');
  14. const CurrencySchema = require('./schema/currency.js');
  15. const DeliveryitemsSchema = require('./schema/deliveryitems.js');
  16. const DeliverymaterialpricesSchema = require('./schema/deliverymaterialprices.js');
  17. const DocflowSchema = require('./schema/docflow.js');
  18. const DocnumbersSchema = require('./schema/docnumbers.js')
  19. const DocpaymentSchema = require('./schema/docpayment.js');
  20. const DocumentsSchema = require('./schema/documents.js');
  21. const Eshop_removedSchema = require('./schema/eshop_removed.js');
  22. const Feature_groups_featuresSchema = require('./schema/feature_groups_features.js');
  23. const Feature_groupsSchema = require('./schema/feature_groups.js');
  24. const FeaturesSchema = require('./schema/features.js');
  25. const FeaturesvalSchema = require('./schema/featuresval.js');
  26. const FifopartSchema = require('./schema/fifopart.js');
  27. const FifoposSchema = require('./schema/fifopos.js');
  28. const ItemsSchema = require('./schema/items.js');
  29. const KindsSchema = require('./schema/kinds.js')
  30. const LocationsSchema = require('./schema/locations.js');
  31. const LogsSchema = require('./schema/logs.js');
  32. const MaterialsSchema = require('./schema/materials.js');
  33. const Monitor_logsSchema = require('./schema/monitor_logs.js');
  34. const OperatorgroupprivilegesSchema = require('./schema/operatorgroupprivileges.js');
  35. const OperatorgroupsSchema = require('./schema/operatorgroups.js');
  36. const Operators_cashregistersSchema = require('./schema/operators_cashregisters.js');
  37. const Operators_settingsSchema = require('./schema/operators_settings.js');
  38. const Operators_shopsSchema = require('./schema/operators_shops.js');
  39. const OperatorsSchema = require('./schema/operators.js');
  40. const PicturesSchema = require('./schema/pictures.js');
  41. const PositionsSchema = require('./schema/positions.js');
  42. const PrinttemplatesSchema = require('./schema/printtemplates.js');
  43. const Product_minmax_featuresSchema = require('./schema/product_minmax_features.js');
  44. const ProductfeaturesSchema = require('./schema/productfeatures.js');
  45. const Products_minmaxSchema = require('./schema/products_minmax.js');
  46. const ProductsgroupSchema = require('./schema/productsgroup.js');
  47. const ProductsSchema = require('./schema/products.js');
  48. const SettlementsSchema = require('./schema/settlements.js');
  49. const ShopsSchema = require('./schema/shops.js');
  50. const Stocktaking_itemsSchema = require('./schema/stocktaking_items.js');
  51. const StocktakingSchema = require('./schema/stocktaking.js');
  52. const SupaddressSchema = require('./schema/supaddress.js');
  53. const SuppliersSchema = require('./schema/suppliers.js');
  54. const SysparamsSchema = require('./schema/sysparams.js');
  55. const SysprivilegesSchema = require('./schema/sysprivileges.js');
  56. const TagtemplateobjectsSchema = require('./schema/tagtemplateobjects.js');
  57. const TagtemplatesSchema = require('./schema/tagtemplates.js');
  58. const TransferdocreceivedSchema = require('./schema/transferdocreceived.js');
  59. const UninumbersSchema = require('./schema/uninumbers.js');
  60. const UomSchema = require('./schema/uom.js');
  61. const UpgradelogSchema = require('./schema/upgradelog.js');
  62. const VatSchema = require('./schema/vat.js');
  63. //const Logger = require('@keystonejs/logger').logger('test');
  64. const initialiseData = require('./initial-data');
  65. const { KnexAdapter: Adapter } = require('@keystonejs/adapter-knex');
  66. const PROJECT_NAME = 'SchuStock';
  67. const adapterConfig = { knexOptions: {
  68. connection: 'postgresql://kdev_postgres:utnQ67pt74bVw6aB@postgres:5432/kdev_postgres',
  69. }
  70. };
  71. /*
  72. const { v4: uuid } = require('uuid');
  73. const { CloudinaryAdapter } = require('@keystonejs/file-adapters');
  74. const { Wysiwyg } = require('@keystonejs/fields-wysiwyg-tinymce')
  75. */
  76. const keystone = new Keystone({
  77. adapter: new Adapter(adapterConfig),
  78. //onConnect: process.env.CREATE_TABLES !== 'true' && initialiseData,
  79. onConnect: initialiseData,
  80. //secureCookies: false,
  81. /*
  82. cookie: {
  83. secure: process.env.NODE_ENV === 'production', // Default to true in production
  84. //secure: true, // Default to true in production
  85. maxAge: 1000 * 60 * 60 * 24 * 30, // 30 days
  86. sameSite: false,
  87. },
  88. */
  89. cookieSecret: 'dupa23',
  90. name: 'SchuStock',
  91. brand: 'Jubiler Schubert',
  92. //sessionStore: new FileSessionStore({ }),
  93. });
  94. //keystone.set('signin logo', ['https://jubilerschubert.pl/wp-content/uploads/schubert_logo.svg', 180, 42]);
  95. // Access control functions
  96. const userIsAdmin = ({ authentication: { item: user } }) => Boolean(user && user.isAdmin);
  97. const userOwnsItem = ({ authentication: { item: user } }) => {
  98. if (!user) {
  99. return false;
  100. }
  101. // Instead of a boolean, you can return a GraphQL query:
  102. // https://www.keystonejs.com/api/access-control#graphqlwhere
  103. return { id: user.id };
  104. };
  105. const userIsAdminOrOwner = auth => {
  106. const isAdmin = access.userIsAdmin(auth);
  107. const isOwner = access.userOwnsItem(auth);
  108. return isAdmin ? isAdmin : isOwner;
  109. };
  110. const access = { userIsAdmin, userOwnsItem, userIsAdminOrOwner };
  111. keystone.createList('User', {
  112. fields: {
  113. name: { type: Text },
  114. email: {
  115. type: Text,
  116. isUnique: true,
  117. },
  118. isAdmin: {
  119. type: Checkbox,
  120. // Field-level access controls
  121. // Here, we set more restrictive field access so a non-admin cannot make themselves admin.
  122. access: {
  123. update: access.userIsAdmin,
  124. },
  125. },
  126. password: {
  127. type: Password,
  128. },
  129. },
  130. // List-level access controls
  131. access: {
  132. read: access.userIsAdminOrOwner,
  133. update: access.userIsAdminOrOwner,
  134. create: access.userIsAdmin,
  135. delete: access.userIsAdmin,
  136. auth: true,
  137. },
  138. });
  139. const authStrategy = keystone.createAuthStrategy({
  140. type: PasswordAuthStrategy,
  141. list: 'User',
  142. });
  143. keystone.createList('cashregisters', CashregistersSchema);
  144. keystone.createList('cashregisterdocs', CashregisterdocsSchema);
  145. keystone.createList('companies', CompaniesSchema);
  146. keystone.createList('currency', CurrencySchema);
  147. keystone.createList('deliveryitems', DeliveryitemsSchema);
  148. keystone.createList('deliverymaterialprices', DeliverymaterialpricesSchema);
  149. keystone.createList('docflow', DocflowSchema);
  150. keystone.createList('docnumbers', DocnumbersSchema);
  151. keystone.createList('docpayment', DocpaymentSchema);
  152. keystone.createList('documents', DocumentsSchema);
  153. keystone.createList('eshop_removed', Eshop_removedSchema);
  154. keystone.createList('feature_groups_features', Feature_groups_featuresSchema);
  155. keystone.createList('feature_groups', Feature_groupsSchema);
  156. keystone.createList('features', FeaturesSchema);
  157. keystone.createList('featuresval', FeaturesvalSchema);
  158. keystone.createList('fifopart', FifopartSchema);
  159. keystone.createList('fifopos', FifoposSchema);
  160. keystone.createList('items', ItemsSchema); // todo: spr
  161. keystone.createList('kinds', KindsSchema);
  162. keystone.createList('locations', LocationsSchema);
  163. keystone.createList('logs', LogsSchema);
  164. keystone.createList('materials', MaterialsSchema);
  165. keystone.createList('monitor_logs', Monitor_logsSchema);
  166. keystone.createList('operatorgroupprivileges', OperatorgroupprivilegesSchema);
  167. keystone.createList('operatorgroups', OperatorgroupsSchema);
  168. keystone.createList('operators_cashregisters', Operators_cashregistersSchema);
  169. keystone.createList('operators_settings', Operators_settingsSchema);
  170. keystone.createList('operators_shops', Operators_shopsSchema);
  171. keystone.createList('operators', OperatorsSchema);
  172. keystone.createList('pictures', PicturesSchema);
  173. keystone.createList('positions', PositionsSchema);
  174. keystone.createList('printtemplates', PrinttemplatesSchema);
  175. keystone.createList('product_minmax_features', Product_minmax_featuresSchema);
  176. keystone.createList('productfeatures', ProductfeaturesSchema);
  177. keystone.createList('products_minmax', Products_minmaxSchema);
  178. keystone.createList('products', ProductsSchema);
  179. keystone.createList('productsgroup', ProductsgroupSchema);
  180. keystone.createList('settlements', SettlementsSchema);
  181. keystone.createList('shops', ShopsSchema);
  182. keystone.createList('stocktaking_items', Stocktaking_itemsSchema);
  183. keystone.createList('stocktaking', StocktakingSchema);
  184. keystone.createList('supaddress', SupaddressSchema);
  185. keystone.createList('suppliers', SuppliersSchema);
  186. keystone.createList('sysparams', SysparamsSchema);
  187. keystone.createList('sysprivileges', SysprivilegesSchema);
  188. keystone.createList('tagtemplateobjects', TagtemplateobjectsSchema);
  189. keystone.createList('tagtemplates', TagtemplatesSchema);
  190. keystone.createList('transferdocreceived', TransferdocreceivedSchema);
  191. keystone.createList('uninumbers', UninumbersSchema);
  192. keystone.createList('uom', UomSchema);
  193. keystone.createList('upgradelog', UpgradelogSchema);
  194. keystone.createList('vat', VatSchema);
  195. //console.log(keystone._providers);
  196. /*
  197. const {
  198. resolveAllKeys,
  199. arrayToObject,
  200. mapKeys,
  201. objMerge,
  202. flatten,
  203. unique,
  204. filterValues,
  205. compose,
  206. } = require('@keystonejs/utils');
  207. //console.log(keystone._providers);
  208. //console.log(keystone._providers.map(p => console.log(p.lists)));
  209. //const queries = unique(flatten(this._providers.map(p => p.lists.map(x => console.log(x.getGqlQueries())))));
  210. //const queries = unique(flatten(this._providers.map(p => p.lists.map(x => console.log())));
  211. //console.log(keystone._providers.map(p => console.log(p.lists)));//.map(x => x.getGqlQueries())));
  212. //console.log(keystone._providers[0].getQueries('public'));
  213. //const mutations = unique(flatten(keystone._providers.map(p => p.getMutations('public'))));
  214. //console.log(flatten(keystone._providers.map(p => p.getTypes('public'))));
  215. //queries.length > 0 && `type Query { ${queries.join('\n')} }`,
  216. //mutations.length > 0 && `type Mutation { ${mutations.join('\n')} }`,
  217. //console.log(keystone._providers);
  218. //console.log(keystone.getTypeDefs('public'));
  219. /*
  220. if (typeof process.env.DUMP_SCHEMA === 'string') {
  221. keystone.dumpSchema(process.env.DUMP_SCHEMA, 'public');
  222. console.log(`Schema dumped to: ${path.resolve(process.env.DUMP_SCHEMA)}`);
  223. process.exit(0);
  224. }
  225. function function2() {
  226. console.log(keystone);
  227. }
  228. setTimeout(function2, 100);
  229. */
  230. module.exports = {
  231. keystone,
  232. apps: [
  233. new GraphQLApp(),
  234. new StaticApp({ path: '/', src: 'public' }),
  235. new AdminUIApp({
  236. name: 'SchuStocc',
  237. enableDefaultRoute: true,
  238. authStrategy,
  239. }),
  240. ],
  241. /*configureExpress: app => {
  242. app.set('trust proxy', true);
  243. }*/
  244. };