by

Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Aug 10 2015 19:16

    eysteinn13 on master

    minor changes (compare)

  • Jul 30 2015 13:01

    eysteinn13 on master

    minor fix (compare)

  • Jul 29 2015 21:26

    eysteinn13 on master

    quicker tool adding buttin (compare)

  • Jul 28 2015 14:20

    eysteinn13 on master

    order by on tools and runs (compare)

  • Jul 28 2015 13:03

    eysteinn13 on master

    minor stuffs (compare)

  • Jul 27 2015 15:18

    eysteinn13 on master

    top notch tools menu (compare)

  • Jul 24 2015 13:27

    eysteinn13 on master

    minor css and MD (compare)

  • Jul 23 2015 19:43

    eysteinn13 on master

    markdown (compare)

  • Jul 23 2015 15:57

    eysteinn13 on master

    links in markdown (compare)

  • Jul 23 2015 15:54

    eysteinn13 on master

    perfect markdown (compare)

  • Jul 23 2015 15:51

    eysteinn13 on master

    letsgoo markdown (compare)

  • Jul 23 2015 15:43

    eysteinn13 on master

    MD (compare)

  • Jul 23 2015 15:37

    eysteinn13 on master

    flott (compare)

  • Jul 23 2015 15:28

    eysteinn13 on master

    this should work MD (compare)

  • Jul 23 2015 15:23

    eysteinn13 on master

    markdown (compare)

  • Jul 23 2015 15:13

    eysteinn13 on master

    markdown (compare)

  • Jul 23 2015 15:10

    eysteinn13 on master

    markdown merge (compare)

  • Jul 23 2015 14:58

    Freyr12 on master

    gitignore (compare)

  • Jul 22 2015 21:25

    eysteinn13 on master

    markdown stuffery merge (compare)

  • Jul 22 2015 21:17

    Freyr12 on master

    double ended stuff (compare)

Freyr12
@Freyr12
er ekki med gp i tolvunni
Eysteinn Gunnlaugsson
@eysteinn13
áman usb kjell
Freyr12
@Freyr12
er ad brusha up a tech n9ne
Eysteinn Gunnlaugsson
@eysteinn13
góður
Eysteinn Gunnlaugsson
@eysteinn13
Freyr12
@Freyr12
hehehe, fekk btw email um ad eg aetti unread message herna
Freyr12
@Freyr12
INSERT INTO xx_BLOB(ID,IMAGE) VALUES(1,LOAD_FILE('E:/Images/jack.jpg'));
Eysteinn Gunnlaugsson
@eysteinn13
CREATE TABLE discount(
discount_ID INT NOT NULL,
lineitem_ID INT NOT NULL,
number_of_tools INT NOT NULL,
discount DOUBLE NOT NULL,
discount_reason VARCHAR(10000),
PRIMARY KEY (discount_ID),
FOREIGN KEY(lineitem_ID) REFERENCES lineitem(lineitem_ID)
);
Freyr12
@Freyr12
SELECT m.machine_ID, p.po_ID, r.run_ID
FROM machine m, pos p, run r, lineitem l
WHERE m.machine_ID = r.machine_ID;
Freyr12
@Freyr12
git update-index --no-assume-unchanged <filename>
Freyr12
@Freyr12

SELECT SUM(ROUND(l.price * l.quantity, 2)), COUNT(p.po_ID)
FROM coating c, pos p, run r, lineitem l, lineitem_run lir, pos_run pru
WHERE c.coating_ID = r.coating_ID
AND r.run_ID = lir.run_ID
AND lir.lineitem_ID = l.lineitem_ID
AND l.po_ID = p.po_ID
AND pru.po_ID = p.po_ID
AND r.run_ID = pru.run_ID
AND p.po_ID NOT IN (SELECT po_ID
FROM pos
WHERE shipping_date IS NULL);

SELECT COUNT(*)
FROM pos;

Eysteinn Gunnlaugsson
@eysteinn13
SELECT
i.id,
p.amount,
pa.amount
FROM items AS i
LEFT JOIN (SELECT
id,
item_id,
SUM(amount) amount
FROM payments
GROUP BY item_id) AS p
ON p.item_id = i.id
LEFT JOIN (SELECT
payment_id,
sUM(amount) amount
FROM payment_actions) AS pa
ON pa.payment_id = p.id
group by i.id
SELECT
  i.id,
  p.amount,
  pa.amount
FROM items AS i
  LEFT JOIN (SELECT
           id,
           item_id,
           SUM(amount)    amount
         FROM payments
         GROUP BY item_id) AS p
    ON p.item_id = i.id
  LEFT JOIN (SELECT
           payment_id,
           sUM(amount)    amount
         FROM payment_actions) AS pa
    ON pa.payment_id = p.id
group by i.id
Eysteinn Gunnlaugsson
@eysteinn13
SELECT SUM(l.quantity), SUM(p.amount)
FROM lineitem AS l
  LEFT JOIN (SELECT lineitem_ID, discount_ID, SUM(number_of_tools) AS amount
         FROM discount
         GROUP BY lineitem_ID) AS p
    ON l.lineitem_ID = p.lineitem_ID, pos
