Ejemplo n.º 1
0
function mkTTorder($id, $evids, $trans_id)
{
    $tt = getOneTT($id, $false);
    $vendcust = $tt['tab'] == 'C' ? 'customer' : 'vendor';
    //Steuerzone ermitteln (0-3)
    $sql = "SELECT taxzone_id FROM " . $vendcust . " WHERE id = " . $tt["fid"];
    $rs = $_SESSION['db']->getOne($sql);
    $tzid = $rs["taxzone_id"];
    $TAX = getTax($tzid);
    //Artikeldaten holen
    $sql = "SELECT * FROM parts WHERE partnumber = '" . $_SESSION['ttpart'] . "'";
    $part = $_SESSION['db']->getOne($sql);
    $partid = $part["id"];
    $sellprice = $part["sellprice"];
    $unit = $part["unit"];
    //Steuersatz ermitteln
    $tax = $TAX[$part["buchungsgruppen_id"]];
    $curr = getCurr(True);
    //Events holen
    $events = getTTEvents($id, false, $evids, True);
    if (!$events) {
        return ".:nothing to do:.";
    }
    if (!$evids) {
        $evids = 'and t.id in (';
        foreach ($events as $row) {
            $tmp[] = $row['id'];
        }
        $evids .= implode(',', $tmp) . ') ';
    }
    $_SESSION['db']->begin();
    if ($trans_id < 1) {
        //Auftrag erzeugen
        $sonumber = $tt['tab'] == 'C' ? nextNumber("sonumber") : nextNumber("ponumber");
        if (!$sonumber) {
            return ".:error:.";
        }
        $sql = "INSERT INTO oe (notes,transaction_description,ordnumber," . $vendcust . "_id,taxincluded,currency_id) ";
        $sql .= "VALUES ('" . $tt["ttdescription"] . "','" . $tt["ttname"] . "',{$sonumber},'" . $tt["fid"] . "','f',";
        $sql .= "coalesce((SELECT currency_id FROM " . $vendcust . " WHERE id = " . $tt['fid'] . "),{$curr}))";
        $rc = $_SESSION['db']->query($sql, "newOE");
        if (!$rc) {
            $sql = "DELETE FROM oe WHERE ordnumber = '{$sonumber}'";
            $rc = $_SESSION['db']->query($sql, "delOE");
            return ".:error:. 0";
        }
        $sql = "SELECT id FROM oe WHERE  ordnumber = '{$sonumber}'";
        $rs = $_SESSION['db']->getOne($sql);
        $trans_id = $rs["id"];
        if ($trans_id <= 0) {
            $sql = "DELETE FROM oe WHERE ordnumber = '{$sonumber}'";
            $rc = $_SESSION['db']->query($sql, "delOE");
            return ".:error:. 0";
        }
        $netamount = 0;
    } else {
        $sql = "SELECT * from oe WHERE id = " . $trans_id;
        $rc = $_SESSION['db']->getOne($sql, '');
        if (!$rc) {
            return ".:error:. 00";
        }
        $netamount = $rc['netamount'];
    }
    //$sql_i = 'INSERT INTO orderitems (trans_id, parts_id, description, qty, sellprice, unit, ship, discount,serialnumber,reqdate) values (';
    $fields = array('trans_id', 'parts_id', 'description', 'qty', 'sellprice', 'unit', 'ship', 'discount', 'serialnumber', 'reqdate');
    foreach ($events as $row) {
        if ($row["ttstop"] == "") {
            $_SESSION['db']->rollback();
            return ".:close event:.";
        }
        $t1 = strtotime($row["ttstart"]);
        $t2 = strtotime($row["ttstop"]);
        //Minuten
        $diff = floor(($t2 - $t1) / 60);
        //Abrechnungseinheiten
        $time = floor($diff / $_SESSION['tttime']);
        //Ist der Rest über der Tolleranz
        if ($diff - $_SESSION['tttime'] * $time > $_SESSION['ttround']) {
            $time++;
        }
        $price = $time * $sellprice;
        //Orderitemseintrag
        $rqdate = substr($row['ttstop'], 0, 10);
        $values = array($trans_id, $partid, $row["ttevent"], $time, $sellprice, $unit, 0, 0, $diff, $rqdate);
        //$sql = $sql_i."$trans_id,$partid,'".$row["ttevent"]."',$time,$sellprice,'$unit',0,0,'$diff','".substr($row['ttstop'],0,10)."')";
        //$rc = $_SESSION['db']->query($sql);
        $rc = $_SESSION['db']->insert('orderitems', $fields, $values);
        if (!$rc) {
            $_SESSION['db']->rollback();
            return ".:error:. 1";
        }
        $netamount += $price;
        $amount += $price * $tax;
        $parts = getTTparts($row["id"]);
        if ($parts) {
            foreach ($parts as $part) {
                $values = array($trans_id, $part['parts_id'], $part['parts_txt'], $part['qty'], $part['sellprice'], $part['unit'], 0, 0, Null, $rqdate);
                $rc = $_SESSION['db']->insert('orderitems', $fields, $values);
                if (!$rc) {
                    $_SESSION['db']->rollback();
                    return ".:error:. 2";
                }
                $netamount += $part['qty'] * $part['sellprice'];
                $amount += $part['qty'] * $part['sellprice'] * $TAX[$part['buchungsgruppen_id']];
            }
        }
    }
    //OE-Eintrag updaten
    $nun = date('Y-m-d');
    //$amount = $netamount + $mwst;
    $fields = array('transdate', 'amount', 'netamount', 'reqdate', 'notes', 'employee_id');
    $values = array($nun, $amount, $netamount, $nun, $tt["ttdescription"], $_SESSION["loginCRM"]);
    $rc = $_SESSION['db']->update('oe', $fields, $values, 'id = ' . $trans_id);
    if (!$rc) {
        $_SESSION['db']->rollback();
        return ".:error:. 2";
    } else {
        //Events als Abgerechnet markieren.
        $sql = "UPDATE tt_event t set cleared = {$trans_id} where t.ttid = {$id} {$evids}";
        $rc = $_SESSION['db']->query($sql);
        $_SESSION['db']->commit();
        return ".:ok:.";
    }
}
Ejemplo n.º 2
0
function listTevents($id, $fid = 0, $tab)
{
    $events = getTTEvents($id, "a", false);
    if ($tab == 'C') {
        $link = "<a href='../oe.pl?action=edit&type=sales_order&vc=customer&id=%d&callback=crm/timetrack.php%%3ffid={$fid}'>";
    } else {
        $link = "<a href='../oe.pl?action=edit&type=purchase_order&vc=vendor&id=%d&callback=crm/timetrack.php%%3ffid={$fid}'>";
    }
    if (!$events) {
        echo json_encode(array('ok' => 0));
    }
    $tt = getOneTT($events[0]["ttid"]);
    $liste = "<form name='cleared' method='post' action='timetrack.php'>";
    $liste .= "<input type='hidden' name='tid' value='" . $events[0]["ttid"] . "'>";
    $liste .= "<table>";
    $i = 0;
    $now = time();
    $diff = 0;
    $lastcleared = 0;
    if ($events) {
        foreach ($events as $row) {
            $a = explode(" ", $row["ttstart"]);
            $t1 = strtotime($row["ttstart"]);
            if ($row["ttstop"]) {
                $b = explode(" ", $row["ttstop"]);
                $stop = db2date($b[0]) . " " . substr($b[1], 0, 5);
                $t2 = strtotime($row["ttstop"]);
            } else {
                if ($t1 <= $now) {
                    $t2 = $now;
                } else {
                    $t2 = $t1;
                }
                $stop = "<a href='timetrack.php?tid=" . $row["ttid"] . "&eventid=" . $row["id"] . "&stop=now'><b>" . translate('.:stop now:.', 'work') . "</b></a>";
            }
            $min = $t2 - $t1;
            $diff += $min;
            $i++;
            if ($row["cleared"] > 0) {
                $clear = "<td class='klein'>-</td>";
                if ($row['cleared'] > $lastcleared) {
                    $lastcleared = $row['cleared'];
                }
            } else {
                if ($row["uid"] == $_SESSION["loginCRM"]) {
                    $clear = "<td><input type='checkbox' name='clear[]' value='" . $row["id"] . "'></td>";
                } else {
                    $clear = "<td>+</td>";
                }
            }
            $liste .= "<tr class='calls" . $i % 2 . "' onClick='editrow(" . $row["id"] . ");'>{$clear}<td>" . db2date($a[0]) . " " . substr($a[1], 0, 5) . "</td>";
            $liste .= "<td>" . $stop . "</td><td align='right'>" . floor($min / 60) . "</td><td>" . $row["user"] . "</td><td>";
            if (strlen($row["ttevent"]) > 40) {
                $liste .= substr($row["ttevent"], 0, 40) . "...</td><td>";
            } else {
                $liste .= $row["ttevent"] . "</td><td>";
            }
            $liste .= sprintf($link, $row['cleared']) . $row["ordnumber"] . "</a>";
            if ($row['closed'] == 't') {
                $liste .= "*";
            }
            $liste .= "</td></tr>";
        }
    }
    $diff = floor($diff / 60);
    if ($tt["aim"] > 0) {
        $rest = $tt["aim"] * 60 - $diff;
        $rstd = floor($rest / 60);
        $rmin = $rest % 60;
        $rest = translate('.:remain:.', 'work') . " {$rstd}:{$rmin} " . translate('.:hours:.', 'work');
    } else {
        $rest = "";
    }
    if ($diff > 60) {
        $min = sprintf("%02d", $diff % 60);
        $std = floor($diff / 60);
        $use = "{$std}:{$min} " . translate('.:hours:.', 'work');
    } else {
        $use = $diff . " " . translate('.:minutes:.', 'work');
    }
    $liste .= "</table><input type='checkbox' name='clrok' value='1'>" . translate(".:all:.", 'work') . " ";
    if ($lastcleared > 0) {
        $liste .= "<input type='radio' name='order' value='0' checked>" . translate('.:new Order:.', 'work') . ' ';
        $liste .= "<input type='radio' name='order' value='{$lastcleared}'>" . translate('.:add to last Order:.', 'work') . ' ';
    }
    $liste .= "<input type='submit' name='clr' value='" . translate(".:clearing:.", "work") . "'></form>";
    echo json_encode(array('liste' => $liste, 'used' => $use, 'rest' => $rest, 'ok' => 1));
}