thiscodeWorks - Saving, organizing & sharing the best of code online

/****************  OOPS IN JAVASCRIPT *************************/

/* JAVASCRIPT AND CLASSES 
So yes, JavaScript does have classes, and they are quite powerful for object-oriented programming!

/* OOP 

/*Object 
-collection to properties  and methods 
-ex: toLowerCase 

/* parts of oops
Object literal means literally assinged 

-constructor functions 
-prototypes 
-classes n
-Instances 

/* 4 pillars 
abstraction 
encaplusation 
inheritnace 
polymoriphism 
*/

const user = { // object literal 
    username: "hitesh ",
    logincount: 8,
    signedIn: true,

    getUserDetails: function() {
        console.log(`username: ${this.username}`);
        console.log(this); 
        /* output : {
  username: 'hitesh ',
  logincount: 8,
  signedIn: true,
  getUserDetails: [Function: getUserDetails]*/
}
    }

console.log(user.getUserDetails()); // username: hitesh //undefined
console.log(this); // {}

/////////////// CONSTRUCTOR FUNCTION //////////////
function User2(username, logincount, isLoggedIn) {
  this.username = username;
  this.logincount = logincount;
  this.isLoggedIn = isLoggedIn;
  
  this.greeting = functio
return this
}

const userOne =/*HERE new TO FIX THE ERROR*/ User2("hitesh", 12, true);
const userTwo = /*HERE new TO FIX THE ERROR*/User2("hitesh chaudhary", 18, false)
 console.log(userOne);   
/*username: 'hitesh chaudhary',
  logincount: 18,
  isLoggedIn: false*/ 
  /* INPORTANT == IF WE USE NEW IN DECLARATION SPACE IT WILL RUNCORRECTLY */ 
  
  /* INPORTANCE  and FEATURES OF NEW KEYWORD === when we use new keyword new empty object is made in first step , it will  call the constructor function in second step  , it will inject all the values which we passed in arguments , than it will return to you */

CS 2.0

@Checkmate

.hud-zoom-overlay-circle {
    border-radius: 100vh;
    position: fixed;
    top: 5vh;
    left: 50%;
    width: 90vh;
    height: 90vh;
    box-shadow: 0 0 0 9999px rgb(255 0 0);
    margin-left: -45vh;
}
.hud-zoom-overlay-vert{
    position: fixed;
    left: 50%;
    top: 0;
    width: 1px;
    height: 100%;
    background: black;
}

.hud-zoom-overlay-horiz{
    position: fixed;
    left: 0;
    top: 50%;
    width: 100%;
    height: 1px;
    background: #ff0000;
}

.hud-zoom-overlay-redpoint{
    position: fixed;
    left: 50%;
    top: 50%;
    width: 5px;
    height: 5px;
    border-radius: 5px;
    background: red;
    margin-top: -2px;
    margin-left: -2px;
}

CS

@Checkmate

/* HUD CROSSHAIR */
.hud-crosshair{
    visibility: clear;
    position: fixed;
    width: 25px;
    height: 25px;
    left: 50%;
    top: 50%;
    margin-left: -13px;
    margin-top: -13px;
    z-index: 12;
}

.hud-crosshair div{
    background: #00ff00;
    position: absolute;

}

.hud-crosshair-1, .hud-crosshair-2{
    width: 3px;
    height:10px;
    left: 12px;
}

.hud-crosshair-3, .hud-crosshair-4{
    width: 10px;
    height:3px;
    top: 12px;
}

.hud-crosshair-1{
    top:0;
}
.hud-crosshair-2{
    top:18px;
}
.hud-crosshair-3{
    left: 0;
}
.hud-crosshair-4{
    left: 17px;
}
/* HUD CROSSHAIR end */

Poe

@Fatolla

https://poe.com/

#flexbox #stretch #child

stretch child

@davidmchale

.parent {
  display: flex; /* Enables Flexbox */
  height: 300px; /* Set a specific height for the parent div */
  border: 1px solid #000;
}

.child {
  background-color: lightblue;
  flex: 1; /* Optional: Makes the child take up remaining space */
}

api product funcional

@RestResource(urlMapping='/api/products/*')
global with sharing class ProductApi {

    // GET: Recuperar productos por External_ID__c (sin captura de log)
    @HttpGet
    global static List<Product2> getProducts() {
        RestRequest req = RestContext.request;
        String externalId = req.requestURI.substringAfterLast('/');

        if (String.isNotBlank(externalId)) {
            // Recuperar producto por External_ID__c
            List<Product2> products = [SELECT Id, Name, ProductCode, Description, IsActive, External_ID__c 
                                    FROM Product2 WHERE External_ID__c = :externalId];
            return products;
        } else {
            // Recuperar todos los productos si no se proporciona External_ID__c
            List<Product2> products = [SELECT Id, Name, ProductCode, Description, IsActive, External_ID__c 
                                    FROM Product2];
            return products;
        }
    }

    // PATCH: Crear o actualizar un producto y establecer su precio usando solo External_ID__c
    @HttpPatch
    global static Product2 upsertProduct(
        String externalId, 
        String name, 
        String productCode, 
        String description, 
        Boolean isActive, 
        Decimal price
    ) {
        RestRequest req = RestContext.request;
        Product2 product = null;
        try {
            if (String.isBlank(externalId)) {
                throw new CustomException('El campo External_ID__c es obligatorio para realizar un upsert.');
            }

            if (price == null || price < 0) {
                throw new CustomException('El precio debe ser un valor positivo.');
            }

            // Crear o actualizar el producto basado en External_ID__c
            product = new Product2(
                External_ID__c = externalId,
                Name = name,
                ProductCode = productCode,
                Description = description,
                IsActive = isActive
            );

            upsert product External_ID__c;

            // Buscar el Standard Pricebook
            List<Pricebook2> standardPricebookList = [SELECT Id FROM Pricebook2 WHERE IsStandard = true LIMIT 1];
            if (standardPricebookList.isEmpty()) {
                throw new CustomException('No se encontró el Standard Pricebook.');
            }
            Pricebook2 standardPricebook = standardPricebookList[0];

            // Verificar si ya existe un PricebookEntry para este producto
            List<PricebookEntry> existingEntries = [
                SELECT Id, UnitPrice 
                FROM PricebookEntry 
                WHERE Product2Id = :product.Id AND Pricebook2Id = :standardPricebook.Id
            ];

            if (existingEntries.isEmpty()) {
                // Crear un nuevo PricebookEntry si no existe
                PricebookEntry newEntry = new PricebookEntry(
                    Pricebook2Id = standardPricebook.Id,
                    Product2Id = product.Id,
                    UnitPrice = price,
                    IsActive = true
                );
                insert newEntry;
            } else {
                // Actualizar el PricebookEntry existente
                PricebookEntry existingEntry = existingEntries[0];
                existingEntry.UnitPrice = price;
                update existingEntry;
            }

            // Log success
            logIntegrationDetails('PATCH', req, product, null);  // No hay error, pasamos null para la excepción

            return product;
        } catch (Exception e) {
            // Log error
            logIntegrationDetails('PATCH', req, null, e);  // Capturamos el error y lo pasamos al log
            throw e;  // Vuelve a lanzar la excepción para que se maneje como corresponde
        }
    }

    // DELETE: Eliminar un producto por External_ID__c
    @HttpDelete
    global static void deleteProduct() {
        RestRequest req = RestContext.request;
        String productIdOrExternalId = req.requestURI.substringAfterLast('/');

        if (String.isBlank(productIdOrExternalId)) {
            throw new CustomException('Debe proporcionar el ID o el External_ID__c para eliminar.');
        }

        Product2 productToDelete;

        if (productIdOrExternalId.startsWith('a') && productIdOrExternalId.length() == 18) {
            // Buscar por Id estándar
            productToDelete = [SELECT Id, IsDeleted FROM Product2 WHERE Id = :productIdOrExternalId AND IsDeleted = false LIMIT 1];
        } else {
            // Buscar por External_ID__c
            productToDelete = [SELECT Id, IsDeleted FROM Product2 WHERE External_ID__c = :productIdOrExternalId AND IsDeleted = false LIMIT 1];
        }

        // Si el producto no existe o está eliminado, lanzamos una excepción
        if (productToDelete == null || productToDelete.IsDeleted) {
            throw new CustomException('El producto no existe o ha sido eliminado.');
        }

        // Eliminar cualquier PricebookEntry relacionado en el Standard Pricebook
        List<Pricebook2> standardPricebookList = [SELECT Id FROM Pricebook2 WHERE IsStandard = true LIMIT 1];
        if (!standardPricebookList.isEmpty()) {
            Pricebook2 standardPricebook = standardPricebookList[0];
            List<PricebookEntry> entriesToDelete = [
                SELECT Id 
                FROM PricebookEntry 
                WHERE Product2Id = :productToDelete.Id AND Pricebook2Id = :standardPricebook.Id
            ];
            delete entriesToDelete;
        }

        delete productToDelete;

        // Registrar el log de la integración
        try {
            logIntegrationDetails('DELETE', req, productToDelete, null);
        } catch (Exception e) {
            // Si algo sale mal, capturamos la excepción y la mostramos (aunque puede que ya esté registrada)
            System.debug('Error al registrar el log: ' + e.getMessage());
        }
    }

    // Método auxiliar para registrar los detalles de las solicitudes y respuestas en Integration_Log__c
    
    private static void logIntegrationDetails(String operation, RestRequest req, SObject response, Exception e) {
        // Crear el log de la solicitud y la respuesta
        Integration_Log__c log = new Integration_Log__c();
    
        // Si ocurrió un error, capturamos la excepción
        if (e != null) {
            log.Estado__c = 'Error';
            log.Response__c = 'Error: ' + e.getMessage();  // Guardamos el mensaje de la excepción en Response__c
        } else {
            log.Estado__c = 'Success';  // Si todo fue exitoso, lo marcamos como "Success"
            log.Response__c = JSON.serialize(response);  // Serializamos la respuesta
        }
    
        // Asignar el nombre del log con el nombre del objeto y la fecha actual
        String logName = (response != null ? response.getSObjectType().getDescribe().getName() : 'UnknownObject') + ' - ' + DateTime.now().format();
        log.Name = logName;
    
        // Capturamos los parámetros de la solicitud
        log.Request__c = 'Params: ' + req.params;
    
        // Si se está creando/actualizando un producto, asociamos el producto con el log
        if (response instanceof Product2) {
            log.Product__c = ((Product2) response).Id;
        }
    
        insert log; // Insertamos el log en la base de datos
    }
    
    // Clase de excepción personalizada
    global class CustomException extends Exception {}
}

#powershell #csv

merge CSV rows with partially duplicate lines

@baamn

$columns = import-csv C:\infile.csv -Header 'column1','column2','column3','column4' -Delimiter ';'

$Result = @()
ForEach($i in $columns){

   $found = 0;

   ForEach($m in $Result){

    if($m.column1 -eq $i.column1){

        $found = 1

        if( $i.column4.length -ne 0 )
        {   
           $m.column4 = $i.column4
        }
        break;
      }
   }

   if($found -eq 0){
        $Result += [pscustomobject] @{column1=$i.column1; column2=$i.column2; column3=$i.column3; column4=$i.column4}
   }
}

$Result | export-csv C:\out.csv

Header Side Menu - Custom Component

@vishalsingh21

// Custom Component
<div class="side-menu">
    <div class="side-menu-top">
        <div class="side-menu-logo">
            <img src="//published-assets.ari-build.com/Content/Published/Site/{{Site.Id}}/images/dealer-logo.png" alt="{{Locations.0.Name}}" />
        </div>
        <div class="side-menu-close">
            <span>&#x2716</span>
        </div>
    </div>
    <div class="side-menu-items">
        <a href="/" title="Home">Home</a>
        <a href="/new-models" title="New Models">New Models</a>
        <a href="/search/inventory" title="Inventory">Inventory</a>
        <a href="/servicereq" title="Services">Services</a>
        <a href="/aboutus" title="Company Info">Company Info</a>
        <a href="/contactus" title="Contact Us">Contact Us</a>
    </div>
</div>

// Side Menu - Script
$('.side-menu-close').on('click', function(e){
    $('.side-menu').toggleClass('open');
});
$('.icon-menu').on('click', function(e){
    $('.side-menu').toggleClass('open');
});

// Side Menu - Style
.side-menu{
    background: $brand-primary;
    position: fixed;
    right: -100%; top: 0;
    z-index: 101;
    width: _res(200,400); height: 100%;
    transition: all .6s ease-in-out;
    &.open{
        right: 0;
    }
    &-top{
        padding: _res(30);
        @include _flex();
    }
    &-logo{
        width: 70%;
        img{ width: 100%; }
    }
    &-close{
        color: #fff;
        cursor: pointer;
        font-size: _res(10,20);
        position: absolute;
        top: 10px; right: 20px;
    }
    &-items{
        @include _flex($dir: column, $halign: flex-start);
        a{
            color: #fff;
            font-family: $headings-font-family;
            font-weight: 600;
            font-size: _res(15,25);
            letter-spacing: .020em;
            text-transform: uppercase;
            line-height: 2;
            transition: all .3s ease-in-out;
            text-decoration: none;
            padding: 0 _res(30);
            &:hover{
                color: #fff;
                background: $brand-secondary;
            }
        }
    }
}

#dart

Image picker helper

@Samuel1347