WHERE pos.po_ID = l.po_ID
GROUP BY pos.customer_ID;
Eysteinn Gunnlaugsson
@eysteinn13
INSERT INTO pos(po_number, customer_ID, receiving_date, initial_inspection, final_inspection, nr_of_lines, shipping_date, final_price, shipping_info) VALUES ('ponumber0', 1, '2015-5-8', 'initial inspection', 'final inspection', 10, '2015-06-06', 500, 'Ground');
Eysteinn Gunnlaugsson
@eysteinn13
INSERT INTO lineitem(line_on_po, po_ID, quantity, price, tool_ID, diameter, length, double_end, coating_ID, est_run_number) VALUES (1,168, 20, 3.50, 'TESTTOOL168', '3/8', 3, 1, 5, 0.50);
INSERT INTO lineitem(line_on_po, po_ID, quantity, price, tool_ID, diameter, length, double_end, coating_ID, est_run_number) VALUES (1,168, 20, 3.50, 'TESTTOOL168', '3/8', 3, 1, 5, 0.50);
Freyr12
@Freyr12
/Users/Frooze/Documents/220px-Linus_Torvalds.jpeg
Eysteinn Gunnlaugsson
@eysteinn13
UPDATE price SET amount = x WHERE customer_ID = 1 AND diameter = 1/8 AND length = 2;
Freyr12
@Freyr12
SELECT l.price
FROM lineitem l, pos p
WHERE l.po_ID = p.po_ID
AND l.tool_ID = 'VAN5EM24'
AND p.receiving_date = (SELECT MAX(p1.receiving_date)
                        FROM pos p1)
GROUP BY l.tool_ID
Freyr12
@Freyr12
export PATH=$PATH:/usr/local/mysql/bin
Eysteinn Gunnlaugsson
@eysteinn13
<?php
    echo "<h1>Example with php</h1><br>";
?>
<select name="hall" id="hall">
<?php
    $default = 3;
    $nr = 1;
    while($nr < 10){
        if($nr == $default){
            echo "<option selected=\"selected\">". $nr ."</option>";
        }
        else{
            echo "<option>". $nr ."</option>";
        }
        $nr++;
    }
?>
</select>
Freyr12
@Freyr12
sudo lsof -P -n -iTCP -sTCP:LISTEN
Eysteinn Gunnlaugsson
@eysteinn13
SELECT MONTH(shipping_date), count(p.po_ID), ROUND(AVG(final_price), 2), ROUND(AVG(TOTAL_WEEKDAYS(shipping_date, receiving_date)), 2), ROUND(SUM(p.final_price), 2), c.customer_name
FROM pos p, customer c
WHERE p.customer_ID = c.customer_ID
AND p.po_ID NOT IN (SELECT po_ID
FROM pos
WHERE shipping_date IS NULL)
GROUP BY YEAR(shipping_date), MONTH(shipping_date) DESC;
SELECT MONTH(shipping_date), count(p.po_ID), ROUND(AVG(final_price), 2), ROUND(AVG(TOTAL_WEEKDAYS(shipping_date, receiving_date)), 2), ROUND(SUM(p.final_price), 2), c.customer_name
FROM pos p, customer c
WHERE p.customer_ID = c.customer_ID 
AND p.po_ID NOT IN (SELECT po_ID
                               FROM pos
                             WHERE shipping_date IS NULL) 
GROUP BY YEAR(shipping_date), MONTH(shipping_date) DESC;
FOKK
Freyr12
@Freyr12
if (mysqli_num_rows($lineitemResult) == 0) {
    die("Error! There is no Line item: ".$line_on_po);
}
Freyr12
@Freyr12
process.env.PATH = ["/usr/local/bin", process.env.PATH].join(":")
Eysteinn Gunnlaugsson
@eysteinn13
@Freyr12 er noob
code
code
SELECT MONTH(shipping_date), count(p.po_ID), ROUND(AVG(final_price), 2), ROUND(AVG(TOTAL_WEEKDAYS(shipping_date, receiving_date)), 2), ROUND(SUM(p.final_price), 2), c.customer_name
FROM pos p, customer c
WHERE p.customer_ID = c.customer_ID 
AND p.po_ID NOT IN (SELECT po_ID
                               FROM pos
                             WHERE shipping_date IS NULL) 
GROUP BY YEAR(shipping_date), MONTH(shipping_date) DESC;
SELECT MONTH(shipping_date), count(p.po_ID), ROUND(AVG(final_price), 2), ROUND(AVG(TOTAL_WEEKDAYS(shipping_date, receiving_date)), 2), ROUND(SUM(p.final_price), 2), c.customer_name FROM pos p, customer c WHERE p.customer_ID = c.customer_ID AND p.po_ID NOT IN (SELECT po_ID FROM pos WHERE shipping_date IS NULL) GROUP BY YEAR(shipping_date), MONTH(shipping_date) DESC;
Eysteinn Gunnlaugsson
@eysteinn13
ert tu ad gera machine?
Eysteinn Gunnlaugsson
@eysteinn13
Eysteinn Gunnlaugsson
@eysteinn13
  var e = document.getElementById("shipping_sel");
  var shipping_info = e.options[e.selectedIndex].value;
$('#neym').attr('value')
$('#neym').attr('value')
Eysteinn Gunnlaugsson
@eysteinn13
Eysteinn Gunnlaugsson
@eysteinn13
hvaða view ert þú að gera?
Freyr12
@Freyr12
er að gera in progress listann núna og modal fyrir purchase orderin þar
enþu?
Eysteinn Gunnlaugsson
@eysteinn13
éébara eh suppliera
leiðinlegt með engin gögn
Freyr12
@Freyr12
en þu getur samt auðveldlega addað suppliers núna, einhver snillingur henti þeim fítus inn í gær
Eysteinn Gunnlaugsson
@eysteinn13
Já það var eh king. Er meira meina svona average lean time, average time í invoice og þess háttar
Freyr12
@Freyr12
skil þig gaur