Thomas Decaux ebuildy

Notebook PMS bug investigation

On doit trouver pourquoi certains produits attributes ont un stock négatifs.

On voit que reserved_quantity reste positif alors que le stock a été shipped côté PMS

query to find wrong stock

SELECT p.id_product, COUNT(*) as declinaisons, SUM(f.quantity) as q

	FROM dunglas/frankenphp:1-php8.3 AS php-base

	RUN install-php-extensions .....

	RUN useradd -D www-data

	USER www-data


	FROM php-base AS php-builder

	grid-rows: 1

	legends: {
	class: container
	grid-rows: 3

	explanation: \|md
	# YAML everywhere

	A `project` is defined in YAML format, it contains ALL details:

	locals {
	gitlab_groups_files = fileset(path.module, "../../../config/gitlab/*.yaml")
	gitlab_groups_flatten = [for f in local.gitlab_groups_files : yamldecode(file(f)).groups]
	gitlab_groups = ({
	for group in flatten(local.gitlab_groups_flatten) :
	group.path => {
	name : group.name,
	path : group.path,
	description : try(group.description, ""),
	projects : [for p in try(group.projects, []) : merge(p, group.project_defaults)]

	if ($sql)
	{
	$product_ids = Db::getInstance()->ExecuteS($sql);

	$beginTime = microtime(true);

	foreach ($product_ids as $product_id)
	{

	/**

	#!/usr/bin/env python3

	"""
	To generate json plan:

	terraform plan -var-file=..... -out=output.tfplan
	terraform show -json output.tfplan > plan.json
	"""

	import argparse

	{{- $podValues := .Values.unsealedJob.pod -}}
	{{- $jobValues := .Values.unsealedJob.job -}}
	{{- $containerValues := .Values.unsealedJob.container -}}
	apiVersion: batch/v1
	kind: Job
	metadata:
	name: vault-unsealed-{{ $jobValues.version }}
	spec:
	template:
	spec:

	#!/bin/bash

	##
	# Requirements: jq, jd, curl
	# Variables:
	# - ES_AUTH --> elasticsearch auth
	##

	alias es_curl="curl -H "application/json" -u $ES_AUTH"