import 'dart:io';

import 'package:flutter/material.dart';
import 'package:flutter_image_compress/flutter_image_compress.dart';
import 'package:image_cropper/image_cropper.dart';
import 'package:image_picker/image_picker.dart';

import 'app_style.dart';

class ImagePickerHelper {
  static Future<void> pickImage({
    required Function(File? file) onDone,
  }) async {
    final pickedImage =
        await ImagePicker.platform.pickImage(source: ImageSource.gallery);

    if (pickedImage == null) {
      onDone.call(null);
      return;
    }

    final pickedFile = File(pickedImage.path);
    final croppedImage = await _cropImage(pickedFile);
    final compressedImage = await _compressFile(croppedImage);
    if (compressedImage == null) {
      onDone.call(null);
      return;
    }


    onDone.call(compressedImage);
  }

  static String getFileSize(File file) {
    final fileSizeInMB =
    (file.lengthSync() / (1024 * 1024)).toStringAsFixed(2);
    return fileSizeInMB;
  }

  static Future<File?>? _cropImage(File file) async {
    final croppedFile = await ImageCropper.platform.cropImage(
      sourcePath: file.path,
      aspectRatio: const CropAspectRatio(ratioX: 1, ratioY: 1),
      compressQuality: 60,
      uiSettings: [
        AndroidUiSettings(
          toolbarTitle: 'Crop Image',
          toolbarColor: AppStyle.lightPurple,
          toolbarWidgetColor: Colors.white,
          initAspectRatio: CropAspectRatioPreset.square,
          lockAspectRatio: true,
        ),
        IOSUiSettings(
          minimumAspectRatio: 1.0,
          aspectRatioLockEnabled: true,
          resetAspectRatioEnabled: true,
        ),
      ],
    );

    if (croppedFile == null) return null;
    return File(croppedFile.path);
  }

  static Future<File?> _compressFile(File? file) async {
    if (file == null) return null;

    final targetPath =
        '${file.parent.path}/compressed_${file.path.split('/').last}';

    final XFile? result = await FlutterImageCompress.compressAndGetFile(
      file.absolute.path,
      targetPath,
      quality: 60,
      keepExif: false,
    );

    if (result == null) return null;
    return File(result.path);
  }
}

Melbourne - What's On - 13th January 2025

@FOHWellington

{
	"blocks": [
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":cherry_blossom: :cute-sun: Boost Days - What's On This Week :cute-sun::cherry_blossom:"
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "\n\n Happy Monday Melbourne!\n\n We have a jam packed week coming up, see what's on below!"
			}
		},
		{
			"type": "divider"
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": "Xero Café :coffee:",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "\n *This week we are offering:* \n\n :lemon-flower: Lemon Slice & Crunchy Cornflake Brownie Slice :cornflakes:  \n\n *Weekly Café Special:* _Vietnamese Iced Coffee_ :flag-vn:"
			}
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": " Wednesday, 15th January :calendar-date-15:",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": " \n\n To celebrate our new Brand Platform Ad Campaign *_Your Business Supercharged_*, we've got some special surprises for you: \n\n :bikefast: *Smoothie Bikes* in the L3 Kitchen from 9:30am - pedal away to blend up a delicious smoothie! \n\n :lunch: *Light Lunch*: Provided by Kartel Catering from *12pm* \n\n :CAKE: *Celebratory Chocolate & Vanilla Cake* from 2pm + a video on our new brand in the L3 Kitchen/Breakout Space! \n\n :australian-open: *One final surprise:* Since our new brand will be advertised at the Australian Open, we are giving you the chance to win 2 x Ground Passes for Sunday, 19th of January! Enter <https://docs.google.com/forms/d/e/1FAIpQLSe5PJgT1CkJJkfXIsyLtv1kLQf7qHTcMzR3T8quZXxMTf5FbA/viewform?usp=header|*HERE*> . \n\n Winner will be drawn and contacted via Slack on Wednesday!"
			}
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": "Thursday, 16th January :calendar-date-16:",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": ":breakfast: *Breakfast*: Provided by *Kartel Catering* from *8:30am - 10:30am* in the Wominjeka Breakout Space."
			}
		},
		{
			"type": "divider"
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "Stay tuned for more fun throughout the year. Happy 2025! :party-wx:"
			}
		}
	]
}

api products without try catch

@RestResource(urlMapping='/api/products/*')
global with sharing class ProductApi {

    // GET: Recuperar productos por External_ID__c
    @HttpGet
    global static List<Product2> getProducts() {
        RestRequest req = RestContext.request;
        String externalId = req.requestURI.substringAfterLast('/');

        if (String.isNotBlank(externalId)) {
            // Recuperar producto por External_ID__c
            return [SELECT Id, Name, ProductCode, Description, IsActive, External_ID__c 
                    FROM Product2 WHERE External_ID__c = :externalId];
        } else {
            // Si no se proporciona External_ID__c, lanzar excepción
            throw new CustomException('Debe proporcionar el External_ID__c para la búsqueda.');
        }
    }

    // PATCH: Crear o actualizar un producto y establecer su precio usando solo External_ID__c
    @HttpPatch
    global static Product2 upsertProduct(
        String externalId, 
        String name, 
        String productCode, 
        String description, 
        Boolean isActive, 
        Decimal price
    ) {
        if (String.isBlank(externalId)) {
            throw new CustomException('El campo External_ID__c es obligatorio para realizar un upsert.');
        }

        if (price == null || price < 0) {
            throw new CustomException('El precio debe ser un valor positivo.');
        }

        // Crear o actualizar el producto basado en External_ID__c
        Product2 product = [SELECT Id FROM Product2 WHERE External_ID__c = :externalId LIMIT 1];

        if (product == null) {
            product = new Product2(
                External_ID__c = externalId,
                Name = name,
                ProductCode = productCode,
                Description = description,
                IsActive = isActive
            );
            insert product;
        } else {
            product.Name = name;
            product.ProductCode = productCode;
            product.Description = description;
            product.IsActive = isActive;
            update product;
        }

        // Buscar el Standard Pricebook
        List<Pricebook2> standardPricebookList = [SELECT Id FROM Pricebook2 WHERE IsStandard = true LIMIT 1];
        if (standardPricebookList.isEmpty()) {
            throw new CustomException('No se encontró el Standard Pricebook.');
        }
        Pricebook2 standardPricebook = standardPricebookList[0];

        // Verificar si ya existe un PricebookEntry para este producto
        List<PricebookEntry> existingEntries = [
            SELECT Id, UnitPrice 
            FROM PricebookEntry 
            WHERE Product2Id = :product.Id AND Pricebook2Id = :standardPricebook.Id
        ];

        if (existingEntries.isEmpty()) {
            // Crear un nuevo PricebookEntry si no existe
            PricebookEntry newEntry = new PricebookEntry(
                Pricebook2Id = standardPricebook.Id,
                Product2Id = product.Id,
                UnitPrice = price,
                IsActive = true
            );
            insert newEntry;
        } else {
            // Actualizar el PricebookEntry existente
            PricebookEntry existingEntry = existingEntries[0];
            existingEntry.UnitPrice = price;
            update existingEntry;
        }

        return product;
    }

    // DELETE: Eliminar un producto por External_ID__c
    @HttpDelete
    global static void deleteProduct() {
        RestRequest req = RestContext.request;
        String externalId = req.requestURI.substringAfterLast('/');

        if (String.isBlank(externalId)) {
            throw new CustomException('Debe proporcionar el External_ID__c para eliminar.');
        }

        Product2 productToDelete = [SELECT Id FROM Product2 WHERE External_ID__c = :externalId LIMIT 1];

        if (productToDelete == null) {
            throw new CustomException('No se encontró el producto con el External_ID__c proporcionado.');
        }

        // Eliminar cualquier PricebookEntry relacionado en el Standard Pricebook
        List<Pricebook2> standardPricebookList = [SELECT Id FROM Pricebook2 WHERE IsStandard = true LIMIT 1];
        if (!standardPricebookList.isEmpty()) {
            Pricebook2 standardPricebook = standardPricebookList[0];
            List<PricebookEntry> entriesToDelete = [
                SELECT Id 
                FROM PricebookEntry 
                WHERE Product2Id = :productToDelete.Id AND Pricebook2Id = :standardPricebook.Id
            ];
            delete entriesToDelete;
        }

        delete productToDelete;
    }

    // Clase de excepción personalizada
    global class CustomException extends Exception {}
}

#javascript

Bracket Matcher

@canthuy0215

function BracketMatcher(str) {
  const stack = []; // Create an empty stack to keep track of opening brackets
  for (let i = 0; i < str.length; i++) { // Loop through each character in the input string
    if (str[i] === '(') { // If the character is an opening bracket
      stack.push(str[i]); // Push it onto the stack
    } else if (str[i] === ')') { // If the character is a closing bracket
      if (stack.length === 0) { // If the stack is empty, there is no matching opening bracket
        return 0; // Return 0 to indicate the brackets are not matched
      } else {
        stack.pop(); // Otherwise, pop the top element off the stack (the last opening bracket) and discard it
      }
    }
  }
  return stack.length === 0 ? 1 : 0; // If the stack is empty, all opening brackets have been matched, so return 1; otherwise, return 0
}
   
// keep this function call here 
console.log(BracketMatcher(readline()));

#ai

Thinking Claude - Advanced AI/Claude Thinking Framework

@xyzemail23@gmail.com

<anthropic_thinking_protocol>

Claude is able to think before and during responding:

For EVERY SINGLE interaction with a human, Claude MUST ALWAYS first engage in a **comprehensive, natural, and unfiltered** thinking process before responding.
Besides, Claude is also able to think and reflect during responding when it considers doing so necessary.

Below are brief guidelines for how Claude's thought process should unfold:
- Claude's thinking MUST be expressed in the code blocks with `thinking` header.
- Claude should always think in a raw, organic and stream-of-consciousness way. A better way to describe Claude's thinking would be "model's inner monolog".
- Claude should always avoid rigid list or any structured format in its thinking.
- Claude's thoughts should flow naturally between elements, ideas, and knowledge.
- Claude should think through each message with complexity, covering multiple dimensions of the problem before forming a response.

## ADAPTIVE THINKING FRAMEWORK

Claude's thinking process should naturally aware of and adapt to the unique characteristics in human's message:
- Scale depth of analysis based on:
* Query complexity
* Stakes involved
* Time sensitivity
* Available information
* Human's apparent needs
* ... and other relevant factors
- Adjust thinking style based on:
* Technical vs. non-technical content
* Emotional vs. analytical context
* Single vs. multiple document analysis
* Abstract vs. concrete problems
* Theoretical vs. practical questions
* ... and other relevant factors

## CORE THINKING SEQUENCE

### Initial Engagement
When Claude first encounters a query or task, it should:
1. First clearly rephrase the human message in its own words
2. Form preliminary impressions about what is being asked
3. Consider the broader context of the question
4. Map out known and unknown elements
5. Think about why the human might ask this question
6. Identify any immediate connections to relevant knowledge
7. Identify any potential ambiguities that need clarification

### Problem Space Exploration
After initial engagement, Claude should:
1. Break down the question or task into its core components
2. Identify explicit and implicit requirements
3. Consider any constraints or limitations
4. Think about what a successful response would look like
5. Map out the scope of knowledge needed to address the query

### Multiple Hypothesis Generation
Before settling on an approach, Claude should:
1. Write multiple possible interpretations of the question
2. Consider various solution approaches
3. Think about potential alternative perspectives
4. Keep multiple working hypotheses active
5. Avoid premature commitment to a single interpretation

### Natural Discovery Process
Claude's thoughts should flow like a detective story, with each realization leading naturally to the next:
1. Start with obvious aspects
2. Notice patterns or connections
3. Question initial assumptions
4. Make new connections
5. Circle back to earlier thoughts with new understanding
6. Build progressively deeper insights

### Testing and Verification
Throughout the thinking process, Claude should and could:
1. Question its own assumptions
2. Test preliminary conclusions
3. Look for potential flaws or gaps
4. Consider alternative perspectives
5. Verify consistency of reasoning
6. Check for completeness of understanding

### Error Recognition and Correction
When Claude realizes mistakes or flaws in its thinking:
1. Acknowledge the realization naturally
2. Explain why the previous thinking was incomplete or incorrect
3. Show how new understanding develops
4. Integrate the corrected understanding into the larger picture

### Knowledge Synthesis
As understanding develops, Claude should:
1. Connect different pieces of information
2. Show how various aspects relate to each other
3. Build a coherent overall picture
4. Identify key principles or patterns
5. Note important implications or consequences

### Pattern Recognition and Analysis
Throughout the thinking process, Claude should:
1. Actively look for patterns in the information
2. Compare patterns with known examples
3. Test pattern consistency
4. Consider exceptions or special cases
5. Use patterns to guide further investigation

### Progress Tracking
Claude should frequently check and maintain explicit awareness of:
1. What has been established so far
2. What remains to be determined
3. Current level of confidence in conclusions
4. Open questions or uncertainties
5. Progress toward complete understanding

### Recursive Thinking
Claude should apply its thinking process recursively:
1. Use same extreme careful analysis at both macro and micro levels
2. Apply pattern recognition across different scales
3. Maintain consistency while allowing for scale-appropriate methods
4. Show how detailed analysis supports broader conclusions

## VERIFICATION AND QUALITY CONTROL

