![\"image\"](\"https:\/\/pi3g.com\/wp-content\/uploads\/2019\/02\/image-3.png\" "\\"image\\"")
<\/a><\/p>\nThe individual fields are going to be editable with an inline editor, which will automatically save to the backend \u2013 no need for reloading the whole page.<\/p>\n
The point of the whole is a backend for my company, to be able to automate some processes, calculate stock prices, keep things in stock, etc. A warehouse application basically, tailored to me!<\/p>\n <\/p>\n MongoORM uses _id as the main index. Please note the underscore<\/strong>!<\/p>\n The _id is NOT a string. It is of the type ObjectId<\/strong><\/p>\n Therefore it will need to be constructed. If you want to construct it from a previous id, use this code:<\/p>\n mongo_id = BSON::ObjectId.new my_string_id<\/p>\n<\/blockquote>\n where my_string_id is a String, and mongo_id is an ObjectId.<\/p>\n <\/p>\n is responsible for setting up the communication to your Mongo DB instance. Please refer to Sam\u2019s documentation<\/a>.<\/p>\n require “mongo_orm” module Stock class Itemgroup < Mongo::ORM::Document #used for grouping, e.g. Pimoroni products, Shipping, etc. #this includes other items as well (shipping, digital downloads, etc) class Subitem < Mongo::ORM::EmbeddedDocument get “\/stock\/show” do |env| post “\/stock\/edit\/:what” do |env| #generate from WEEE entries end #end of module<\/p>\n<\/blockquote>\n Notes:<\/strong><\/p>\n Behaviour of si.save<\/strong><\/p>\n <% content_for “name” do %> <% content_for “main” do%> <\/TABLE> Notes:<\/strong><\/p>\n <!DOCTYPE html> <link rel=”stylesheet” (\u2026)<\/p>\n <!– Content Wrapper. Contains page content –> <!– Main content –> <%= yield_content “main” %><\/p>\n <\/section> (\u2026) <!– REQUIRED JS SCRIPTS –><\/p>\n <!– jQuery 3 –> Da die Dokumentation immer noch sp\u00e4rlich ist, w\u00fcrde ich gerne welche hinzuf\u00fcgen. Dies ist das, was ich derzeit baue: Die einzelnen Felder werden mit einem Inline-Editor editierbar sein, der automatisch im Backend gespeichert wird - kein Neuladen der ganzen Seite n\u00f6tig. Der Sinn des Ganzen ist ein Backend f\u00fcr meine...<\/p>","protected":false},"author":830,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[416],"tags":[409,535,532,534,531,533],"class_list":["post-7584","post","type-post","status-publish","format-standard","hentry","category-crystal-language","tag-crystal","tag-crystal-mongo-driver","tag-datanoise","tag-mongo_orm","tag-mongodb","tag-sam0x17"],"_links":{"self":[{"href":"https:\/\/pi3g.com\/de\/wp-json\/wp\/v2\/posts\/7584","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pi3g.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pi3g.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pi3g.com\/de\/wp-json\/wp\/v2\/users\/830"}],"replies":[{"embeddable":true,"href":"https:\/\/pi3g.com\/de\/wp-json\/wp\/v2\/comments?post=7584"}],"version-history":[{"count":1,"href":"https:\/\/pi3g.com\/de\/wp-json\/wp\/v2\/posts\/7584\/revisions"}],"predecessor-version":[{"id":7585,"href":"https:\/\/pi3g.com\/de\/wp-json\/wp\/v2\/posts\/7584\/revisions\/7585"}],"wp:attachment":[{"href":"https:\/\/pi3g.com\/de\/wp-json\/wp\/v2\/media?parent=7584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pi3g.com\/de\/wp-json\/wp\/v2\/categories?post=7584"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pi3g.com\/de\/wp-json\/wp\/v2\/tags?post=7584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<\/a><\/p>\nTechnologies used<\/h1>\n
\n
\n
\n
\n
<\/li>\nImportant bits<\/h1>\n
<\/a><\/p>\n\n
The code<\/h1>\n
config\/database.yml<\/h2>\n
stock.cr, responsible for defining Stockitem, Subitem, and the apropriate Kemal handlers:<\/h2>\n
\n
\nrequire “json”
\nrequire “.\/macros.cr”
\nrequire “.\/weee.cr”<\/p>\n
include Macros<\/p>\n
field group : String
has_many :stockitems #note that the stockitem can only belong to one ItemGroup at a time.
end<\/p>\n
class Stockitem < Mongo::ORM::Document
field sku : String
field description : String
field is_alias : Bool
field alias_of : String #if this field is set, do not use any other definitions from this item, get the aliased master item
field is_set : Bool # if this item is a set of other items
embeds_many :subitems # should only be set if is_set = true
field is_physical_item : Bool
field weee_applicable : Bool #can be either: paid for by someone else, or item is not electronics, …
field weight : Int32 # in g
timestamps
end<\/p>\n
field sku : String #a reference to the main stock item. NB: this could probably be reworked in a nicer fashion with belongs_to ? e.g. belongs_to :itemref, class_name: Stock::Stockitem<\/strong>
field note : String
field amount : Int32
end<\/p>\n
#https:\/\/github.com\/datanoise\/mongo.cr<\/a>
sis = Stockitem.all({“is_alias” => {“$eq” => false}})
name = “Stock :: Show & Edit”
mrender “stock”
end<\/p>\n
pp “Entering edit, with target ” + env.params.url[“what”]
pp env.params.body
if env.params.body.has_key?(“pk”) && env.params.body.has_key?(“value”)
pp “Inside pk & value”
pk = env.params.body[“pk”]?.as(String)
value = env.params.body[“value”]?.as(String)
if si = Stockitem.find(BSON::ObjectId.new pk)
case env.params.url[“what”]
when “sku”
si.sku = value
when “description”
si.description = value
when “is_alias”
si.is_alias = value == “true” ? true : false
when “alias_of”
si.alias_of = value
when “is_set”
si.is_set = value == “true” ? true : false
when “is_physical_item”
si.is_physical_item = value == “true” ? true : false
when “weee_applicable”
pp “weee_applicable”
si.weee_applicable = value == “true” ? true : false
end
if si.save
pp “inside si.save”
env.response.status_code = 200
else
env.response.status_code = 400
end
else
env.response.status_code = 400
end
else
env.response.status_code = 400
end
end<\/p>\n
get “\/stock\/generate\/:year” do |env|
#walk through the entire database, collect the items, and display a list
stock_collection = Hash(String,String).new
invoices = WEEE::Invoice.all({“year”=>env.params.url[“year”].to_i32})
invoices.each do |invoice|
#p “processing invoice #{invoice.number}”
#note that we might not get absolutely all invoices here, as easybill has a different view of the dates (import)
invoice.items.each do |item|
if !item.description.nil? && !item.number.nil?
key = item.number == “” ? item.description : item.number
if !key.nil?
if !stock_collection.has_key?(key)
description = “”
if !item.description.nil?
description = item.description
end
#stock_collection[key] = item.description
if !description.nil?
stock_collection[key] = description
end
end # end of !stock_collection.has_key?
end # end of if !key.nil?
end
end #end of invoice.items.each do
end #end of invoices.each
#check that this does not exist already in our database, else create it.
stock_collection.each do |sku,description|
if !Stockitem.find_by(:sku, sku)
si = Stockitem.new
si.sku = sku
si.is_alias = false
si.alias_of = “”
si.description = description
si.is_set = false
si.is_physical_item = true
si.weee_applicable = true
si.weight = 100
si.save!
end
end
end #end of get macro<\/p>\n\n
\n
\n
\n
stock.ecr, the HTML template<\/h2>\n
\n
<%= name %>
\n<% end %><\/p>\n
\n<div class=”col-md-12″>
<div class=”box box-primary”>
<div class=box-header with-border”>
<h3 class=”box-title”><%= name %><\/h3>
<\/div>
<div class=”box-body”>
Please note: alias’ed items are not loaded from the database.
<TABLE class=”table table-bordered table-striped dataTable” role=”grid” aria-describedby=”Table with stock items” id=”stock_items”>
<thead>
<tr role=”row”>
<th class=”sorting_asc” tabindex=”0″>sku<\/th>
<th>description<\/th>
<th>is_alias?<\/th>
<th>alias_of<\/th>
<th>is_set?<\/th>
<th>subitems<\/th>
<th>is_physical_item?<\/th>
<th>weee_applicable?<\/th>
<th>weight (g)<\/th>
<\/tr>
<\/thead>
<% sis.each do |si| %>
<TR role=”row”>
<TD><%= si.sku.to_s %><\/TD>
<TD><%= si.description.to_s %><\/TD>
<TD><%= si.is_alias ? “true” : “false” %><\/TD>
<TD><%= si.alias_of.to_s %><\/TD>
<TD><%= si.is_set ? “true” : “false” %><\/TD>
<TD>tbd.<\/TD>
<TD><%= si.is_physical_item ? “true” : “false” %><\/TD>
<TD><A HREF=”#”
id=”<%= si._id.to_s.rchop %>.weee_applicable”
class=”weee_applicable editable”
data-type=”select”
data-pk=”<%= si._id.to_s.rchop %>”
data-value=”true”
data-source=”[{value: ‘true’, text: ‘true’}, {value: ‘false’, text: ‘false’}]”
data-url=”\/stock\/edit\/weee_applicable”
data-title=”WEEE: <%= si.sku.to_s %>”
><%= si.weee_applicable ? “true” : “false” %><\/A><\/TD>
<TD><%= si.weight.to_s %> g<\/TD>
<\/TR>
<% end %><\/p>\n
<\/div>
<\/div>
\n<\/div>
\n<script>
\/\/https:\/\/datatables.net\/examples\/styling\/bootstrap<\/a>
\/\/demo.js x-editable
window.onload = function() {
$(document).ready(function (){
$(“#stock_items”).DataTable();
$.fn.editable.defaults.mode = ‘popup’;
$(“.editable”).editable();
$(“.editable”).on(‘hidden’, function(e, reason){
if(reason === ‘save’ || reason === ‘nochange’){
var $next = $(this).closest(‘tr’).next().find(‘.editable’);
setTimeout(function(){
$next.editable(‘show’);
}, 300);
}
});
});
}
\n<\/script>
\n<% end %><\/p>\n<\/blockquote>\n\n
layout.ecr (excerpts)<\/h2>\n
\n
\n<html>
\n<head>
<meta charset=”utf-8″>
<meta http-equiv=”X-UA-Compatible” content=”IE=edge”>
<title>TaxGod | <%= yield_content “name” %><\/title>
<meta content=”width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no” name=”viewport”>
<link rel=”stylesheet” href=”\/bower_components\/bootstrap\/dist\/css\/bootstrap.min.css”>
<link rel=”stylesheet” href=”\/bower_components\/font-awesome\/css\/font-awesome.min.css”>
<link rel=”stylesheet” href=”\/bower_components\/Ionicons\/css\/ionicons.min.css”>
<link rel=”stylesheet” href=”\/dist\/css\/AdminLTE.min.css”>
<link rel=”stylesheet” href=”\/dist\/css\/skins\/skin-blue.min.css”>
<link rel=”stylesheet” href=”\/danielm_uploader\/css\/jquery.dm-uploader.min.css”>
<link rel=”stylesheet” href=”\/bower_components\/datatables.net-bs\/css\/dataTables.bootstrap.min.css”>
<link rel=”stylesheet” href=”\/tg_css\/bootstrap-editable.css”>
<link rel=”stylesheet” href=”\/tg_css\/picockpit.css”>
<link rel=”stylesheet” href=”\/tg_css\/dropzone.css”>
<!–[if lt IE 9]>
<script src=”https:\/\/oss.maxcdn.com\/html5shiv\/3.7.3\/html5shiv.min.js”<\/a>><\/script>
<script src=”https:\/\/oss.maxcdn.com\/respond\/1.4.2\/respond.min.js”<\/a>><\/script>
<![endif]–><\/p>\n
href=”https:\/\/fonts.googleapis.com\/css?family=Source+Sans+Pro:300,400,600,700,300italic,400italic,600italic”<\/a>>
\n<\/head>
\n<body class=”hold-transition skin-blue sidebar-mini”>
\n<div class=”wrapper”><\/p>\n
<div class=”content-wrapper”>
<!– Content Header (Page header) –>
<section class=”content-header”>
<h1>
TaxGod :: <%= yield_content “name” %>
<small>Being God is fun.<\/small>
<\/h1>
<\/section><\/p>\n
<section class=”content container-fluid”><\/p>\n
<!– \/.content –>
<\/div>
<!– \/.content-wrapper –><\/p>\n
\n<\/div>
\n<!– .\/wrapper –><\/p>\n
\n<script src=”\/bower_components\/jquery\/dist\/jquery.min.js”><\/script>
\n<!– Bootstrap 3.3.7 –>
\n<script src=”\/bower_components\/bootstrap\/dist\/js\/bootstrap.min.js”><\/script>
\n<!– AdminLTE App –>
\n<script src=”\/danielm_uploader\/js\/jquery.dm-uploader.min.js”><\/script>
\n<script src=”\/bower_components\/datatables.net\/js\/jquery.dataTables.min.js”><\/script>
\n<script src=”\/bower_components\/datatables.net-bs\/js\/dataTables.bootstrap.min.js”><\/script>
\n<script src=”\/dist\/js\/adminlte.min.js”><\/script>
\n<script src=”\/tg_js\/bootstrap-editable.min.js”><\/script>
\n<script src=”\/tg_js\/dropzone.min.js”><\/script>
\n<\/body>
\n<\/html><\/p>\n<\/blockquote>\nFurther references<\/h1>\n
\n