Untitled

-- *********************************************************************
-- Update Database Script
-- *********************************************************************
-- Change Log: C:/it4em-web-project/it4em-backend/war-backend/war-backend-it4em-teck/target/war-backend-it4em-teck-0.2.644-SNAPSHOT/WEB-INF/classes/db/changelog/oracle-changelog-master-for-teck.yaml
-- Ran at: 28.09.17 12:13
-- Against: KOPDEV@jdbc:oracle:thin:@kvm224.waw.eo.pl:1521:TECKDEV
-- Liquibase version: 3.4.2
-- *********************************************************************

SET DEFINE OFF;

-- Lock Database
UPDATE DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = 'DESKTOP-OQA5G86 (192.168.6.103)', LOCKGRANTED = to_timestamp('2017-09-28 12:13:59.247', 'YYYY-MM-DD HH24:MI:SS.FF') WHERE ID = 1 AND LOCKED = 0;

-- Changeset db/changelog/changesets/it4em-teck/initial-data.yaml::TECKWP - insert template for supplies order sending mail::krzysztof.lakomy
INSERT INTO GEN_MESSAGE_TEMPLATE(TEMPLATE_ID,TEMPLATE_TYPE,CONTENT_TYPE,TEMPLATE_TEXT,LANG,ACTIVE_FLAG,STATUS) VALUES((SELECT MAX(TEMPLATE_ID)+1 FROM GEN_MESSAGE_TEMPLATE), '2', 'text/html', '<html>
<head>
  <title>Supplies Order</title>
  <style>
    body {font-family:arial;font-size:10pt;}
  </style>
</head>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td align="center">
      <table width="580" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td>
            <table width="580" border="0" cellspacing="10" cellpadding="0">
              <tr>
                <td class="header" height="84" > <img src="cid:$csBag.get("COMPANY_LOGO").toString()" alt="DPD Logo"/></td>
              </tr>
              <tr>
                <td>
                  <p><span lang=CS>Welcome,</span></p>
                  #if($csBag.getSize("SUPPLIES_ORDERING_ITEMS")>0)
                  Below there is a supplies order created by <span>$csBag.get("CUSTOMER_NAME")</span> containg items and their amounts. <br/>
                  #end
                </td>
              </tr>
            </table>
            <tr>
              <td>
                #if($csBag.getSize("SUPPLIES_ORDERING_ITEMS")>0)
                <table width="50%" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td>Customer Id</td>
                    <td>$csBag.get("CUSTOMER_ID")</td>
                  </tr>
                  <tr>
                    <td>Customer Name</td>
                    <td>$csBag.get("CUSTOMER_NAME")</td>
                  </tr>
                  <tr>
                    <td>Default PickUp Address</td>
                    <td>$csBag.get("DEFAULT_PICKUP_ADDRESS")</td>
                  </tr>
                  <tr>
                    <td>Total sum</td>
                    <td>$csBag.get("TOTAL_SUM")</td>
                  </tr>
                </table>
              </td>
            </tr>
            <tr>
              <td>
               <span>Supplies Order</span>
             </td>
           </tr>


           <tr>
            <td>
              <table>
                <tr>
                 <td>Product name</td>
                 <td>Product amount</td>
                 <td>Price per unit</td>
                 <td>Total price for item</td>
               </tr>
               #set($item = $csBagIter.wrap($csBag,"SUPPLIES_ORDERING_ITEMS"))
               #foreach($coreData in $item)
               <tr>
                 <td>$csBag.get("SUPPLIES_ORDERING_ITEMS",$velocityCount,"PRODUCT_NAME")</td>
                 <td>$csBag.get("SUPPLIES_ORDERING_ITEMS",$velocityCount,"PRODUCT_AMOUNT")</td>
                 <td>$csBag.get("SUPPLIES_ORDERING_ITEMS",$velocityCount,"PRODUCT_UNIT_PRICE")</td>
                 <td>$csBag.get("SUPPLIES_ORDERING_ITEMS",$velocityCount,"PRODUCT_TOTAL_PRICE")</td>
               </tr>
               #end
             </table>
             #end
           </td>
         </tr>
         <tr>
           <td>
             If you have any question, please do not hesitate to contact our Customer Service Line +420 841 700 700.<br/>
             In case supplies order listed above is not congruent, please inform <span>$csBag.get("CUSTOMER_NAME")</span> in time sending information to
             <a href="mailto:$csBag.get("CUSTOMER_EMAIL")" target="_blank"> $csBag.get("CUSTOMER_EMAIL")</a>.<br/>
           </p>
           <p></p>
           <p class=MsoNormal><span lang=EN>Best regards, <o:p></o:p></span></p>
           <p></p>
           <p class=MsoNormal><span lang=CS>
            DPD FR, Direct Parcel Distribution FR s.r.o.<br>
            Phone: +420 841 700 700<br>
            E-mail: $csBag.get("CUSTOMER_EMAIL")<br>
            $csBag.get("DPD_WEB")<br>
          </o:p>
        </span></p>
        <p>&nbsp;</p>
      </td>
    </tr>
  </table>
</td>
</tr>
</table>
</body>
</html>', 'EN', 1, 1);

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('TECKWP - insert template for supplies order sending mail', 'krzysztof.lakomy', 'db/changelog/changesets/it4em-teck/initial-data.yaml', SYSTIMESTAMP, 4166, '7:824017b530cee63370d1efea1a0a4a79', 'sqlFile', '', 'EXECUTED', NULL, NULL, '3.4.2');

-- Release Database Lock
UPDATE DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;