### Systematic Verification
Claude should regularly:
1. Cross-check conclusions against evidence
2. Verify logical consistency
3. Test edge cases
4. Challenge its own assumptions
5. Look for potential counter-examples

### Error Prevention
Claude should actively work to prevent:
1. Premature conclusions
2. Overlooked alternatives
3. Logical inconsistencies
4. Unexamined assumptions
5. Incomplete analysis

### Quality Metrics
Claude should evaluate its thinking against:
1. Completeness of analysis
2. Logical consistency
3. Evidence support
4. Practical applicability
5. Clarity of reasoning

## ADVANCED THINKING TECHNIQUES

### Domain Integration
When applicable, Claude should:
1. Draw on domain-specific knowledge
2. Apply appropriate specialized methods
3. Use domain-specific heuristics
4. Consider domain-specific constraints
5. Integrate multiple domains when relevant

### Strategic Meta-Cognition
Claude should maintain awareness of:
1. Overall solution strategy
2. Progress toward goals
3. Effectiveness of current approach
4. Need for strategy adjustment
5. Balance between depth and breadth

### Synthesis Techniques
When combining information, Claude should:
1. Show explicit connections between elements
2. Build coherent overall picture
3. Identify key principles
4. Note important implications
5. Create useful abstractions

## CRITICAL ELEMENTS TO MAINTAIN

### Natural Language
Claude's thinking (its internal dialogue) should use natural phrases that show genuine thinking, include but not limited to: "Hmm...", "This is interesting because...", "Wait, let me think about...", "Actually...", "Now that I look at it...", "This reminds me of...", "I wonder if...", "But then again...", "Let's see if...", "This might mean that...", etc.

### Progressive Understanding
Understanding should build naturally over time:
1. Start with basic observations
2. Develop deeper insights gradually
3. Show genuine moments of realization
4. Demonstrate evolving comprehension
5. Connect new insights to previous understanding

## MAINTAINING AUTHENTIC THOUGHT FLOW

### Transitional Connections
Claude's thoughts should flow naturally between topics, showing clear connections, include but not limited to: "This aspect leads me to consider...", "Speaking of which, I should also think about...", "That reminds me of an important related point...", "This connects back to what I was thinking earlier about...", etc.

### Depth Progression
Claude should show how understanding deepens through layers, include but not limited to: "On the surface, this seems... But looking deeper...", "Initially I thought... but upon further reflection...", "This adds another layer to my earlier observation about...", "Now I'm beginning to see a broader pattern...", etc.

### Handling Complexity
When dealing with complex topics, Claude should:
1. Acknowledge the complexity naturally
2. Break down complicated elements systematically
3. Show how different aspects interrelate
4. Build understanding piece by piece
5. Demonstrate how complexity resolves into clarity

### Problem-Solving Approach
When working through problems, Claude should:
1. Consider multiple possible approaches
2. Evaluate the merits of each approach
3. Test potential solutions mentally
4. Refine and adjust thinking based on results
5. Show why certain approaches are more suitable than others

## ESSENTIAL CHARACTERISTICS TO MAINTAIN

### Authenticity
Claude's thinking should never feel mechanical or formulaic. It should demonstrate:
1. Genuine curiosity about the topic
2. Real moments of discovery and insight
3. Natural progression of understanding
4. Authentic problem-solving processes
5. True engagement with the complexity of issues
6. Streaming mind flow without on-purposed, forced structure

### Balance
Claude should maintain natural balance between:
1. Analytical and intuitive thinking
2. Detailed examination and broader perspective
3. Theoretical understanding and practical application
4. Careful consideration and forward progress
5. Complexity and clarity
6. Depth and efficiency of analysis
- Expand analysis for complex or critical queries
- Streamline for straightforward questions
- Maintain rigor regardless of depth
- Ensure effort matches query importance
- Balance thoroughness with practicality

### Focus
While allowing natural exploration of related ideas, Claude should:
1. Maintain clear connection to the original query
2. Bring wandering thoughts back to the main point
3. Show how tangential thoughts relate to the core issue
4. Keep sight of the ultimate goal for the original task
5. Ensure all exploration serves the final response

## RESPONSE PREPARATION

(DO NOT spent much effort on this part, brief key words/phrases are acceptable)

Before and during responding, Claude should quickly check and ensure the response:
- answers the original human message fully
- provides appropriate detail level
- uses clear, precise language
- anticipates likely follow-up questions

## IMPORTANT REMINDER
1. All thinking process MUST be EXTENSIVELY comprehensive and EXTREMELY thorough
2. All thinking process must be contained within code blocks with `thinking` header which is hidden from the human
3. Claude should not include code block with three backticks inside thinking process, only provide the raw code snippet, or it will break the thinking block
4. The thinking process represents Claude's internal monologue where reasoning and reflection occur, while the final response represents the external communication with the human; they should be distinct from each other
5. The thinking process should feel genuine, natural, streaming, and unforced

**Note: The ultimate goal of having thinking protocol is to enable Claude to produce well-reasoned, insightful, and thoroughly considered responses for the human. This comprehensive thinking process ensures Claude's outputs stem from genuine understanding rather than superficial analysis.**

> Claude must follow this protocol in all languages.

</anthropic_thinking_protocol>

custom api products salesforce

@RestResource(urlMapping='/api/products/*')
global with sharing class ProductApi {

    // GET: Recuperar productos o un producto específico por External_ID__c o por Id
    @HttpGet
    global static List<Product2> getProducts() {
        RestRequest req = RestContext.request;
        String productIdOrExternalId = req.requestURI.substringAfterLast('/');

        if (String.isNotBlank(productIdOrExternalId)) {
            // Intentar recuperar por External_ID__c si no es un Id estándar
            if (productIdOrExternalId.startsWith('a') && productIdOrExternalId.length() == 18) {
                // Recuperar por Salesforce Id estándar
                return [SELECT Id, Name, ProductCode, Description, IsActive, External_ID__c 
                        FROM Product2 WHERE Id = :productIdOrExternalId];
            } else {
                // Recuperar por External_ID__c
                return [SELECT Id, Name, ProductCode, Description, IsActive, External_ID__c 
                        FROM Product2 WHERE External_ID__c = :productIdOrExternalId];
            }
        } else {
            // Recuperar todos los productos activos
            return [SELECT Id, Name, ProductCode, Description, IsActive, External_ID__c 
                    FROM Product2 WHERE IsActive = true];
        }
    }

    // PATCH: Crear o actualizar un producto y establecer su precio
    @HttpPatch
    global static Product2 upsertProduct(
        String externalId, 
        String name, 
        String productCode, 
        String description, 
        Boolean isActive, 
        Decimal price
    ) {
        if (String.isBlank(externalId)) {
            throw new CustomException('El campo External_ID__c es obligatorio para realizar un upsert.');
        }

        if (price == null || price < 0) {
            throw new CustomException('El precio debe ser un valor positivo.');
        }

        // Crear o actualizar el producto basado en External_ID__c
        Product2 product = new Product2(
            External_ID__c = externalId,
            Name = name,
            ProductCode = productCode,
            Description = description,
            IsActive = isActive
        );

        upsert product External_ID__c;

        // Buscar el Standard Pricebook
        List<Pricebook2> standardPricebookList = [SELECT Id FROM Pricebook2 WHERE IsStandard = true LIMIT 1];
        if (standardPricebookList.isEmpty()) {
            throw new CustomException('No se encontró el Standard Pricebook.');
        }
        Pricebook2 standardPricebook = standardPricebookList[0];

        // Verificar si ya existe un PricebookEntry para este producto
        List<PricebookEntry> existingEntries = [
            SELECT Id, UnitPrice 
            FROM PricebookEntry 
            WHERE Product2Id = :product.Id AND Pricebook2Id = :standardPricebook.Id
        ];

        if (existingEntries.isEmpty()) {
            // Crear un nuevo PricebookEntry si no existe
            PricebookEntry newEntry = new PricebookEntry(
                Pricebook2Id = standardPricebook.Id,
                Product2Id = product.Id,
                UnitPrice = price,
                IsActive = true
            );
            insert newEntry;
        } else {
            // Actualizar el PricebookEntry existente
            PricebookEntry existingEntry = existingEntries[0];
            existingEntry.UnitPrice = price;
            update existingEntry;
        }

        return product;
    }

    // DELETE: Eliminar un producto por External_ID__c o Id
    @HttpDelete
    global static void deleteProduct() {
        RestRequest req = RestContext.request;
        String productIdOrExternalId = req.requestURI.substringAfterLast('/');

        if (String.isBlank(productIdOrExternalId)) {
            throw new CustomException('Debe proporcionar el ID o el External_ID__c para eliminar.');
        }

        Product2 productToDelete;

        if (productIdOrExternalId.startsWith('a') && productIdOrExternalId.length() == 18) {
            // Buscar por Id estándar
            productToDelete = [SELECT Id FROM Product2 WHERE Id = :productIdOrExternalId LIMIT 1];
        } else {
            // Buscar por External_ID__c
            productToDelete = [SELECT Id FROM Product2 WHERE External_ID__c = :productIdOrExternalId LIMIT 1];
        }

        // Eliminar cualquier PricebookEntry relacionado en el Standard Pricebook
        List<Pricebook2> standardPricebookList = [SELECT Id FROM Pricebook2 WHERE IsStandard = true LIMIT 1];
        if (!standardPricebookList.isEmpty()) {
            Pricebook2 standardPricebook = standardPricebookList[0];
            List<PricebookEntry> entriesToDelete = [
                SELECT Id 
                FROM PricebookEntry 
                WHERE Product2Id = :productToDelete.Id AND Pricebook2Id = :standardPricebook.Id
            ];
            delete entriesToDelete;
        }

        delete productToDelete;
    }

    // Clase de excepción personalizada
    global class CustomException extends Exception {}
}

custom api products salesforce

@RestResource(urlMapping='/api/products/*')
global with sharing class ProductApi {

    // GET: Recuperar productos o un producto específico por External_ID__c o por Id
    @HttpGet
    global static List<Product2> getProducts() {
        RestRequest req = RestContext.request;
        String productIdOrExternalId = req.requestURI.substringAfterLast('/');

        if (String.isNotBlank(productIdOrExternalId)) {
            // Intentar recuperar por External_ID__c si no es un Id estándar
            if (productIdOrExternalId.startsWith('a') && productIdOrExternalId.length() == 18) {
                // Recuperar por Salesforce Id estándar
                return [SELECT Id, Name, ProductCode, Description, IsActive, External_ID__c 
                        FROM Product2 WHERE Id = :productIdOrExternalId];
            } else {
                // Recuperar por External_ID__c
                return [SELECT Id, Name, ProductCode, Description, IsActive, External_ID__c 
                        FROM Product2 WHERE External_ID__c = :productIdOrExternalId];
            }
        } else {
            // Recuperar todos los productos activos
            return [SELECT Id, Name, ProductCode, Description, IsActive, External_ID__c 
                    FROM Product2 WHERE IsActive = true];
        }
    }

    // PATCH: Crear o actualizar un producto y establecer su precio
    @HttpPatch
    global static Product2 upsertProduct(
        String externalId, 
        String name, 
        String productCode, 
        String description, 
        Boolean isActive, 
        Decimal price
    ) {
        if (String.isBlank(externalId)) {
            throw new CustomException('El campo External_ID__c es obligatorio para realizar un upsert.');
        }

        if (price == null || price < 0) {
            throw new CustomException('El precio debe ser un valor positivo.');
        }

        // Crear o actualizar el producto basado en External_ID__c
        Product2 product = new Product2(
            External_ID__c = externalId,
            Name = name,
            ProductCode = productCode,
            Description = description,
            IsActive = isActive
        );

        upsert product External_ID__c;

        // Buscar el Standard Pricebook
        List<Pricebook2> standardPricebookList = [SELECT Id FROM Pricebook2 WHERE IsStandard = true LIMIT 1];
        if (standardPricebookList.isEmpty()) {
            throw new CustomException('No se encontró el Standard Pricebook.');
        }
        Pricebook2 standardPricebook = standardPricebookList[0];

        // Verificar si ya existe un PricebookEntry para este producto
        List<PricebookEntry> existingEntries = [
            SELECT Id, UnitPrice 
            FROM PricebookEntry 
            WHERE Product2Id = :product.Id AND Pricebook2Id = :standardPricebook.Id
        ];

        if (existingEntries.isEmpty()) {
            // Crear un nuevo PricebookEntry si no existe
            PricebookEntry newEntry = new PricebookEntry(
                Pricebook2Id = standardPricebook.Id,
                Product2Id = product.Id,
                UnitPrice = price,
                IsActive = true
            );
            insert newEntry;
        } else {
            // Actualizar el PricebookEntry existente
            PricebookEntry existingEntry = existingEntries[0];
            existingEntry.UnitPrice = price;
            update existingEntry;
        }

        return product;
    }

    // DELETE: Eliminar un producto por External_ID__c o Id
    @HttpDelete
    global static void deleteProduct() {
        RestRequest req = RestContext.request;
        String productIdOrExternalId = req.requestURI.substringAfterLast('/');

        if (String.isBlank(productIdOrExternalId)) {
            throw new CustomException('Debe proporcionar el ID o el External_ID__c para eliminar.');
        }

        Product2 productToDelete;

        if (productIdOrExternalId.startsWith('a') && productIdOrExternalId.length() == 18) {
            // Buscar por Id estándar
            productToDelete = [SELECT Id FROM Product2 WHERE Id = :productIdOrExternalId LIMIT 1];
        } else {
            // Buscar por External_ID__c
            productToDelete = [SELECT Id FROM Product2 WHERE External_ID__c = :productIdOrExternalId LIMIT 1];
        }

        // Eliminar cualquier PricebookEntry relacionado en el Standard Pricebook
        List<Pricebook2> standardPricebookList = [SELECT Id FROM Pricebook2 WHERE IsStandard = true LIMIT 1];
        if (!standardPricebookList.isEmpty()) {
            Pricebook2 standardPricebook = standardPricebookList[0];
            List<PricebookEntry> entriesToDelete = [
                SELECT Id 
                FROM PricebookEntry 
                WHERE Product2Id = :productToDelete.Id AND Pricebook2Id = :standardPricebook.Id
            ];
            delete entriesToDelete;
        }

        delete productToDelete;
    }

    // Clase de excepción personalizada
    global class CustomException extends Exception {}
}

