Skip to content

Instantly share code, notes, and snippets.

View ndphuong's full-sized avatar

Phuong ndphuong

  • leadsoft
  • Ho Chi Minh city
View GitHub Profile
@ndphuong
ndphuong / azure fundametals
Created October 19, 2022 09:17
azure fundamentals
‎‎​
@ndphuong
ndphuong / katzkin dar.md
Last active September 12, 2022 09:56
katzkin dar

dar process

  • get all reconciliation for
  • get all orders with
    • not fully paid all time: orderDetail.Sale + orderDetail.ShippingCharges - orderDetail.AmountPaid - orderDetail.Credit <> 0
    • or InvoiceDate > begin of year
    • or invoice reconciliation in the datetime
@ndphuong
ndphuong / katzkin installation.md
Last active August 25, 2022 04:19
katzkin installation

RETAIL INSTALLATION

Post check button

apply for current selected InstallationPayment

  • if InstallationPayment.CheckNumber is empty => just update the check number, check amount to current InstallationPayment
    • InstallationPayment.CheckNumber = input
    • InstallationPayment.CheckAmount = input
  • else, aleady existed check number in current InstallationPayment, add new record to InstallationPaymentAdditionalChecks
    • IdInstallationPayment
  • CheckNumber (manual input)
@ndphuong
ndphuong / katzkin refund flow.md
Last active August 19, 2022 10:51
katzkin refund flow

graph TD A[Click refund/adjust] -->|Input information, calculate refund or charge more amount| B(Click submit) B --> C{"Full refund or Partial refund?"} C -->|Full refund| D[Refund money via Chargent] D --> D1[Add CreditMemo for each item without Return check] D1 --> D2[Add new Cancelation invoice] C -->|Partial refund with kit| E{Check new kit price} E --> |old price > new price| E1[Refund money via Chargent] E1 --> E2[Add new Cancelation invoice] C -->|Partial refund without kit| F[Refund money via Chargent]

@ndphuong
ndphuong / katzkin_cheatsheets.md
Last active October 6, 2022 08:16
katzkin_cheatsheets

A Tracking is Delux or Regular:

select LeatherContents.code as Deluxe from productions inner join LeatherContents on productions.idSeatLeatherContent = IdLeatherContent

Order detail amount

TotalAmount = (Price + LogoRoyalty) * Qty + ShippingCharges + CreditCardFee Sale = TotalAmount - orderDetail1.ShippingCharges

@ndphuong
ndphuong / whitecloud_programs
Last active August 22, 2022 04:13
whitecloud_programs
1. Sqlserver
- Schedule job:
+ OloeLostOrder: SqlServer\Administrator
+ DbfToSql : domain\services
+ InvoiceToPdf : domain\services
+ Katzkin Backup every hour : domain\jorge
- IIS/Application Pools
+ DefaultApplicationPool: domain\services
+ RDWebAccress : ApplicationPoolIdentity
@ndphuong
ndphuong / whitecloud ltl shipping.md
Created June 22, 2022 03:35
whitecloud ltl shipping

‎‎​

@ndphuong
ndphuong / whitecloud retail reconciliation
Last active June 21, 2022 10:05
whitecloud retail reconciliation
Charge setlled => create new Payment
Refund setlled
=>
- create new Credit memo
- reduce payment???
=> or create three Credit memo
- Installation price credit memo
- Tax credit memo
- Kit credit memo
Invoice placed
@ndphuong
ndphuong / whitecloud salesforce.md
Last active July 21, 2022 06:46
whitecloud salesforce

from Order, click send payment request

  • lack Payment Request Transaction Type on UI
  • choose Gateway type

an email will send to customer (email in contact first, if not exist contact, send to custom Recipient email)

  • auto create one ChargentOrder with amount = amount on payment request
    • link to Order via Order_c
    • Balance Due = amount
    • Empty Credit card info
  • auto create two payment requests (link to above ChargentOrder)
@ndphuong
ndphuong / whitecloud print shipping label
Last active June 8, 2022 10:30
whitecloud Print Shipping Label flow
PrintPackingList
TJ, DK, CT, TX, IN, CA: invoke DoShipping to create shipping request on Fedex or UPS
NJ, BO, TA: not invoke DoShipping
TJ: add EmailReports with type P and FU (maybe add FED too)
TA: print pdf directly to printer
NJ: print pdf directly to printer
BO: print pdf directly to printer
TX: add EmailReports with type P and FU
IN: add EmailReports with type P and FU