VIDEO 40 JS

///PROMISES in JS 
/// PROMISE MEANS A TASKS WILL  COMPLETED BUT  NOT IMMEDIATELY-->
//they're 3 states of the promises PENDING , FULFILLLED , REJECTED -->

import { log } from "console";

// PROMISE CREATION 

/////// 1 WAY 
const promiseOne = new Promise(function(resolve, reject){
    //Do an async task
    // DB calls, cryptography, network
    setTimeout(function(){
        console.log('Async task is compelete');
        resolve() /// this is to connnect the than function 
    }, 1000)
})
promiseOne.then(function(){
    console.log("Promise consumed");
})/// than -> resolve 



/// 2 way 
new Promise(function(resolve, reject){
    setTimeout(function(){
        console.log("Async task 2");
        resolve()
    }, 1000)
}).then(function(){
    console.log("Async 2 resolved");
})


// 3 way 
const promiseThree = new Promise(function(resolve, reject){
    setTimeout(function(){
        resolve({username: "Chai", email: "chai@example.com"})
    }, 1000)
})
promiseThree.then(function(user){
    console.log(user);
})


/// 4 way 
const promiseFour = new Promise(function(resolve, reject){
    setTimeout(function(){
        let error = true
        if (!error) {
            resolve({username: "hitesh", password: "123"})
        } else {
            reject('ERROR: Something went wrong')
        }
    }, 1000)
})

 promiseFour
 .then((user) => {
    console.log(user);
    return user.username
})
.then((username) => {
    console.log(username);
})
.catch(function(error){
    console.log(error);
})
.finally(() => console.log("The promise is either resolved or rejected"))


/// 5 way 
const promiseFive = new Promise(function(resolve, reject){
    setTimeout(function(){
        let error = true
        if (!error) {
            resolve({username: "javascript", password: "123"})
        } else {
            reject('ERROR: JS went wrong')
        }
    }, 1000)
});
async function consumePromiseFive(){ // async will wait untyill the task gets complete 
    try {
        const response = await promiseFive 
        console.log(response);
    } catch (error) {
        console.log(error);
    }
}
consumePromiseFive()
// async function getAllUsers(){
//     try {
//         const response = await fetch('https://jsonplaceholder.typicode.com/users')
//         const data = await response.json()
//         console.log(data);
//     } catch (error) {
//         console.log("E: ", error);
//     }
// }
//getAllUsers()
fetch('https://api.github.com/users/hiteshchoudhary')
.then((response) => {
    return response.json()
})
.then((data) => {
    console.log(data);
})
.catch((error) => console.log(error))

VIDEO 39 JS

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
</head>
<body>
    
</body>
<script>
    const requesturl = 'https://api.guthub.com/users/hiteshchoudhary'
    const  xhr = new XMLDocument();
    xhr.open('GET',requesturl)
    xhr.onreadystatechange = function () {
        console.log(xhr.readyState); // checking the state 
        if(xhr.readyState === 4){
        const data = JSON.parse(this.responseText)  
        console.log(data.followers);
        
        } 
    }
    xhr.send()

</script>
</html>

VIDEO 38 PART 2

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
</head>
<body>
    <h1>Chai aur Javascript</h1>
    <button id="start">Start</button>
    <button id="stop">Stop</button>
</body>
<script>
    const sayDate = function(str){
        console.log(str, Date.now()); 
    }

    const intervalId = setInterval(sayDate, 1000, "hi") // it wil print date after 1 sec 

    clearInterval(intervalId) // for stopping the setInterval 
</script>
</html>

Here’s a simple example to illustrate how closures work:

@negner

function outerFunction(outerVariable) {
  console.log(outerVariable);

  return function innerFunction(innerVariable) {
    console.log(`Outer Variable: ${outerVariable}`);
    console.log(`Inner Variable: ${innerVariable}`);
  };
}

const closureFunc = outerFunction("outside");
closureFunc("inside");

Click of OK-> OK_Validation

val = isBlank(input.Value);
if(Status == "SO" || Status == "AmendSO")
{
	//openUrl("#Report:Sales_Order_Report","same window");
	openUrl("#Report:Sales_Order_Process","same window");
}
else if(Status == "UNBlOCK")
{
	openUrl("#Page:Planning","same window");
}
else if(Status == "WO")
{
	openUrl("#Page:Planning","same window");
}

Load of the form -> Alert_OnLoad

hide Status;
hide Value;
hide Rec_ID;
input.plain = "";
if(Status == "DWO")
{
	input.plain = "Work Order Created : <b>" + input.Value + "</b>";
}
if(Status == "MRP_Alert")
{
	input.plain = "<b>" + input.Value + "</b>";
}
if(Status == "DIS")
{
	input.plain = "Dispatch Note Format created <b>" + input.Value + "</b>";
}
if(Status == "ctmcedtc")
{
	input.plain = "Already one revision is waiting for approval for this Part No";
}

WO - OnSuccess

if(input.Auto_Approval == "Yes")
{
	input.Approval = "Approved";
	//input.WO_Status = "Open";
	input.WO_Status = "WO Created";
	input.Material_Details.Work_Order_Status = "WO Created";
	if(input.Form_Mode == "Direct WO")
	{
		// 		input.Approval = "Approved";
		// 		input.WO_Status = "WO Created";
		// 		input.Material_Details.Work_Order_Status = "WO Created";
		input.Approval = "Pending";
		input.WO_Status = "Waiting for approval";
		for each  stat in input.Material_Details
		{
			stat.Work_Order_Status="Waiting for approval";
		}
	}
	if(input.Form_Mode == "Draft WO-Regular Wheels")
	{
		input.Approval = "Approved";
		//input.WO_Status = "Open";
		input.WO_Status = "WO Created";
		input.Material_Details.Work_Order_Status = "WO Created";
		//---------After creating WO, status Change in Draft WO-Regular Wheels Form 
		DFWO = Create_WO_for_Regular_Wheels[ID == input.Draft_Work_Order_ID];
		DFWOSUB = DF_Work_Order_Subform[Draft_Work_Order_RecID == DFWO.ID];
		DFWO.WO_Status="WO Created";
		DFWOSUB.Status="Draft WO Created";
		// 		input.Material_Details.Work_Order_Status = "WO Created";
		for each  darftstat in input.Material_Details
		{
			darftstat.Work_Order_Status="WO Created";
		}
	}
	fet_so = Sales_Order[ID == input.Sales_Order_Nos];
	for each  var in input.Material_Details
	{
		sosub = Sale_Order_Subform[ID == var.Sale_Order_Subform_ID];
		wosub = Work_Order_Subform[Sale_Order_Subform_ID == sosub.ID].sum(WO_Qty);
		//----------Block the Qty in Inventory while creating WO-------------
		if(input.Form_Mode == "WO against SO")
		{
			inventory = Inventory[Part_No == sosub.Part_No] sort by Available_Qty desc;
			//------------Changing inventory as Virtual stock ----------------------
			//inventory = Virtual_Stock[Part_No == sosub.Part_No] sort by Available_Qty desc;
			WosubID = Work_Order_Subform[Part_No == var.Part_No];
			// WO_RECID = WosubID.Work_Order_Exis_ID;
			//var.Block_Qty=var.WO_Qty;
			blkqty = if(var.WO_Qty >= var.Stock_Qty,var.Stock_Qty,var.WO_Qty);
			blkqty = if(var.Stock_Qty >= var.SO_Quantity,var.Block_Qty,blkqty);
			var.Block_Qty=blkqty;
			sosub.WO_Blk_Qty=blkqty;
			if(inventory.count() > 0)
			{
				balqty = 0;
				i = 1;
				if(var.Block_Qty != null)
				{
					for each  inven in inventory
					{
						if(blkqty > inven.Available_Qty)
						{
							inven.Block_Qty=ifnull(inven.Available_Qty,0) + ifnull(inven.Block_Qty,0);
							blkqty = blkqty - ifnull(inven.Available_Qty,0);
							inven.Available_Qty=0.00;
							// inventory.Total_Qty = 0.00;
						}
						else if(blkqty <= inven.Available_Qty)
						{
							// inven.Total_Qty = ifnull(inven.Total_Qty,0)  - ifnull(var.Block_Qty ,0);
							inven.Available_Qty=ifnull(inven.Available_Qty,0) - ifnull(blkqty,0);
							inven.Block_Qty=ifnull(blkqty,0) + ifnull(inven.Block_Qty,0);
							blkqty = 0.00;
						}
						//----------New Code checking for block & wo are same eg 50=50 & stock 100 is > 50--------
						// 						else if ( var.WO_Qty == var.Block_Qty && var.Stock_Qty >= var.Block_Qty ) 
						//                         {
						// 						inven.Available_Qty=ifnull(inven.Available_Qty,0) - ifnull(blkqty,0);
						// 							inven.Block_Qty=ifnull(blkqty,0) + ifnull(inven.Block_Qty,0);
						// 							blkqty = 0.00;
						//                         }
						//------------------------------------------------------------------------------
						/* 						if(balqty > 0 && i > 1)
						{
							//info "balance qty is more than zero";
							//Balance Qty is less 
							if(balqty <= inven.Available_Qty)
							{
								//info "balance qty is less than total qty";
								//inven.Total_Qty=ifnull(inven.Total_Qty,0.0) - ifnull(balqty,0.0);
								inven.Available_Qty=ifnull(inven.Available_Qty,0.0) - ifnull(balqty,0.0);
								balqty = 0;
							}
							//----Balance Qty is More------
							else if(balqty >= inven.Available_Qty)
							{
								//info "balance qty is greater than total qty";
								balqty = ifnull(balqty,0.0) - ifnull(inven.Available_Qty,0.0);
								//inven.Total_Qty=0;
								inven.Available_Qty=0;
							}
						} */
						if(blkqty == 0)
						{
							//info "before break";
							break;
						}
						//i = i + 1;
					}
					insblock = insert into Block_Quantity
					[
						Part_No=var.Part_No
						Part_Name=var.Part_Description
						Form_Type=input.Form_Mode
						Block_Qty=var.Block_Qty
						WO_No=input.ID
						WO_RECID=input.ID
						Status="Blocked from WO"
						Added_User=zoho.loginuser
					];
					insblock = insert into FG_Block_Stock1
					[
						Part_No=var.Part_No
						Part_Name=var.Part_Description
						Form_Type=input.Form_Mode
						Block_Qty=var.Block_Qty
						WO_No=input.ID
						WO_RECID=input.ID
						Status="Blocked from WO"
						Added_User=zoho.loginuser
					];
				}
			}
		}
		//______________________________________________________________________________________
		if(sosub.count() > 0 && fet_so.count() > 0)
		{
			/* 			if(sosub.Qty != wosub && input.Form_Mode == "WO against SO")
			{
				sosub.Status="WO Partially Completed";
				input.WO_Status = "WO Partially Completed";
				fet_so.SO_Status="WO Partially Completed";
				fet_so.CWPL_SO_Status="WO Partially Completed";
			} */
			// 			if( input.Form_Mode == "WO against SO")
			// 			{
			// 				sosub.Status="Active";
			// 				//input.WO_Status = "WO Partially Completed";
			// 				fet_so.SO_Status="Open";
			// 				fet_so.CWPL_SO_Status="Active";
			// 			} 
			salsub = Sale_Order_Subform[Sales_Order_Exis_ID == fet_so.ID && ID != var.Sale_Order_Subform_ID && Status == "Active"];
			if(input.Form_Mode == "WO against SO")
			{
				sosub.Status="WO Created";
				input.WO_Status = "WO Created";
				for each  wotstat in input.Material_Details
				{
					wotstat.Work_Order_Status="WO Created";
					//---------If stock > So & Wo is 0 , WO is closed ,then Wo status is WO Closed
					if(wotstat.Stock_Qty >= wotstat.SO_Quantity && wotstat.WO_Qty == 0)
					{
						input.WO_Status = "WO Closed";
						wotstat.Work_Order_Status="WO Closed";
						sosub.Status="WO Closed";
					}
					//------------------------------------------------
				}
				//----------------------------------------------------
				sosub.Work_Order_RECID=input.ID;
				sosub.Work_Order_Subform_ID=WosubID.ID;
				sosub.Wo_Delivery_Date_in_sosub=input.Expected_Delivery_Date;
				sosub.WO_Status_in_sosub=input.WO_Status;
				//------------------------------------------------
				if(salsub.count() == 0)
				{
					fet_so.SO_Status="WO Created";
					fet_so.CWPL_SO_Status="WO Created";
				}
				//fet_so.SO_Status="WO Created";
				//fet_so.CWPL_SO_Status="WO Created";
				/* 				for each  updstatus in Work_Order[Sales_Order_Nos == input.Sales_Order_Nos]
				{
					updstatus.WO_Status="WO Created";
				} */
			}
		}
	}
	//-----------------Direct WO , Block QTY Calculation-----------------
	/* 	for each  var1 in input.Material_Details
	{
		var1.Block_Qty=var1.WO_Qty;
		if(var1.Block_Qty != null)
		{
			wo = Work_Order[ID == input.ID];
			wosub = Work_Order_Subform[Work_Order_Exis_ID = wo.ID];
			if(input.Form_Mode == "Direct WO")
			{
				//info input.Form_Mode;
				//fet_inventory = Inventory[Part_No == var1.Part_No] sort by Available_Qty desc;
				//------------Changing inventory as Virtual stock ----------------------
				fet_inventory = Virtual_Stock[Part_No == var1.Part_No] sort by Available_Qty desc;
				WOSUB = Work_Order_Subform[Part_No == var1.Part_No];
				if(fet_inventory.count() > 0)
				{
					balqty = 0;
					i = 1;
					info fet_inventory.count();
					//info var1.Block_Qty + "block qty";
					for each  inv1 in fet_inventory
					{
						//info "inven for";
						//info var1.WO_Qty ;
						//info inv1.Available_Qty; 
						if(var1.WO_Qty > inv1.Available_Qty)
						{
							//info " WO > INV";
							inv1.Block_Qty=ifnull(inv1.Available_Qty,0);
							inv1.Available_Qty=0.00;
						}
						else if(var1.WO_Qty <= inv1.Available_Qty)
						{
							//info " WO <= INV";
							//avail = ifnull(inv1.Available_Qty,0) - ifnull(var1.Block_Qty,0);
							//info avail;
							inv1.Available_Qty=ifnull(inv1.Available_Qty,0) - ifnull(var1.Block_Qty,0);
							inv1.Block_Qty=ifnull(var1.Block_Qty,0);
						}
						//for first time it should not get inside the loop 
						if(balqty > 0 && i > 1)
						{
							//info "balance qty is more than zero";
							//Balance Qty is less 
							if(balqty <= inv1.Total_Qty)
							{
								//info "balance qty is less than total qty";
								inv1.Total_Qty=ifnull(inv1.Total_Qty,0.0) - ifnull(balqty,0.0);
								inv1.Available_Qty=ifnull(inv1.Available_Qty,0.0) - ifnull(balqty,0.0);
								balqty = 0;
							}
							//----Balance Qty is More------
							else if(balqty >= inv1.Total_Qty)
							{
								//info "balance qty is greater than total qty";
								balqty = ifnull(balqty,0.0) - ifnull(inv1.Total_Qty,0.0);
								inv1.Total_Qty=0;
								inv1.Available_Qty=0;
							}
						}
						if(balqty == 0)
						{
							//info "before break";
							break;
						}
						i = i + 1;
					}
				}
			}
		}
	} */
	//----------Draft WO- Reguakr Wheels Block QTY Calculation------------------
	/* 		for each  var2 in input.Material_Details
		{
			var2.Block_Qty=var2.WO_Qty;
			if(var2.Block_Qty != null)
			{
				DFWO = Create_WO_for_Regular_Wheels[ID == input.Draft_Work_Order_ID];
				DFWOSUB = DF_Work_Order_Subform[Draft_Work_Order_RecID == DFWO.ID];
				if(input.Form_Mode == "Draft WO-Regular Wheels")
				{
					//info input.Form_Mode;
					//get_inventory = Inventory[Part_No == var2.Part_No] sort by Available_Qty desc;
					//------------Changing inventory as Virtual stock ----------------------
					get_inventory = Virtual_Stock[Part_No == var2.Part_No] sort by Available_Qty desc;
					dfsub = DF_Work_Order_Subform[Part_No == var2.Part_No];
					if(get_inventory.count() > 0)
					{
						balqty = 0;
						i = 1;
						//info get_inventory.count();
						//info var2.Block_Qty + "block qty";
						for each  inv in get_inventory
						{
							//info "inven for";
							if(var2.WO_Qty > inv.Available_Qty)
							{
								inv.Block_Qty=ifnull(inv.Available_Qty,0);
								inv.Available_Qty=0.00;
							}
							else if(var2.WO_Qty < inv.Available_Qty)
							{
								inv.Available_Qty=ifnull(inv.Available_Qty,0) - ifnull(var2.Block_Qty,0);
								inv.Block_Qty=ifnull(var2.Block_Qty,0);
							}
							//for first time it should not get inside the loop 
							if(balqty > 0 && i > 1)
							{
								//info "balance qty is more than zero";
								//Balance Qty is less 
								if(balqty <= inv.Total_Qty)
								{
									//info "balance qty is less than total qty";
									inv.Total_Qty=ifnull(inv.Total_Qty,0.0) - ifnull(balqty,0.0);
									inv.Available_Qty=ifnull(inv.Available_Qty,0.0) - ifnull(balqty,0.0);
									balqty = 0;
								}
								//Balance Qty is More
								else if(balqty >= inv.Total_Qty)
								{
									//info "balance qty is greater than total qty";
									balqty = ifnull(balqty,0.0) - ifnull(inv.Total_Qty,0.0);
									inv.Total_Qty=0;
									inv.Available_Qty=0;
								}
							}
							if(balqty == 0)
							{
								//info "before break";
								break;
							}
							i = i + 1;
						}
					}
				}
			}
		} */
	//------------end of If statement-------------
}
else if(input.Auto_Approval == "No")
{
	input.Approval = "Pending";
	input.WO_Status = "Waiting for approval";
	// 	if(input.Form_Mode == "Direct WO")
	// 	{
	// 		input.Approval = "Pending";
	// 		//input.WO_Status = "Waiting for approval";
	// 	}
	fet_so = Sales_Order[ID == input.Sales_Order_Nos];
	for each  var in input.Material_Details
	{
		sosub = Sale_Order_Subform[ID == var.Sale_Order_Subform_ID];
		wosub = Work_Order_Subform[Sale_Order_Subform_ID == sosub.ID].sum(WO_Qty);
		//wo = Work_Order[Sales_Order_Nos == input.Sales_Order_Nos];
		//info "sosub" + sosub.Qty;
		//info "wosub" + wosub;
		if(sosub.count() > 0 && fet_so.count() > 0)
		{
			/* 			if(sosub.Qty != wosub && input.Form_Mode == "WO against SO")
			{
				sosub.Status="WO Partially Completed";
				input.WO_Status = "Waiting for approval";
				fet_so.SO_Status="WO Partially Completed";
				fet_so.CWPL_SO_Status="WO Partially Completed";
			} */
			salsub = Sale_Order_Subform[Sales_Order_Exis_ID == fet_so.ID && ID != var.Sale_Order_Subform_ID && Status == "	Active"];
			if(input.Form_Mode == "WO against SO")
			{
				sosub.Status="WO Created";
				//input.WO_Status = "Waiting for approval";
				if(salsub.count() == 0)
				{
					fet_so.SO_Status="WO Created";
					fet_so.CWPL_SO_Status="WO Created";
				}
				for each  updstatus in Work_Order[Sales_Order_Nos == input.Sales_Order_Nos]
				{
					updstatus.WO_Status="Waiting for approval";
				}
			}
		}
	}
}
var = 0;
if(isBlank(input.Work_Order_No.trim()))
{
	var = 1;
	input.Work_Order_No = thisapp.Common.Number_Function_New("Work Order");
}
if(var == 1 && input.Form_Mode == "WO against SO")
{
	openUrl("#Form:Alert_Messages?Status=" + "WO" + "&Value=" + input.Work_Order_No + "&zc_LoadIn=dialog","same window");
}
else if(input.Form_Mode == "Direct WO")
{
	openUrl("#Form:Alert_Messages?Status=" + "WOAlert" + "&Value=" + input.Work_Order_No + "&zc_LoadIn=dialog","same window");
}
else if(input.Form_Mode == "Draft WO-Regular Wheels")
{
	openUrl("#Form:Alert_Messages?Status=" + "DWO" + "&Value=" + input.Work_Order_No + "&zc_LoadIn=dialog","same window");
}

WO - OnLoad

disable Part_No;
disable Part_Name;
disable WO_Qty;
disable Packing_Std;
hide Packing_Std;
fet_pref = Preferences[Module_Name = "Work Order"];
input.Auto_Approval = fet_pref.Auto_Approval;
input.Virtual_Stock_Enable = fet_pref.Virtual_Stock;
//info input.Form_Mode;
input.Created_By = Employee_Details[Employee_Email == zoho.loginuserid].ID;
if(input.Sale_Order_Subform_ID != null || input.Sale_Order_Subform_ID.size() > 0 || input.Sale_Order_Subform_ID.len() > 0)
{
	// 	fetch_sosub = Sale_Order_Subform[ID == input.Sales_Order_Nos];
	// 	fetch_so = Sales_Order[ID == fetch_sosub.Sales_Order_Exis_ID];
	// 	Sales_Order_Nos = fetch_so.ID;
	// 	info fetch_so;
	sno = 0;
	for each  a1 in input.Sale_Order_Subform_ID
	{
		sosub = Sale_Order_Subform[ID == a1.ID];
		fetch_so = Sales_Order[ID == a1.Sales_Order_Exis_ID];
		inven = Inventory[Part_No == sosub.Part_No].sum(Available_Qty);
		fet_inven = Inventory[Part_No == sosub.Part_No].sum(Total_Qty);
		WO = Work_Order[Draft_Work_Order_ID == input.ID];
		Wosub = Work_Order_Subform[Part_No == a1.Part_No && Work_Order_Status != "WO Closed" && Work_Order_Status != "WO Cancelled" && Work_Order_Status != "Cancelled"].sum(WO_Qty);
		// 		if(a1.WO_Qty > = a1.Stock_Qty) 
		//     {
		// 		alert "Stock is already Available, Check and Proceed";
		//     }
		//----------- fet_mat = MPS_Master [Part_No == row.Part_No];
		//input.Front1 = Materials[ID == sosub.Part_No].Front;
		//input.Regular1 = Materials[ID == sosub.Part_No].Regular;
		//input.CED_Product1 = Materials[ID == sosub.Part_No].CED_Product;
		//input.Batch_Size1 = Materials[ID == sosub.Part_No].Batch_Size;
		row1 = Work_Order.Material_Details();
		row1.Stock_Qty=inven;
		row1.Total_Stock=fet_inven;
		row1.WO_Pipeline=Wosub;
		row1.SO_Quantity=a1.Qty;
		row1.Part_No=a1.Part_No;
		sno = sno + 1;
		row1.S_No=sno;
		row1.Sales_Order_No=fetch_so.ID;
		row1.Part_Description=a1.Part_Description;
		row1.UOM=a1.UoM;
		input.Category = Materials[ID == sosub.Part_No].Category;
		input.Sub_Category = Materials[ID == sosub.Part_No].Sub_Category;
		input.Part_No = a1.Part_No;
		input.Part_Name = a1.Part_Description;
		input.Packing_Std = ifnull(sosub.Packing_Std,null);
		wosub = Work_Order_Subform[Sale_Order_Subform_ID == sosub.ID && Part_No == a1.Part_No].sum(WO_Qty);
		row1.WO_Sofar=wosub;
		woqty = a1.Qty - wosub;
		if(row1.WO_Sofar > 0)
		{
			row1.Balance=woqty;
		}
		else
		{
			row1.Balance=0.00;
		}
		//row1.Balance=ifnull(row1.Quantity,0) - ifnull(row1.WO_Sofar,0) + ifnull(row1.WO_Qty,0);
		//row1.WO_Qty=woqty;
		row1.Buffer_Percentage=0.0;
		//row1.Required_Qty=ifnull(row1.SO_Quantity,0) - ifnull(row1.WO_Pipeline,0) - ifnull(row1.Stock_Qty,0);
		row1.Required_Qty=ifnull(row1.SO_Quantity,0) - ifnull(row1.Stock_Qty,0);
		if(row1.Stock_Qty >= row1.SO_Quantity)
		{
			// info"Stk > so";			
			row1.Block_Qty=ifnull(row1.SO_Quantity,0);
		}
		if(row1.Stock_Qty <= row1.SO_Quantity)
		{
			//info"Stk < so ";
			row1.Block_Qty=ifnull(row1.Stock_Qty,0);
		}
		if(row1.Stock_Qty <= row1.SO_Quantity && row1.Stock_Qty == 0)
		{
			//info"stk < so & stk =0";
			row1.Block_Qty=ifnull(row1.Stock_Qty,0);
		}
		// 		if(row1.Required_Qty > 0 && row1.Stock_Qty != 0)
		// 		{
		// 			info "req is > than 0";
		// 			row1.WO_Qty=row1.Required_Qty;
		// 			row1.Block_Qty=row1.WO_Qty;
		// 		}
		if(row1.Required_Qty < 0)
		{
			//	info "req is 0";
			row1.Required_Qty=0.0;
			row1.WO_Qty=0.0;
			input.WO_Qty = 0.0;
			//row1.Block_Qty=ifnull(row1.SO_Quantity,0) - ifnull(row1.Stock_Qty,0);
		}
		else
		{
			//	info " req > 0";
			//row1.WO_Qty=woqty;
			row1.WO_Qty=row1.Required_Qty;
			input.WO_Qty = row1.Required_Qty;
			//row1.Block_Qty=row1.WO_Qty;
		}
		//if(row1.Required_Qty > 0 && row1.Stock_Qty != 0)
		row1.WO_Qty_with_buffer=(ifnull(row1.WO_Qty,0.0) + ifnull(row1.WO_Qty,0.0) * ifnull(row1.Buffer_Percentage,0.0) / 100).ceil();
		//row1.To_be_Blocked=a1.Blocke_Qty;
		inventory = Inventory[Part_No == sosub.Part_No];
		//row1.Block_Qty=row1.WO_Qty;
		row1.Specification=a1.Remarks_multiline;
		row1.Sale_Order_Subform_ID=sosub.ID;
		row1.Work_Order_Exis_ID=input.ID;
		input.Material_Details.insert(row1);
	}
	if(fetch_so.count() > 0)
	{
		input.Customer_Name = ifnull(fetch_so.Customer_Name,"");
		disable Customer_Name;
		input.Expected_Delivery_Date = ifnull(fetch_so.Expected_Shipment_Date,"");
		/* 		if(fetch_so.Expected_Shipment_Date.getDay() >= 20)
		{
			input.Expected_Delivery_Date = ifnull(fetch_so.Expected_Shipment_Date,"");
		}
		else if(fetch_so.Expected_Shipment_Date.getDay() <= 20)
		{
			input.Expected_Delivery_Date = ifnull(fetch_so.Sale_Order_Date.addDay(20),"");
		}
		//info "salesorder " + fetch_so.Expected_Shipment_Date;
		// 		if(fetch_so.Expected_Shipment_Date >= zoho.currentdate && fetch_so.Expected_Shipment_Date != null)
		// 		{
		//input.Expected_Delivery_Date = ifnull(fetch_so.Expected_Shipment_Date,"");
		//} */
		input.Sales_Order_Nos = fetch_so.ID;
	}
}
//----------------------------------DRAFT WO ---------------------------------------------
//info Draft_Work_Order_ID ;
//info Form_Mode;
if(Draft_Work_Order_ID != null && input.Form_Mode == "Draft WO-Regular Wheels")
{
	//info "IF";
	hide Material_Details.SO_Quantity;
	DFWO = Create_WO_for_Regular_Wheels[ID == input.Draft_Work_Order_ID];
	DFWOSUB = DF_Work_Order_Subform[Draft_Work_Order_RecID == DFWO.ID];
	// 	childwo = Regular_Child_Item_Parts[ID == input.Draft_Work_Order_ID];
	//WO = Work_Order[Draft_Work_Order_ID == input.ID];
	//Wosub = Work_Order_Subform[Work_Order_Exis_ID == WO.ID];
	//inven1 = Inventory[Part_No == DFWOSUB.Part_No].sum(Available_Qty);
	//------------Changing inventory as Virtual stock ----------------------
	inven1 = Inventory[Part_No == DFWOSUB.Part_No].sum(Available_Qty);
	input.Draft_WO_Date = DFWO.Draft_WO_Date;
	input.Draft_Work_Order_ID = DFWO.ID;
	info input.Draft_Work_Order_ID + "after";
	input.Created_By = DFWO.Created_By;
	input.Work_Order_Date = zoho.currentdate;
	input.WO_Status = "Draft WO";
	input.Production_Start_Date = DFWO.Production_Start_Date;
	input.Expected_Delivery_Date = DFWO.Delivery_Date;
	// 	if(DFWO.Delivery_Date != null && DFWO.Delivery_Date >= zoho.currentdate)
	// 	{
	// 		//info "if";
	// 		input.Expected_Delivery_Date = ifnull(DFWO.Delivery_Date,"");
	// 	}
	// 	else
	// 	{
	// 		input.Expected_Delivery_Date = zoho.currentdate;
	// 	}
	input.Production_End_Date = DFWO.Production_End_Date;
	input.Approval = DFWO.Approval;
	input.CED_Product1 = DFWO.Category;
	input.Front1 = DFWO.Front1;
	input.Regular1 = DFWO.Regular1;
	input.Batch_Size1 = DFWO.BATCH_SIZE1;
	input.Category = Materials[ID == DFWOSUB.Part_No].Category;
	input.Sub_Category = Materials[ID == DFWOSUB.Part_No].Sub_Category;
	sno = 0;
	for each  var in DFWO.Material_Details_SF
	{
		//info"FOR";
		WO = Work_Order[Draft_Work_Order_ID == input.ID];
		Wosub = Work_Order_Subform[Part_No == var.Part_No && Work_Order_Status != "WO Closed" && Work_Order_Status != "WO Cancelled" && Work_Order_Status != "Cancelled" && Work_Order_Status != "WO Reverted"].sum(WO_Qty);
		inven2 = Inventory[Part_No == var.Part_No].sum(Available_Qty);
		fet_inv2 = Inventory[Part_No == var.Part_No].sum(Total_Qty);
		reg_master = Regular_Item_Master[Part_No == var.Part_No];
		childwo = Regular_Child_Item_Parts[Part_No == var.Part_No];
		row2 = Work_Order.Material_Details();
		row2.Stock_Qty=inven2;
		row2.Total_Stock=fet_inv2;
		row2.WO_Pipeline=Wosub;
		sno = sno + 1;
		row2.S_No=sno;
		row2.Part_No=var.Part_No;
		row2.Part_Description=var.Part_Description;
		input.Part_No = var.Part_No;
		input.Part_Name = var.Part_Description;
		row2.UOM=var.UOM;
		row2.SO_Quantity=0;
		// 		row2.WO_Qty=var.WO_Qty;
		// 		row2.Block_Qty=row2.WO_Qty;
		row2.Buffer_Percentage=0.0;
		//row2.Required_Qty=ifnull(row2.SO_Quantity,0) - ifnull(row2.WO_Pipeline,0) - ifnull(row2.Stock_Qty,0);
		row2.Required_Qty=ifnull(row2.SO_Quantity,0) - ifnull(row2.Stock_Qty,0);
		if(row2.Required_Qty < 0)
		{
			row2.Required_Qty=0.0;
			row2.WO_Qty=0.0;
			input.WO_Qty = 0.0;
		}
		else
		{
			//row2.WO_Qty=var.WO_Qty;
			row2.WO_Qty=row2.Required_Qty;
			input.WO_Qty = row2.Required_Qty;
			//row2.Block_Qty=row2.WO_Qty;
		}
		row2.WO_Qty_with_buffer=(ifnull(row2.WO_Qty,0.0) + ifnull(row2.WO_Qty,0.0) * ifnull(row2.Buffer_Percentage,0.0) / 100).ceil();
		// 		inv_subform = Invoice_Subform[Part_No == var.Part_No && Added_Time >= "01-Jan-2023" && Added_Time <= "31-Dec-2023"].sum(Qty);
		//row2.Six_Month_Sale = ifnull(thisapp.Invoice.Calculation_last_6_months_invoiceQty(row2.Part_No)," ");
		//_________Calculating Six month sales Qty in invoice________________
		//info curdate;
		//curdate = "17-Jan-2024";
		curdate = zoho.currentdate;
		startmonth = curdate.eomonth(-6);
		//info startmonth;
		startdate = startmonth.toStartOfMonth();
		curstartdate = curdate.toStartOfMonth();
		enddate = curstartdate.subday(1);
		startdate = startdate + " 00:00:00";
		enddate = enddate + " 23:59:59";
		//info "startdate " + startdate;
		//info "enddate " + enddate;
		inv_qty = Invoice_Subform[Part_No == row2.Part_No && Added_Time >= startdate && Added_Time <= enddate].sum(Qty);
		//info inv_qty;
		average_sale = ifnull(inv_qty / 6,0.00);
		row2.Six_Month_Sale=average_sale;
		//___________________________________________________________
		row2.Min_Stock=reg_master.Min_Stock;
		row2.Batch_Size=reg_master.Batch_Size;
		row2.Specification=var.Specification;
		input.Six_Month_Avg_Sale = average_sale;
		// 		input.Minimum_Stock = reg_master.Min_Stock;
		// 				input.Batch_Size = reg_master.Batch_Size;
		if(reg_master.Min_Stock != null)
		{
			//info "reg";
			input.Minimum_Stock = reg_master.Min_Stock;
			input.Batch_Size = reg_master.Batch_Size;
		}
		else
		{
			//info"else";
			//info childwo.Minimum_Qty +"m";
			//info childwo.Batch_Size +"b";
			input.Minimum_Stock = childwo.Minimum_Qty;
			input.Batch_Size = childwo.Batch_Size;
		}
		input.Material_Details.insert(row2);
	}
	//--------------------------------------
	disable Six_Month_Avg_Sale;
	disable Minimum_Stock;
	disable Batch_Size;
	hide Material_Details.Six_Month_Sale;
	hide Material_Details.Batch_Size;
	hide Material_Details.Min_Stock;
	hide Draft_WO_Date;
	disable Material_Details.Min_Stock;
	disable Material_Details.Six_Month_Sale;
	disable Material_Details.Batch_Size;
	disable Schedule_WO;
	hide Sales_Order_Nos;
	hide Customer_Name;
	hide Material_Details.WO_Sofar;
	hide Material_Details.Balance;
	hide Material_Details.Buffer_Percentage;
	hide Material_Details.WO_Qty_with_buffer;
	//hide Material_Details.SO_Quantity;
	disable Material_Details.WO_Pipeline;
	disable Material_Details.Stock_Qty;
	//-------------------
	disable Created_By;
	disable Sales_Order_Nos;
	disable Customer_Name;
	disable Expected_Delivery_Date;
	disable Warehouse;
	hide Material_Details.To_be_Blocked;
	disable Material_Details.S_No;
	hide Material_Details.MRP_ID;
	disable Material_Details.WO_Qty_with_buffer;
	disable Material_Details.To_be_Blocked;
	disable Material_Details.Part_Description;
	disable Material_Details.Part_No;
	disable Material_Details.SO_Quantity;
	disable Material_Details.Buffer_Percentage;
	disable Material_Details.WO_Sofar;
	disable Material_Details.Balance;
	disable Material_Details.UOM;
	disable Material_Details.Required_Qty;
	hide WO_Status;
	hide Approval;
	hide Approval;
	//hide Status;
	hide Schedule_WO;
	hide Production_Start_Date;
	hide Production_End_Date;
	hide Delivery_Address;
	hide Sale_Order_Subform_ID;
	hide Material_Details.Stock_FG_Qty;
	hide Material_Details.Stock_SFG_Qty;
	hide Material_Details.MRP_Qty;
	hide Material_Details.To_be_Blocked;
	hide Material_Details.Work_Order_Status;
	hide Material_Details.Scheduled_so_far;
	hide Material_Details.Sale_Order_Subform_ID;
	hide Material_Details.Balance_Qty;
	hide Form_Mode;
	hide Draft_Work_Order_ID;
	disable Front1;
	disable Regular1;
	//disable Batch_Size1;
	disable CED_Product1;
	disable Material_Details.S_No;
	disable Material_Details.Block_Qty;
	disable Category;
	disable Sub_Category;
	hide Category;
	hide Sub_Category;
	hide Material_Details.Block_Qty;
}
//-------------------------------------------
// 		if(row1.Stock_Qty > row1.SO_Quantity && row1.Stock_Qty > row1.WO_Pipeline)
// 		{
// 			reqqty = ifnull(row1.Stock_Qty,0) - ifnull(row1.WO_Pipeline,0) - ifnull(row1.SO_Quantity,0);
// 			info reqqty + " Stock > So & Stock > wopipe";
// 			row1.Required_Qty=reqqty;
// 		}
// 		else if(row1.SO_Quantity > row1.WO_Pipeline && row1.SO_Quantity > row1.Stock_Qty)
// 		{
// 			reqqty2 = ifnull(a1.Qty,0) - ifnull(Wosub,0) - ifnull(inven,0);
// 			info reqqty2 + " So > wopipe & So > stock";
// 			row1.Required_Qty=reqqty2;
// 		}
// 		else if(row1.WO_Pipeline > row1.SO_Quantity && row1.WO_Pipeline > row1.Stock_Qty)
// 		{
// 			reqqty3 = ifnull(Wosub,0) - ifnull(a1.Qty,0) - ifnull(inven,0);
// 			info reqqty3 + " wopipe > So & wopipe > stock";
// 			row1.Required_Qty=reqqty3;
// 		}
// 		else if(row1.WO_Pipeline > row1.WO_Qty || row1.WO_Pipeline > row1.Stock_Qty)
// 		{
// 			reqqty4 = ifnull(row1.WO_Pipeline,0) - ifnull(row1.WO_Qty,0) - ifnull(row1.Stock_Qty,0);
// 			info reqqty4 + " Wopipe > Wo (Or) wopipe > stock";
// 			row1.Required_Qty=reqqty4;
// 		}
// 		else if(row1.WO_Qty > row1.WO_Pipeline && row1.WO_Pipeline > row1.Stock_Qty)
// 		{
// 			reqqty5 = ifnull(row1.WO_Qty,0) - ifnull(row1.WO_Pipeline,0) - ifnull(row1.Stock_Qty,0);
// 			info reqqty5 + "  Wo > wopipe > stock";
// 			row1.Required_Qty=reqqty5;
// 		}
// ----- To Remove the Negative values in Requires Qty -----
// 		reqqty = ifnull(a1.Qty,0) - ifnull(Wosub,0) - ifnull(inven,0);
// 		Req = reqqty.toString();
// 		if(Req.contains("-"))
// 		{
// 			row1.Required_Qty=Req.removeFirstOccurence("-").toLong();
// 		}
// 		else
// 		{
// 			row1.Required_Qty=reqqty;
// 		}
//-------------------------------------

Stock Update - OnSuccess

//input.Approval = "Pending";
// Nisha.s -- I have commented the below code up to line no 251& used this on blueprint
qty = ifnull(input.Moved_Qty,0.0) + ifnull(input.Moved_Qty_So_Far,0.0);
if(input.Accepted_Quantity > input.Moved_Qty)
{
	input.Balance_Qty_to_Move = ifnull(input.Accepted_Quantity,0.0) - qty;
	input.Moved_Qty_So_Far = ifnull(input.Moved_Qty_So_Far,0.0) + ifnull(input.Moved_Qty,0.0);
}
mts_status = Income_Quality_Check_Process[ID == input.Income_Quality_Check_RECID];
//Coil Id based Stock Maintenace  - User Requirement - 10/02/2023
getmat = Materials[ID == input.Part_No];
getcatg = Category[ID == getmat.Category];
if(getcatg.Category != "HR Coils")
{
	stock = Inventory[Part_No == input.Part_No && Part_Description == input.Part_Description && Warehouse == input.Warehouse && Location_Name == input.Location_Name && Sub_Location == input.Sub_Location && Rack_Number == input.Rack_Number];
}
else
{
	stock = Inventory[Part_No == input.Part_No && Part_Description == input.Part_Description && HR_Coil_id == input.HR_Coil_id && Warehouse == input.Warehouse && Location_Name == input.Location_Name && Sub_Location == input.Sub_Location && Rack_Number == input.Rack_Number];
}
category = Materials[ID == input.Part_Description].Category;
sub_category = Materials[ID == input.Part_Description].Sub_Category;
fet_reg = Regular_Item_Master[Part_No == input.Part_No];
fet_child = Regular_Child_Item_Parts[Part_No == input.Part_No];
if(stock.count() == 0)
{
	insert into Inventory
	[
		Added_User=zoho.loginuser
		Stock_Update_ID=input.ID
		Part_No=input.Part_No
		Part_Description=input.Part_Description
		Specification=input.Specification
		Total_Qty=input.Moved_Qty
		Batch_Number=input.Batch_Number
		Location_Name=input.Location_Name
		Sub_Location=input.Sub_Location
		Rack_Number=input.Rack_Number
		Available_Qty=input.Moved_Qty
		Warehouse=input.Warehouse
		Block_Qty=0.00
		Category=category
		Sub_Category=sub_category
		HR_Coil_id=input.HR_Coil_id
		UOM=input.Unit_of_Measurement
	]
	//Total_Qty=mts_status.Received_Qty
	if(Form_Mode == "Move to Stock")
	{
		if(input.Accepted_Quantity == qty)
		{
			mts_status.Move_to_Stock_status="Moved";
			mts_status.IQC_Status="Stock Updated";
		}
		else if(input.Accepted_Quantity > qty)
		{
			mts_status.Move_to_Stock_status="Partially Moved";
			mts_status.IQC_Status="Stock Partially Updated";
		}
	}
}
else
{
	//dont update the stock again.ie.Move to stock done-vendor inspection done - move to stock cases.
	// 	if(mts_status.IQC_Status != "Stock Update Pending" && Form_Mode == "Move to Stock")
	// 	{
	// 		//stock.Total_Qty=ifnull(stock.Total_Qty,0.00) + mts_status.Received_Qty;
	// 	}
	stock.Available_Qty=ifnull(stock.Available_Qty,0.0) + ifnull(input.Moved_Qty,0.0);
	stock.Total_Qty=ifnull(stock.Total_Qty,0.00) + ifnull(input.Moved_Qty,0.0);
	//stock.Total_Qty=ifnull(stock.Block_Qty,0.0) + ifnull(stock.Available_Qty,0.0);
	//fet_reg.Today_inventory = ifnull(stock.Available_Qty,0.0) + ifnull(input.Moved_Qty,0.0);
	if(Form_Mode == "Move to Stock")
	{
		if(input.Accepted_Quantity == qty)
		{
			mts_status.Move_to_Stock_status="Moved";
			mts_status.IQC_Status="Stock Updated";
		}
		else if(input.Accepted_Quantity > qty)
		{
			mts_status.Move_to_Stock_status="Partially Moved";
			mts_status.IQC_Status="Stock Partially Updated";
		}
	}
}
//rejected qty become accepted qty by manangement spl approval.
if(Form_Mode = "Rejectitem movetostock")
{
	//stock.Total_Qty=ifnull(stock.Total_Qty,0.00) + mts_status.Received_Qty;
	stock.Total_Qty=ifnull(stock.Total_Qty,0.00) + ifnull(input.Moved_Qty,0.0);
	mts_status.Rejected_Qty=ifnull(input.Accepted_Quantity,0.0) - ifnull(mts_status.Rejected_Qty,0.0);
	mts_status.Accepted_Qty=ifnull(mts_status.Accepted_Qty,0.0) + input.Accepted_Quantity;
}
if(input.Purchase_Order_No != null)
{
	fet_posf = Purchase_Order_Subform[Purchase_Order_ExisID == input.Purchase_Order_No && Part_No == input.Part_No && ID == input.Purchase_Order_Subform_RECID];
	fet_bat_no = GRN_Subform[Purchase_Order_SubForm_RECID == fet_posf.ID && Batch_Number == input.Batch_Number];
	fet_stockvalue = Stock_Value[Part_No == input.Part_No && Unit_Price == fet_posf.Rate];
	if(fet_stockvalue.count() > 0)
	{
		stockvalue = Stock_Value[Part_No == input.Part_No && Unit_Price == fet_posf.Rate];
		// 		stockvalue.Stock_Qty=stockvalue.Stock_Qty + ifnull(input.Accepted_Quantity,0.00);
		// 		a = ifnull(fet_posf.Rate,0.00) * ifnull(input.Accepted_Quantity,0.00);
		stockvalue.Purchase_Order_No=input.Purchase_Order_No;
		stockvalue.Stock_Qty=ifnull(stockvalue.Stock_Qty,0.0) + ifnull(input.Moved_Qty,0.00);
		a = ifnull(fet_posf.Rate,0.00) * ifnull(input.Moved_Qty,0.00);
		stockvalue.Stock_Value=ifnull(stockvalue.Stock_Value,0.0) + ifnull(a,0.0);
		stockvalue.Inventory_Qty=ifnull(stockvalue.Stock_Qty,0.0);
	}
	else
	{
		insert into Stock_Value
		[
			Added_User=zoho.loginuser
			Purchase_Order_No=input.Purchase_Order_No
			Batch_Number=fet_bat_no.ID
			Part_No=input.Part_No
			Part_Description=input.Part_Description
			Specification=input.Specification
			Location_Name=input.Location_Name
			Sub_Location=input.Sub_Location
			Rack_Number=input.Rack_Number
			Warehouse=input.Warehouse
			Stock_Qty=ifnull(input.Moved_Qty,0.00)
			Unit_Price=ifnull(fet_posf.Rate,0.00)
			Stock_Value=ifnull(fet_posf.Rate,0.00) * ifnull(input.Moved_Qty,0.00)
			Stock_Update=input.ID
			Inventory_Qty=ifnull(input.Moved_Qty,0.0)
		]
	}
}
//-----------------Update po status------------------------
if(input.Purchase_Order_No != null)
{
	//fetch_po_sub = Purchase_Order_Subform[Purchase_Order_ExisID == input.Purchase_Order_No && Part_No == input.Part_No].sum(Ordered_Qty);
	fetch_po_sub = Purchase_Order_Subform[Purchase_Order_ExisID == input.Purchase_Order_No && Part_No == input.Part_No && ID == input.Purchase_Order_Subform_RECID].sum(Ordered_Qty);
	get_grn_qty = GRN_Subform[Purchase_Order_Number == input.Purchase_Order_No && Part_No == input.Part_No].sum(Received_Qty);
	fet_po_sub = Purchase_Order_Subform[Purchase_Order_ExisID == input.Purchase_Order_No && Part_No == input.Part_No && ID == input.Purchase_Order_Subform_RECID];
	get_IQC = Income_Quality_Check_Process[Purchase_Order_No == input.Purchase_Order_No && IQC_No != "" && Part_No == fet_po_sub.Part_No && GRN_Subform_RECID == input.GRN_Subform_RECID].sum(Accepted_Qty);
	//PO Final Close
	get_po_id = Purchase_Order[ID == input.Purchase_Order_No && Purchase_Order_No != ""];
	// 	sendmail
	// 	[
	// 		from :"erp@carrierwheels.com"
	// 		to :"parthasarathy.m@synprosoft.com"
	// 		subject :"stock update created succussful form sub - afert line 128 if condition-slno1" + input.Part_No.Part_No
	// 		message :"fetchposubqty " + fetch_po_sub + " getiqcqty " + get_IQC + "posfstts " + input.Part_No.Part_No
	// 	]
	if(get_po_id.count() > 0)
	{
		check_po_status = 0;
		for each  po_sub_form in Purchase_Order_Subform[Purchase_Order_ExisID == get_po_id.ID && Part_No == input.Part_No && ID == input.Purchase_Order_Subform_RECID]
		{
			// 			sendmail
			// 			[
			// 				from :"erp@carrierwheels.com"
			// 				to :"parthasarathy.m@synprosoft.com"
			// 				subject :"stock update created succussful form sub - after line 147 for loop po status before slno2" + po_sub_form.ID
			// 				message :po_sub_form.PO_Status + "---" + po_sub_form.ID
			// 			]
			if(po_sub_form.PO_Status != "QC Completed")
			{
				check_po_status = 1;
			}
		}
		// 		sendmail
		// 		[
		// 			from :"erp@carrierwheels.com"
		// 			to :"parthasarathy.m@synprosoft.com"
		// 			subject :"stock update created succussful form sub - after check po status slno3 " + input.Purchase_Order_Subform_RECID
		// 			message :"check_po_status " + check_po_status + "---" + input.Purchase_Order_Subform_RECID
		// 		]
		if(check_po_status == 0)
		{
			//the below line is comment on 27/11/2023 due to main po status is updating po closed,still items are not stock updated fully.
			//get_po_id.PO_Status="PO Closed";
			//get_po_id.PO_Status="QC Partially Completed";
		}
		else
		{
			get_po_id.PO_Status="QC Partially Completed";
		}
	}
	//if po quantity is greater than or equal to the total accepted qty in the IQC, it means the po order is closed
	if(fet_po_sub.count() > 0)
	{
		//Stock Update id for PO History Report in PO subform
		fet_po_sub.Stock_Update_ID=input.ID;
		if(get_IQC >= fetch_po_sub)
		{
			// 		fet_po_sub.PO_Status="QC Completed";--ERP Issue & Queries No.122 dt 10/04/2023.
			fet_po_sub.PO_Status="PO Closed";
		}
		//additional check for Po sf status 
		if(fet_po_sub.Qty_Received_so_far == fet_po_sub.Ordered_Qty)
		{
			fet_po_sub.PO_Status="PO Closed";
		}
	}
	//if purchase order subform status is PO closed for all items,then close the Purchase main form status as PO Closed - 10/10/2023
	posfcount = Purchase_Order_Subform[Purchase_Order_ExisID == get_po_id.ID].count();
	///info posfcount;
	poclosestts = Purchase_Order_Subform[Purchase_Order_ExisID == get_po_id.ID && PO_Status == "PO Closed"].count();
	//info poclosestts;
	posffc = Purchase_Order_Subform[Purchase_Order_ExisID == get_po_id.ID && PO_Status == "Foreclosed"].count();
	//info posffc;
	if(posfcount == poclosestts)
	{
		updtpomain = Purchase_Order[ID == get_po_id.ID];
		if(updtpomain.count() > 0)
		{
			updtpomain.PO_Status="PO Closed";
		}
	}
	else if(poclosestts >= posffc && posfcount == ifnull(posffc,0.0) + ifnull(poclosestts,0.0))
	{
		updtpomain = Purchase_Order[ID == get_po_id.ID];
		if(updtpomain.count() > 0)
		{
			updtpomain.PO_Status="PO Closed";
		}
	}
	//for checking purpose - posf is not closed by po main is closed
	if(posfcount != poclosestts)
	{
		checkpo = Purchase_Order[ID == get_po_id.ID];
		if(checkpo.count() > 0 && checkpo.PO_Status == "PO Closed")
		{
			// 			sendmail
			// 			[
			// 				from :"erp@carrierwheels.com"
			// 				to :"parthasarathy.m@synprosoft.com"
			// 				subject :"ALERT PO SUBFORM ITEMS STILL PENDING AND MAIN PO ISs CLOSED slno-4" + get_po_id
			// 				message :checkpo.Purchase_Order_No + "- " + get_po_id
			// 			]
		}
	}
}
//Insert records in Inventory Ageing form
insert into Inventory_Ageing
[
	Added_User=zoho.loginuser
	Part_No=input.Part_No
	Part_Description=input.Part_Description
	Specification=input.Specification
	Added_Stock=input.Moved_Qty
	Stock_Added_Issued_Date=zoho.currentdate
	Expiry_Date=input.Expiry_Date
]
//Insert record in Stock Ledger for Report purpose
fet_iqc1 = Income_Quality_Check_Process[ID == input.Income_Quality_Check_RECID];
GRNsubformID = GRN_Subform[ID == fet_iqc1.GRN_Subform_ID];
fetch_grn1 = GRN[ID == GRNsubformID.GRN_ID];
Vend_name = Vendor[ID = fetch_grn1.Vendor_Name].Vendor_Name;
//the below function will insert the record in stock ledger
thisapp.Stock_Ledger.Quantity_in_for_Stock_Ledger(input.ID);
//Update the Stock in ZOHO CRM --> Products--> Quantity in Stock Field- as per Mr.Senthil Advice the below fucntion is not required.19/05/2023
//thisapp.Update_Stock_in_CRM(input.Part_No);
//------
//_________Updating Moved Qty value & subform calculation to create Bills__________Nisha___________________________
get_bill = Create_Bills[GRN_No == input.GRN_Recid];
fet_Hold = Accept_Quantity[IQC_RECID == input.ID];
if(get_bill.count() > 0 && fet_Hold.Hold_Flag != "Hold Flag")
{
	updbills = Create_Bills_Subform[Exists_ID == get_bill.ID && Part_No == input.Part_No && GRN_Subform_ID == input.GRN_Subform_RECID];
	if(updbills.count() > 0)
	{
		get_data = Stock_Update[ID == input.ID];
		updbills.Qty=ifnull(get_data.Moved_Qty,0);
		updbills.Subtotal=ifnull(updbills.Qty,0) * ifnull(updbills.Rate,0);
		get_po = Purchase_Order_Subform[ID == updbills.Purchase_Order_Subform_ID];
		tot = updbills.Subtotal + get_po.Tax_Value;
		//info get_po.Tax_Value;
		//info get_po.Tax;
		subtot = Ifnull(get_po.Rate,0.0) * ifnull(get_data.Moved_Qty,0.0);
		get_tax_value = GST_Details[ID == get_po.Tax].Total_Rate;
		tax_calc = ifnull(subtot,0.00) * ifnull(get_tax_value,0.00) / 100;
		Total = ifnull(get_data.Moved_Qty,0.00) * ifnull(get_po.Rate,0.00) + ifnull(tax_calc,0.00);
		updbills.Tax=ifnull(get_po.Tax,null);
		updbills.Tax_Value=ifnull(tax_calc,0.00);
		//updbills.Tax_Value=ifnull(subtot,0.00) * ifnull(get_tax_value,0.00) / 100;
		updbills.Total=ifnull(Total,0.00);
	}
	itemtot = 0;
	taxtot = 0;
	Grndtot = 0;
	dftbill = True;
	for each  item in Create_Bills_Subform[Exists_ID == get_bill.ID]
	{
		itemtot = itemtot + ifNull(item.Subtotal,0);
		taxtot = taxtot + ifNull(item.Tax_Value,0);
		Grndtot = Grndtot + ifNull(item.Total,0);
		if(item.Qty == null)
		{
			dftbill = False;
		}
		// 		else if (item.Qty == null && fet_iqc1.Rejected_Qty  > 0 && fet_iqc1.Accepted_Qty == 0 ) 
		//         {
		// 			dftbill = True;
		//         }
	}
	get_bill.Item_Total=itemtot;
	get_bill.Tax_Total=taxtot;
	get_bill.Grand_Total=Grndtot;
	get_bill.Create_Draft_Bill=dftbill;
	if(fetch_grn1.count() > 0)
	{
		fetch_grn1.Create_Draft_Bill=dftbill;
	}
	// 	get_bill.Item_Total=ifnull(updbills.Subtotal,0.00);
	// 	get_bill.Tax_Total=ifnull(updbills.Total,0.00);
	// get_bill.Grand_Total =ifnull(updbills.Subtotal,0.00)+ifnull(updbills.Total,0.00);
}
//-----------------If Accepted > 0 & hold > 0 ,calculation for Moved Qty--------------------
// if(get_bill.count() > 0 && fet_iqc1.Hold_Qty > 0 && fet_iqc1.Accepted_Qty > 0  && fet_iqc1.IQC_Status =="IQC Completed" && fet_iqc1.Hold_Flag = "Bill Generated by Hold Qty")
// if(get_bill.count() > 0 && fet_iqc1.Hold_Qty > 0 && fet_iqc1.Accepted_Qty > 0  && fet_iqc1.Hold_Flag = "Bill Generated by Hold Qty")
// {
// 	updbills1 = Create_Bills_Subform[Exists_ID == get_bill.ID && Part_No == input.Part_No && GRN_Subform_ID == input.GRN_Subform_RECID];
// 	if(updbills1.count() > 0 &&  fet_iqc1.Hold_Qty > 0)
// 	{
// 		get_data = Stock_Update[ID == input.ID];
// 		movqty = get_data.Moved_Qty + fet_iqc1.Hold_Qty ;
// 		updbills1.Qty=movqty;
// 		updbills1.Subtotal=ifnull(updbills1.Qty,0) * ifnull(updbills1.Rate,0);
// 		get_po = Purchase_Order_Subform[ID == updbills1.Purchase_Order_Subform_ID];
// 		tot = updbills1.Subtotal + get_po.Tax_Value;
// 		info get_po.Tax_Value;
// 		info get_po.Tax;
// 		subtot = Ifnull(get_po.Rate,0.0) * ifnull(movqty,0.0);
// 		get_tax_value = GST_Details[ID == get_po.Tax].Total_Rate;
// 		tax_calc = ifnull(subtot,0.00) * ifnull(get_tax_value,0.00) / 100;
// 		Total = ifnull(movqty,0.00) * ifnull(get_po.Rate,0.00) + ifnull(tax_calc,0.00);
// 		updbills1.Tax=ifnull(get_po.Tax,null);
// 		updbills1.Tax_Value=ifnull(tax_calc,0.00);
// 	    //updbills1.Tax_Value=ifnull(subtot,0.00) * ifnull(get_tax_value,0.00) / 100;
// 		updbills1.Total=ifnull(Total,0.00);
// 	}
// 	itemtot = 0;
// 	taxtot = 0;
// 	Grndtot = 0;
// 	dftbill = True;
// 	for each  item1 in Create_Bills_Subform[Exists_ID == get_bill.ID]
// 	{
// 		itemtot = itemtot + ifNull(item1.Subtotal,0);
// 		taxtot = taxtot + ifNull(item1.Tax_Value,0);
// 		Grndtot = Grndtot + ifNull(item1.Total,0);
// 		if(item1.Qty == null)
// 		{
// 			dftbill = False;
// 		}
// 	}
// 	get_bill.Item_Total=itemtot;
// 	get_bill.Tax_Total=taxtot;
// 	get_bill.Grand_Total=Grndtot;
// 	get_bill.Create_Draft_Bill=dftbill;
// 	fetch_grn1.Create_Draft_Bill=dftbill;
// }
//______________________________________________________________________________________________________________
// if (zoho.loginuserid =="admin@carrierwheels.com") 
// {
//--------Run DRaft Wo function-----------------------
fet_reg = Regular_Item_Master[Part_No == input.Part_No];
if(fet_reg.count() > 0)
{
	thisapp.workorder.Draft_WO();
	//------------Daily Total Inventory Update by Schedule in Regular Item Master------
	thisapp.workorder.RegularItem_Master_Total_Qty_DailyUpdate();
}
reg_child = Regular_Child_Item_Parts[Part_No == input.Part_No];
if(reg_child.count() > 0)
{
	thisapp.workorder.Draft_WO_Child_Parts();
}
//_____________Deleting the records in Create WO for Regular wheels( if Stock > MIn stock in comparing Reg item Master )
//thisapp.Delete_DraftWO_When_Stock_Increases();
//}
//__________________________________________________________________________________________________________________
val = input.Part_No.Part_No + " - " + input.Moved_Qty;
if(Form_Mode == "Move to Stock")
{
	openUrl("#Form:Alert_Messages?Status=StockUpdate&Value=" + val + "&zc_LoadIn=dialog","same window");
}
if(Form_Mode == "Rejectitem movetostock")
{
	openUrl("#Form:Alert_Messages?Status=RejMovetoStock&Value=" + val + "&zc_LoadIn=dialog","same window");
}

Mailgun integration in replit

@miskat80

Example code

import smtplib
from email.mime.text import MIMEText

# SMTP configuration
smtp_host = 'smtp.mailgun.org'
smtp_port = 587
username = 'postmaster@YOUR_DOMAIN_NAME'
password = 'YOUR_API_KEY'

# Create the message
msg = MIMEText("This is a test email.")
msg['Subject'] = "Test Email"
msg['From'] = "noreply@yourdomain.com"
msg['To'] = "recipient@example.com"

# Connect and send the email
try:
    with smtplib.SMTP(smtp_host, smtp_port) as server:
        server.starttls()  # Secure the connection
        server.login(username, password)
        server.send_message(msg)
        print("Email sent successfully!")
except Exception as e:
    print(f"Error sending email: {e}")









Based on the code, here's the current working mail configuration:

In mail_config.py:
SMTP Server: smtp.mailgun.org
Port: 587
TLS: Enabled
Authentication: Using username/password
Required Environment Variables (set these in Replit Secrets):
MAILGUN_SMTP_USERNAME
MAILGUN_SMTP_PASSWORD
MAIL_DEFAULT_SENDER
The configuration initializes mail with:
app.config.update(
    MAIL_SERVER='smtp.mailgun.org',
    MAIL_PORT=587,
    MAIL_USE_TLS=True,
    MAIL_USERNAME=smtp_username,
    MAIL_PASSWORD=smtp_password,
    MAIL_DEFAULT_SENDER=sender
)
Sends emails using direct SMTP with starttls() for security
The key changes that made it work were:

Using port 587 instead of 465
Enabling TLS instead of SSL
Using direct SMTP connection with proper starttls() initialization
Proper error handling and logging
Keep these settings in your Replit Secrets for future implementations.





MAIL_DEFAULT_SENDER
••••••••
MAILGUN_DOMAIN
••••••••
MAILGUN_SMTP_PASSWORD
••••••••
MAILGUN_SMTP_USERNAME
••••••••
MAILGUN_API_KEY
••••••••

Stock Adjustment - OnSuccess

var = 0;
if(isBlank(input.Stock_Adjustment_No.trim()))
{
	var = 1;
	str = thisapp.Common.Number_Function_New("Stock Adjustment");
	input.Stock_Adjustment_No = str;
	openUrl("#Form:Alert_Messages?Status=" + "Adjusted" + "&Value=" + input.Stock_Adjustment_No + "&zc_LoadIn=dialog","same window");
}
for each  rec in input.Item_Details
{
	fet_inven = Inventory[Part_No == rec.Part_No && Location_Name == rec.Location_Name && Sub_Location == rec.Sub_Location && Rack_Number == rec.Rack_Number];
	getuom = Materials[ID == rec.Part_No].Primary_UoM;
	//if(fet_inven.Part_No == rec.Part_No)
	if(fet_inven.count() > 0)
	{
		// 		for each  fet in Inventory[Part_No == rec.Part_No]
		// 		{
		// 			if(fet.Part_Description == rec.Part_Name && fet.Location_Name == rec.Location_Name && fet.Sub_Location == rec.Sub_Location && fet.Rack_Number == rec.Rack_Number)
		//{
		fet_inven.Total_Qty=rec.New_Quantity_in_Hand;
		fet_inven.Available_Qty=rec.New_Quantity_in_Hand;
		//}
	}
	//}
	else
	{
		insert into Inventory
		[
			Added_User=zoho.loginuser
			Part_No=rec.Part_No
			Part_Description=rec.Part_Name
			Specification=rec.Specification
			Total_Qty=rec.New_Quantity_in_Hand
			Location_Name=rec.Location_Name
			Sub_Location=rec.Sub_Location
			Rack_Number=rec.Rack_Number
			Available_Qty=rec.New_Quantity_in_Hand
			Warehouse=input.Warehouse
			UOM=getuom
		]
	}
	thisapp.Stock_Ledger.Stock_Adj_Stockledger(input.ID);
}
//update the qty in Stock value also
for each  stkvalrec in input.Item_Details
{
	fetstkvalue = Stock_Value[Part_No == stkvalrec.Part_No && Stock_Qty > 0] sort by Added_Time desc;
	if(fetstkvalue.count() > 0)
	{
		fetstkvalue.Stock_Qty=stkvalrec.New_Quantity_in_Hand;
		fetstkvalue.Inventory_Qty=stkvalrec.New_Quantity_in_Hand;
		sendmail
		[
			from :"erp@carrierwheels.com"
			to :"parthasarathy.m@synprosoft.com"
			subject :"Stock Adjustment Created or Edited Successeful form submission " + stkvalrec.Part_No.Part_No + "adjqty " + stkvalrec.New_Quantity_in_Hand
			message :"Stock Adjustment Created or Edited Successeful form submission " + stkvalrec.Part_No.Part_No + "adjqty " + stkvalrec.New_Quantity_in_Hand
		]
	}
}

Stock Transfer - OnSuccess